Tonight I was trying to filter a Sharepoint List based on Approval Status in Microsoft Flow… this turned out to be a bit tricky… maybe even more than a bit.
Apparently the column Approval column is a system column and those are not visible as properties in Flow. There is however a way to get it… The property you need to use is OData__ModerationStatus. The different status values are
- 0 for “Approved”
- 1 for “Rejected”
- 2 for “Pending”
The correct statement in Flow is
OData__ModerationStatus eq ‘0’
Another field you can access this way is OData__Moderation_comments
That is it for tonight
Links:
https://powerusers.microsoft.com/t5/Building-Flows/Approval-workflow-Sharepoint-List-Field-Update/td-p/13186