cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: Approval workflow Sharepoint List Field Update

Some small clarifications:

The column "Approval Status" is indeed added by the system. It appears when you go to List Settings -> Versioning Settings and set Content Approval to Yes. This will also give you the Approve/Reject menu option in the list. All new items automatically get the value Pending.

 

As Michel Laplane (thanks by the way) pointed out, you need to use OData__ModerationStatus as a column name in the Flow action Get Items. Use this in the Filter Query field:

 

OData__ModerationStatus eq 2

This will give you all Pending items to process in your approval flow.

Highlighted
Frequent Visitor

Re: Approval workflow Sharepoint List Field Update

Hi,

 

That's working. We don't need to create any custom column.

When we enable "approval content", a system column will be created and thus "versioning" need to be turn off in the list setting if we need to update the status (and comment) using flow's content approval status action.

 

Thanks

Highlighted
Regular Visitor

Re: Approval workflow Sharepoint List Field Update

Can you please also show how you did the send approval email step, because i cant seem to find that connector/action in the choices. Thanks!

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (3,482)