Hi @advertisingfil,
Did the solutions that you provided work well?
Could you please share a bit more about your two SharePoint lists?
I think it is not necessary to add a SharePoint list to store the responses of Microsoft Form, we only need to create a SharePoint list (List_B) to store the participants of my Microsoft Form survey. The data structure of my List_B as below:
Note: The Participant column is a Person or group type column, which is used to store participants of my Microsoft Form survery.
I have made a test on my side and the flow works well. Please take a try with the following workaround:
- Add a "When a new response is submitted" trigger.
- Add a "Apply to each", input parameter set to output of the trigger.
- Within "Apply to each", add a "Get response details" action. Then add a "Get items" action, specify Site Address and List Name set to List_B.
Add a "Apply to each 2" action, input parameter set to output of "Get items" action, Within "Apply to each 2" action, add a Condition, left input box set to Participant Email dynamic content of "Get items" action, right input box set to Responders' Email dynamic content of "Get response details" action. In middle drop down, choose is equal to.
Within "If/yes" branch of "Apply to each 2" action, add a "Delete item" action.
- Under "Apply to each" action, add a "Delay" action, Count set to 2, Unit set to Day. On my side, Unit set to Minute for testing.
- Add a "Get items 2" action, specify Site Address and List Name set to List_B.
- Add a "Apply to each 3" action, input parameter set to output of "Get items 2" action. Within "Apply to each 3" action, add a "Send an email" action, To field set to Participant Email dynamic content of "Get items 2" action.
Image reference:
The flow works successfully as below:
Best regards,
Kris
