Apply to Each selected Option response

[Timmay313]

I am building a document review process that works off a SharePoint list. This list is enabled for revisions with columns enabled to append Changes, my columns are as follows:

 

Column                             Type

Title:                                  Single line of text

Link to document:             Hyperlink

Review Description:          Multiple lines of text

Priority Level:                    Choice (4 options)

Start Date:                        Date and time (renamed created field)

Due Date:                         Date and time

Completed Date:              Date and time

Reviewers:                       Person or Group (select multiple enabled)

Review Status:                 Single line of text

Reviewer Outcome:         Multiple lines of text

The flow is triggered when a new sharepoint item is created, I then have an Apply to Each with the Reviewers column selected. This then sends an "asssignment email" to each of the people added to the Reviewers column. this is an email with options "Document Reviewed" and "Document NOT Reviewed" All is working to this point. 

 

I then have a condition where the SelectedOption is equal to Document Reviewed. If YES then it the sharepoint item is updated, changing the Review Status column from Assigned to In Progress, and adding the SelectedOption to the Reviewer Outcome column. Then sends an email to the created by notifying them that user has completed the review and the current status. 

Once all reviewers have completed, the SharePoint item is then updated changing the Review status to Complete and an email sent to the Created by letting them know the document has been completed the process and provides a link to the document in sharepoint as well as a link to the list item in sharepoint. 

 

The issues I am having is not all responses are being saved back to the Reviewer Outcome column. This is a Multi line of text with append changes enabled. so far in testing it has skipped a response with no error given and has also written the responses as the same user even though it was two users responding. any thoughts on this would be helpful. 

[Timmay313 · Accepted solution]

For those that are interested, I have figured out a work around for this issue. 

It would seem that the "Update Item" portion of the flow was using my account as the connection therefor writing that response to the sharepoint list as me. to correct this I am having to have each of the users that is in the reviewers list add there connection creditials to the flow for their particular update item task. It then writes the Selected Option to the Reviwer Outcome in the list as that user. 

Its a pain but its working...

[v-xida-msft]

Hi @Timmay313,

Could you please expand the "Document Reviewed - Update item" action within your flow and share a screenshot about it?

Do you add a Modify By DisplayName dynamic content within your "Document Reviewed - Update item" action?

I think your thought is correct, if you have solved you problem, please click "Accept as Solution" so that this thread will be marked for other users to easily identify.

Best regards,

Kris