Create Dictionary Object using JSON file in Power Automate Desktop (Solution Attached)

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

Helping out tech community,

Issue ? Create Dictionary Object using JSON file in Power Automate Desktop

Here below the solution,

Step 1 : Create a .json file like below,

Step 2 : Use "Read from text file" action and locate .json file (Make sure Store content as : Single Text Value)

Step 3 : Use "Convert JSON to Custom Object" action

Step 4 : Then that's it call variable like below,

See the Output,

I'm,

Balamurugan2022

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (2)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Replying to my post since marking as solution

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Thank you for the valuable post.

This is more of a QnA section.

In order for your post to reach a wider audience all solutions are posted in the Cookbook section.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks for the Direction....👍

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Hi Bala,

I messed around using Excel as a config file, storing variables etc. , got very messy 😂
Do the vars in the text file ever get written to the PAD variable pane ?
So to add / delete / edit a var, edit in the text file ?

Nice input 😀

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @UK_Mike ,

Happy to hear 😊,
for the questions,
Variable initialization not required in PAD variable pane (directly call with %SomeVar['SomeKeyInJsonFile']%)
Yes all variables will be initialized from .json file

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Syntax is light also, the way I like it 😂
Thank you 👌

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

hi @UK_Mike, "Accept as Solution" for better visibility

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

No !!!
Fix the typo in " display message " ( step 4 ) and I will reconsider 😂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@UK_Mike Suggestion Accomplished 😊👍

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

😂😂😂

Didnt realise I had to escape the below filepath ?
"C:\\Users\\michael\\OneDrive\\Power Automate Global\\AAA Json Config File"

Same for you ?

Was this reply helpful? Yes No