Thank you very much for this solution!
@Anonymous I'm facing this issue too and I found a solution from the article below. Bascially you'll need to use a 'Send an HTTP Request to SharePoint' action and then use an ODATA_ operator in front of the Approval Status (_ModerationStatus) field. _Moderation status is not exposed by standard REST calls so that is why odata is required.
https://www.techmikael.com/2018/05/use-microsoft-flow-to-implement.html
_api/web/lists/getbytitle('<Library Name>')/items(<id>)?$select=OData__ModerationStatus
The returned object will have the Approval Status id in it
{ OData__ModerationStatus: 1 }
The approval statuses are:
Approved = 0
Rejected = 1
Pending = 2
Draft = 3
Any solution for column '_ModerationStatus' Please ?
I have a similar need and am seeking help. I have an Issues list in SP. I have a Status Column and Status Update Column.
If the troubleshooting team enters a status update and proposes it as a solution, prior to the Status Column being updated to 'Closed, I would like the Status Update mailed to the user who entered the issue and ask if they Accept it as a solution. If they click Approve, then I would like the Status Column to update automatically to 'Closed'. Is this all possible with Flow?
Also, when I added a flow identical to the one you shared above, it will not send an email when set as Is Equal To 'Closed' (which is what I want).
However, it will send the email when I set it as 'Is not equal to' 'Closed'. And continues to send emails if I change status back to In Progress.
Hi Patrick
its seems there is limitation with MS Flow that where it can not select and act on system intenal fileds, I just had revert back to old way of workflow cinfiguration in sharepoint to achiniving the desired results & which works absolutly fine.
I'm in search of a similar need. I have a SharePoint Online list that is configured for "content approval for submitted items" and I'd like to use this column in a MS Flow condition. Is this possible? It doesn't show as avaialble with the other list fields as dynamic content.
Hi Mona, thanks for the efforts but this is not what i wanted , i wanted the condition specifcally work on system field "Approval status" whose inernal name is, i dont need a another approval column in the list as it has a drwaback where it got edit permission and any one who has edit permission to list but not the approver can modify this newly created column which isn't the case with "_ModerationStatus" field. I am using out of box sharepoint approval option provided in each list and wnat flow to mactch the value of the internal field.
Hi GT,
I have created a flow according to your requirement. And I got the result successfully.
2. Create a Flow with the following settings:
When I modified one column to “Approval”, I will receive an email like this:
In this flow, the condition is:
Regards,
Mona Li