Tool · Power Automate · JSON to expression
Expression Picker
Paste the JSON a flow step returns, click the value you need, and copy a ready-made Power Automate expression, plus the matching Power Apps formula.
Works with
Power Automate
Power Apps
Sample JSON
Pick a value
Paste JSON or load a sample, then pick any value.
Guide
How to use it
Copy a real output
Run the flow once, open the run, select the step and copy its raw outputs or body.
Paste and name it
Paste the JSON here and type the step’s name exactly as it appears in the designer.
Pick and paste
Press Use next to the value you need, then paste it into any input in your flow.
Questions
FAQ
What is the difference between "paste-ready" and "expression only"?
Paste-ready wraps the expression in @{ }, so you can paste it straight into an input field and Power Automate treats it as an expression. "Expression only" is for the expression editor (the fx box), where you type the expression without @{ }.
What should I paste: raw outputs or the body?
Either. Raw outputs (with statusCode, headers and body) are detected automatically, and values inside the body still use the shorter body() form. You can force the choice with the "Pasted" switch.
Why does it use ?[ ] instead of [ ]?
The ? makes the expression return null instead of failing when a property is missing, which keeps a flow running when a field is optional or empty.
How do I read a value from every item in a list?
Pick a value inside the list and choose "Every item (loop)". The tool shows which list to put in an Apply to each and the item() expression to use inside it. "First item, safely" uses first(), which returns null instead of failing when the list is empty.
Does it work for the trigger, a Compose or a variable?
Yes. Choose where the JSON comes from, and the expression starts with triggerBody(), outputs(), variables() or item() as needed.
Is my JSON sent anywhere?
No. Everything happens in your browser. Nothing is uploaded or stored.