Hi All,
This is not a question, but a solution to a problem I have had: Reading the Approval Status. There are a few guides to getting this to work, but I kept running into problems, so I swore that I would write a guide here, when I finally found something that worked for me.
Problem: You want your Flow to be able to read the built-in Approval Status column, that is not available for Flow.
Solution:
I will go though each action an explain. The solution is a two-step solution, as we need to get som info out midway, that we need to configure an action later in the flow.
1.
First we make a call to the SharePoint list and get the Status.
Uri: _api/web/lists/GetByTitle('Documents')/items(<ID of element>})?$select=OData__ModerationStatus
Headers:
Accept application/json; odata=verbose
Content-Type application/json; odata=verbose
Body: body('Send_an_HTTP_request_to_SharePoint' )['OData__ModerationStatus']
(I have to admit, that I really don't know what I'm doing in the Body section)
2.
This step might be skipable, and you can just use the code from step 3.
Send the result of HTTP request action to your e-mail. This send e-mail action is only temporary and will be deleted later.
Body: Concat function is this: concat(body('Send_an_HTTP_request_to_SharePoint'))
3.
Run the flow on an item in your document library and recieve the e-mail. The data should look something like this:
{"d":{"__metadata":{"id":"e6ad8e94-985d-4eb3-93c7-ff233a277874","uri":"https://XXX.sharepoint.com/sites/YYY/_api/Web/GetByTitle('Documents')/Items(7)","etag":"\"6\"","type":"SP.Data.Shared_x0020_DocumentsItem"},"OData__ModerationStatus":2}}Copy all of this, as it is needed soon.
4.
Delete the Send an email action - we don't need it anymore.
5.
Insert the Parse JSON action, so we can convert the recieved data to something usefull.
Insert the Body from the HTTP Request.
Now, press the "Use sample payload to generate schema" in the buttom of the Parse JSON action.
Indsert the data you got in your e-mail:
Press Done and the result will show itself in the former window:
6.
Done!
You can now insert the ID of the Approver Status into your flow:
7.
Bonus
If you have trouple using the format of the data in your actions, you can convert it with the Compose Action.
Insert the variable - and have "" around it.
Let me know if you have any problems with this.
