Flow running multiple times and sending countless emails for the same item.

[ASLR]

Created a flow for an item in SharePoint 

The intention of the Flow is to send an email approval in the event a user decides to Cancel a created item. 

There is a cancel choice field with just one option Yes so the flow only runs if selected. The flow is doing what it should be doing however it is sending out the same email multiple times for instance 5 times. 

Here's what I did: 

Not sure why it's sending the approval email repeatedly. 

This should be sent once. Also the Flow should only be sent when Yes is selected for Cancel. 

Any ideas why this is sending multiple emails?

Many thanks. 

[v-xida-msft]

Hi @ASLR,

How many times does your flow run when an item is modified?

I have made a test on my side and don’t have the issue that you mentioned. My flow’s configuration as below:

 The flow works successfully as below and it sends out an approval email:

Besides, please check if you have modified Cancel filed of multiple records in SharePoint list. Also please check if other items have been created with Yes is selected for Cancel field.

Best regards,

Kris

[ASLR]

Update:  I've created a completely different list to handle the approval and it shoots out one email as it should be doing. However, I am trying to update the next list with the outcome such as cancellation approved but it's not.

The issue is the ID in the current cancel list is different to the ID in the next list. Therefore, it is not linking the same record but not too sure how to do this in Flow. Flow is not allowing me to see the next list unique's ID as well as pick anything else than the ID from the current list.

I know in SharePoint Designer I could select the two identifiers to link the record but how can I do this in Flow? 

Regards, 

[ASLR]

I have two list Parent List - Leave List, Child List - Cancel Request 

When an item is selected in the Parent list to cancel, it creates an item in the Cancel Request list to do an email approval to cancel the item. This cancellation is now working because I'm not doing any modification to the cancel list otherwise. However, once the email request is approved or rejected from the email I will like the flow to update the Parent list column to Cancellation Approved. 

Parent List Colums: ( Leave Requests) 

ID 

Employee

Department 

Leave 

StartDate

EndDate 

Cancellation Status

Child List Columns ( Cancel Requests) 

ID 

Employee

Department

Leave 

Start Date 

End Date 

The child fields are being populated using a create an item in another list within the SharePoint Designer when Cancel is selected in the Parent list. 

Is there a way when the approval email is completed for the Cancel Request list via the email, the Parent List ( Leave Request's cancellation status field is updated with "Cancellation Approved"? 

Please see the steps I took trying to do so but it's actually not updating the Parent List cancellation list. Any suggestions would be very helpful.