The JSON notation has 2 types of brackets. Working with arrays in JSONīut only until you reach an array. It should contain the whole path that leads to the value, up to the column internal name. outputs('Get_items')?įollowing this syntax of adding ? to the expression you can directly access any value in the JSON. If you want to go deeper, to the actual items, you can add the next property to the expression – “value”. The result will be the whole “body” value. For example, to process the output body Power Automate will take output from ‘Get items’, and access the property “body”. The navigation is done by the ? string added to the source reference expression.
#Json compare value code#
If you use any of the available dynamic contents, you’ll see that the code behind corresponds to the location in that JSON. That’s why the name of the dynamic content can be different from the property name in JSON. Note: the JSON works with the column internal name. ID = 2ĪpproverSingle = a lot of user information Translated to the Power Automate user interface, blue are the available dynamic contents, and the value is the actual data you’ll get, e.g. The blue colour strings are properties, the content after the : are their values. Note: the colours are mentioned only for better explanation, they’re added by the code editor. As the ‘statusCode’ and ‘headers’ is not that relevant, you can concentrate only on the ‘body’ part with the actual items data. That is the output of ‘Get items’ in JSON format. If you check the whole output and copy it into a code editor (I use Visual Studio Code), you’ll see a similar structure as below. Let’s take the output from ‘Get items’ as an example. Instead of using the whole JSON that’ll fit a JSON schema, you can just pick the specific property. You can navigate through a JSON and take only the value you need. But there’s also a third option, accessing the value with an expression.
And if it doesn’t do it automatically, there’s still the ‘Parse JSON’ action to parse any JSON on demand. Power Automate will then automatically parse that JSON, and provide the values among the available dynamic content. Whenever there’s an output of any action, it’ll be a JSON on the background. JSON is the basic data format used in Power Automate. “Is it possible, maybe with an expression, to get only a specific value(s) from a JSON object in Power Automate, so I can work with them later in the flow?”
0 kommentar(er)
