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.
