Need some input on the following:
I've created a sharepoint list to capture training attendance. Every time a training is organized a single record is added to the list containing topic/location/attendees/flow status etc.
Once the record is added each attendee receives an e-mail asking to acknowledge they have attended the training
The field called 'Flow Status' is meant to capture if all the attendees have acknowledged by changing the status from 'Initiated' to 'Completed'. Unsure on where/how to add the 'Update Item' action so the update happens automatically.
Looking to keep it simple for now but next step would be to send a reminder to attendees who haven't acknowledged.
Would appreciate any and all feedback you can give me.
First of all you probably don't want to send a singel email to all attendees.
Also you will find that The apply to each willl wait every time until a person responds before the next person is sent an email.
This is not going to work like this.
You coudl send an email to multiple people in one go usig the Approval action. Select the option that requries everybody to respond. Once everybody has responded update your list item.
Do you want to send a single email for all attendees or send one email for each attendees?
According to the screenshot, I think you want to send one approval email for each attendee, is it true? I agree with @Pieter_Veenstra's thought almost, if you would like the "Flow Status" column to be updated from 'Initiated' to 'Completed' when all attendees have acknowledged, I think your flow could not achieve your needs.
You could consider take a try to use "Start an approval" action to achieve your needs. I have created a SharePoint list on my side and the data structure of it as below:
Note: The Topic column and Location column are both Single line of text type column, The Attendees column is Person or Group type column, Flow Status column is Choice type column ("Initiated" and "Completed") and The Date column is Date type column.
I have made a test on my side and please take a try with the following workaround:
Add a "Set variable" action, Name choose ApproverArray and Value set to output of "Compose" action.
The flow works successfully as below:
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!