Answered

Power Automate Desktop missing json resolving operation and python module issue

(1) Share

Report

Posted on by DS-17060233-0

I'm trying to parse json with Power Automate Desktop. When searching for ‘json’ in the operation search bar, there are only two options: "Convert json to a custom object/Convert a custom object to json".I couldn't find any other available json parsing operations. So I tried to use python script to handle json and the results confirm that the json module also missing in the Automate internal module. who guys can help on this~ I have updated the version to the latest...

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @DS-17060233-0,

You can Parse Jon in Power Automate Desktop using the Convert JSON to custom object action and allows you to work with its content using dot or dictionary-style syntax as shown in below image.

If you still want to go with Python,instead of using Run Python script use Run Powershell script action. save the python code as .py file and invoke that python code using Run Powershell script action as shown in below image.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Verified answer

Riyaz_riz11 3,971 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
Hi,

1. Set JSON string as a variable

Use the Set Variable action:

jsonText = '[{"id":1,"name":"John"},{"id":2,"name":"Jane"}]'

2. Convert JSON to Custom Object

Use the action: Convert JSON to Custom Object

Input: jsonText

Output: parsedJson

3. Loop through the parsed object

Use a For Each action:

Value to iterate: %parsedJson%

Current item: currentItem

4. Access data in loop

Use expressions like:

%currentItem["id"]%

%currentItem["name"]

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No