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.
Thank you.
Hi @tianaranjo,
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.
Best regards,
Mabel
@v-yamao-msft Interesting - mine continues to run. I just realized I failed to 'cancel' one test and it has been running for 29 day.
@JonL Flow Master Jon - any thoughts why Mabel's works no issue and mine would keep running?
All troubleshooting tips greatly appreciated!
Hi @tianaranjo,
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?
Best regards,
Mabel
@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.
Hi @tianaranjo,
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.
Best regards,
Mabel
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.
User | Count |
---|---|
16 | |
16 | |
14 | |
9 | |
8 |
User | Count |
---|---|
27 | |
26 | |
24 | |
23 | |
14 |