cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
G_S
Regular Visitor

Approval Process - multiple approvals required

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions

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:

Capture.PNG

 

The condition would run successfully as below:

Capture.PNG

 

 

 

Best regards,

Alice

View solution in original post

4 REPLIES 4
v-yuazh-msft
Community Support
Community Support

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:

Capture.PNG

The expression in the Condition as below:

@greater(length(triggerBody()?['approvers']), 0)

 

The flow would run successfully as below:

Capture.PNG

 

 

 

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. 

Error.jpgFlow.jpg

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:

Capture.PNG

 

The condition would run successfully as below:

Capture.PNG

 

 

 

Best regards,

Alice

It worked - thanks Alice! 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,159)