I have a sharepoint list with a multi-person column. When a new item is entered, I have a flow create a new item in another sharepoint list and parse each person from the first sharepoint list into a unique item in the new sharepoint list. I then want to send an email to each person from the new list. All this works; however, the flow never stops. It is in an infinite loop. Please advise what I need to integrate so it will stop running after the last email is sent.
Do you want to create item from ListA to ListB, then send an email to each person from the ListB?
I have made a simple flow for testing. There is a multiple selections enabled Person or group column in ListB. When an item is created in ListB, create an item in ListA, then send an email to each person from ListA.
It is configured likes below and the issue you mentioned didn’t occur.
Could you check on which action the flow keeps on running?
If possible, please share a whole screenshot of your flow to help reproduce the issue?
From the screenshot you provided before, it seems that you have several Apply to each actions, what are the actions included in Create new item in Dates Tracking SP list and Apply to each 3?
@v-yamao-msft Thanks for your reply. I have paste a clip of the Flow in edit mode and after a run. My impression is that is continuing to run due to the Email with Options.... action.
Thanks for providing the detailed screenshot.
Your last action is Send an email with options. The flow won’t end until the approver submit a response.
Please suggest the Approver check his/her inbox and submit a response from the email by selecting an option.
Is it possible to add a Do Until feature and have it stop running after all emails are sent to the Approvers? Thinking maybe a count of approvers as a variable .. Not sure if and how to make that work but it doesn't seem practical to have it continually running. Part of the purpose of this is to automate reminders to the approvers if they do not approve within 48 hours. They do not have to approve in a particular order but all included must approve. The reason for Email with Options rather than Approval is the requirement to be able to attach files.
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications