Skip to main content

Create a list from JSON data

Power Automate Desktop can add actions from his GUI to add action from his GUI, but internally, a programming language called Robin is assembled.

Therefore, there are several data types for variables, and JSON data can be handled flexibly.

This time, I will explain how to create wrist data from JSON data.

"Convert JSON into custom objects" Action details​

This time, we use an action called "Convert JSON into a custom object".

The details of the action are explained on this page.

Originally, it is an action used to generate custom objects with multiple properties, but it is possible to generate wrist data by specifying JSON data that represents an array as an argument.

Implemented with copy and paste​

This time, as a sample, we have prepared a flow to generate wrist data from JSON data.

Copy the following code and paste it on the edit screen of Power Automate Desktop to add the target action.

Variables.ConvertJsonToCustomObject Json: $'''%'[\"a\", \"b\"]'%''' CustomObject=> JsonAsArray

Operate and implement Power Automate Desktop​

  1. Enter "Convert JSON into custom objects" from "Search Action".

  2. Set the parameter as follows

    Parameter namevalue
    JSON%'[\"a\", \"b\"]'%
    Generated variables%JsonAsArray%

  3. By execution, you can generate wrist data from JSON data.

Exceptions that can occur​

If the specified JSON data is fraudulent, an error may occur during the analysis.

We recommend that you define block processing when an error occurs.