Hi all,
I am trying to create an Approval process using flow that sends documents simultaneously to multiple approvers once the Document Approvers column is updated.
So far I have created a SharePoint Document library, added a Document Approvers column that allows multiple people or groups.
Following this I have created a flow using trigger “when a file is created or modified (properties only), initialized, composed and set the document approvers variable, added a condition if Document Approvers does not contain and left the value cell blank. Then start an approval based on this with the approval updating the content status to approve or reject based on the approver’s response.
It says my flow has “succeeded”. However I’m not sure this is accurate as the Document Approvers assigned never receive the email requesting approval.
Was hoping someone can help with the above or advise if there’s a better (or easier) way to achieve this?
If possible, I'd also like to incorporate an approval reminder. However this would be a nice to have
Thanks in advance!
Solved! Go to Solution.
Hi @G_S,
I have made a test on my side and the issue is confirmed on my side.
Please modify the expresssion in the Condition as below:
@not(empty(triggerBody()?['Document_x0020_Approvers']))
And the screenshot of the flow should as below:
The condition would run successfully as below:
Best regards,
Alice
Hi @G_S,
Could you please share a screenshot of the configuration of your flow?
I have made a test on my side and have created a flow as below:
The expression in the Condition as below:
@greater(length(triggerBody()?['approvers']), 0)
The flow would run successfully as below:
Best regards,
Alice
Thanks Alice.
I made the changes following your post.Just with one amendment; "Document Approvers" was used instead of "Approvers" as this is the culumn name. However I get an error.
Hi @G_S,
I have made a test on my side and the issue is confirmed on my side.
Please modify the expresssion in the Condition as below:
@not(empty(triggerBody()?['Document_x0020_Approvers']))
And the screenshot of the flow should as below:
The condition would run successfully as below:
Best regards,
Alice
It worked - thanks Alice!
User | Count |
---|---|
93 | |
45 | |
20 | |
20 | |
16 |
User | Count |
---|---|
135 | |
56 | |
45 | |
36 | |
26 |