Power Automate Flow Trigger Results in Multiple Emails Sent

[Quwyr]

Dear all,

I hope you are well! 

I'm currently working on the Power Up Final App Challenge for which I am on the Power Automate part now. However, I can't seem to resolve this issue that I am experiencing.

Here's my current Power Automate Flow for reference.

In the Canvas app, the user will to select the row of the animal that they are interested to foster, and they will afterwards fill up the Fosterer Name and the "FosterClaimer" field will auto-populate with the Foster ID. 

Upon submission, the flow should run and the email should be sent out. However, I am getting 2 of the same emails being sent, of which I am not too sure why that is the case, and I've been stuck here for quite a while.

The below is my OnSuccess property for my form: 

Patch(
    Animals,
    LookUp(Animals,
    jh_animalsid = Form1.LastSubmit.Animals),
    {
        ShelterStatus: 'ShelterStatus (Animals)'.'Claimed for foster',
        DateClaimedforFoster: DateValue1.SelectedDate
    }
);
Notify("Form submitted successfully",NotificationType.Success)

Appreciate any help or guidance on this. 

Thank you.

[BCBuizer · Accepted solution]

Hi @Quwyr ,

There are multiple things that can cause this to happen, but the first thing I'd check is if the form is connected to the same data source as the Patch: this would result in two updates and hence two emails.

The flow run history of the flow that sends out the mails should yield some clues as well, so I'd check that if I were you.

[Quwyr]

Hi @BCBuizer ,

Many thanks for your response! I have checked the Source for my form, and it does not seem like there is no DataSource connected:

I'll have an in-depth look at the flow run history. What would you suggest that I should take extra note of, in this case?

[BCBuizer]

Hi @Quwyr ,

Please restart Power Apps studio and check the DataSource property of the form again as it should not be blank. Perhaps something similar is going on as in this topic: Solved: Patch Formula with Entering Foster Claimer Text - Power Platform Community (microsoft.com)

As per my previous suggestion indeed check the flow history. This should reveal if it's the same flow that is triggered twice or there is a second flow that is triggered in the background.

[Quwyr]

Hi @BCBuizer ,

Thanks for your input! I went through the flow run history, and I added a filter for the 'Claimed for foster' status so that it would only be fired upon the status change of that column and it was resolved. 🙂 

Many thanks again!