Power Platform Community Forum Thread Details

Hi all,

I'm receiving some SharePoint document library data back from Power Automate in an unstructured format. I was shown on a video how to use the gallery to parse the data, but I can't figure out how I can parse the data outside of the using gallery. I want to filter and extract items like "Title" and "Path", but I'm not able to translate the concept from using gallery to using parse JSON.

Here is a snippet of my unstructured data.

body": {
"searchresults": "[{\"Cells\":[{\"Key\":\"WorkId\",\"Value\":\"7345110036237367357\",\"ValueType\":\"Edm.Int64\"},{\"Key\":\"Rank\",\"Value\":\"999.6275051\",\"ValueType\":\"Edm.Double\"},{\"Key\":\"Title\",\"Value\":\"Charter Letter\",\"ValueType\":\"Edm.String\"},{\"Key\":\"Author\",\"Value\":\"Windows User;Moyer, Andy\",\"ValueType\":\"Edm.String\"},{\"Key\":\"Size\",\"Value\":\"84836\",\"ValueType\":\"Edm.Int64\"},{\"Key\":\"Path\",\"Value\":\"https://prnent.sharepoint.com/sites/RCATracking-Test/Shared Documents/Case Files/Open/This is my FilePath/Final Documents/Charter Letter.docx\",\"ValueType\":\"Edm.String\"},{\"Key\":\"Description\",\"Value\":null,\"ValueType\":\"Null\"},{\"Key\":\"Write\",\"Value\":\"2023-12-07T20:00:00.0000000Z\",\"ValueType\":\"Edm.DateTime\"},{\"Key\":\"CollapsingStatus\",\"Value\":\"0\",\"ValueType\":\"Edm.Int64\"

Thanks,

Andy

Categories:

General Questions