Flow Friday: Using Approval Status for Sharepoint lists in Microsoft Flow
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"
OData__ModerationStatus eq ‘0’
Another field you can access this way is OData__Moderation_comments
That is it for tonight