Acknowledgement Flow - Updating a field in a Record containing multiple attendees

[Marian71]

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.

Marian 

.

[Pieter_Veenstra]

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.

[v-xida-msft]

Hi @Marian71,

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 "When an item is created" trigger, specify Site Address and List Name.
• Add a Variables-> "Initialize variable" action, Name set to ApproverArray, Type set to String and Value set to empty.
• Add a "Apply to each" action, input parameter set to Attendees dynamic content of the trigger.
• Within "Apply to each", add a "Compose" action, Inputs set to following formula:

concat(items('Apply_to_each')?['Email'],';',variables('ApproverArray'))

        Add a "Set variable" action, Name choose ApproverArray and Value set to output of "Compose" action.

• Under "Apply to each" action, add a "Start an approval" action, Approval type set to Everyone from the assigned list, Assigned to field set to ApproverArray variable.
• Add a "Condition", left input box set to Response dynamic content of "Start an approval" action, right input box set to Approve, Within middle drop down, choose is equal to.
• Within "If/yes" branch of Condition, add a "Update item" action, specify Site Address and List Name, Flow Status Value field set to "Completed".

Image reference:

The flow works successfully as below:

Best regards,

Kris