Answered

Parsing Json

(0) Share

Report

Posted on by Rhysy

Is there a "best practice" way to parse Json in the desktop app? In the web app you can just give the "parse json" function a variable which it will then parse correctly for use in other functions. In the desktop app I get as far as getting the response into a variable but then cant seem to actually do anything with it because it just comes in as a string. I have tried putting a foreach over the top of my json variable but it says its not a valid list.

If anyone has any links to documentation or advice on this it would be much appreciated. All I can find are guides on using the parse function in the web app, nothing on desktop app.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

fraenK 2,125 on at

Like (2)

Report
Copy link

Link copied!

You can convert it to a custom object and then access the properties to get the values:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/variables#convertjsontocustomobject
https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-types
e.g. %Product['Name']%

Was this reply helpful? Yes No
yupabs 36 on at

Like (0)

Report
Copy link

Link copied!
Need help how to get the key element name instead of the value.

"assignments": {
"5f415230-12c0-49f1-8d25-00dcd9ad0e7e": {
"@odata.etag": "W/\"JzEtVGFzayAgQEBAQEBAQEBAQEBAQEBAWCc=\"", "planId": "egP0I6R3EUi_rNCNluHHcGQAFZPl", "bucketId": "h1d9_CXtWk2Y5x0JKthk9GQAOcO0", "title": "INC3673457", "orderHint": "8585752933743133091", "assigneePriority": "", "percentComplete": 50, "createdDateTime": "2021-07-15T01:45:11.1642716Z", "dueDateTime": "2021-07-16T00:00:00Z", "hasDescription": true, "previewType": "description", "referenceCount": 1, "checklistItemCount": 0, "activeChecklistItemCount": 0, "conversationThreadId": "AAQkAGMwNTU4NmNjLWMzZmEtNGM3OC04YWQ3LWZhMjJkZTRlYWYzZQMkABAAX2y12f5zi02PaRDNu62PHxAAX2y12f5zi02PaRDNu62PHw==", "id": "UhKUhFVnxkW1cs5805Gw-mQAKJnk", "createdBy": { "user": { "id": "49510ecd-5f4d-4796-bbcd-d47575638954" } }, "appliedCategories": { "category20": true }, "assignments": { "5f415230-12c0-49f1-8d25-00dcd9ad0e7e": { "@odata.type": "#microsoft.graph.plannerAssignment", "assignedDateTime": "2021-07-15T01:45:11.1642716Z", "orderHint": "8585752934344383136Pn", "assignedBy": { "user": { "displayName": null, "id": "49510ecd-5f4d-4796-bbcd-d47575638954" } } } },

Basically, i have a list of task planners assigned to multiple users. And i want to build a flow which will consolidate all tasks assigned per owner which having expired or null Due date and send a chat to follow-up. Planning to create a html table listing those tasks assigned per owner.

Title Description Due Date Status
2314234141 Creating a table 19-Jul-2021 Not Started

Thanks in advance for all your help!

Was this reply helpful? Yes No
yupabs 36 on at

Like (0)

Report
Copy link

Link copied!

Thanks @fraenK . Let me try that and update you. Thank you.

Was this reply helpful? Yes No
yupabs 36 on at

Like (0)

Report
Copy link

Link copied!

Sorry, i'm new to this power automate. Which exact step i need to add in power automate for this convert to custom object? is it the Variable step? or any specific action?

Was this reply helpful? Yes No