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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.