Hello,
Could anyone tell/teach me how to access the 'values' section(s) of the below JSON using Microsoft Flow?
I want to parse the values of "name" and "id" (e.g. 'London' and 'LON' and 'Hamlets' and 'HAM') to variables so I can use them in another part of the flow.
I've highlighted the specific parts in red.
Thank you 🙂
----------------------
{ "version": "1.0", "session": { "new": true, "sessionId": "removed", "application": { "applicationId": "removed" }, "user": { "userId": "removed" } }, "context": { "System": { "application": { "applicationId": "removed" }, "user": { "userId": "removed" }, "device": { "deviceId": "removed", "supportedInterfaces": {} }, "apiEndpoint": "removed", "apiAccessToken": "removed" } }, "request": { "type": "Request", "requestId": "removed", "timestamp": "2019-07-04T10:01:07Z", "locale": "en-GB", "intent": { "name": "removedname", "confirmationStatus": "NONE", "slots": { "varMainGroup": { "name": "varMainGroup", "value": "London", "resolutions": { "resolutionsPerAuthority": [{ "authority": "removed", "status": { "code": "ER_SUCCESS_MATCH" }, "values": [{ "value": { "name": "London", "id": "LON" } }] }] }, "confirmationStatus": "NONE", "source": "USER" }, "varSubArea": { "name": "varSubArea", "value": "HAMLETS", "resolutions": { "resolutionsPerAuthority": [{ "authority": "removed", "status": { "code": "ER_SUCCESS_MATCH" }, "values": [{ "value": { "name": "HAMLETS", "id": "HAM" } }] }] }, "confirmationStatus": "NONE", "source": "USER" } } } } }
Solved! Go to Solution.
To do this you will use a Parse Json action in the Flow. Follow these steps.
To do this you will use a Parse Json action in the Flow. Follow these steps.
Hi @Pstork1,
Spot on, worked first time thanks. I'm not entirely sure how it works but gets the result I needed thank you. 🙂
Its because the JSON has nested records in it. There is also a way to use index values to get at individual items, but I figured you wanted all of them.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
46 | |
43 | |
36 | |
35 | |
26 |
User | Count |
---|---|
48 | |
40 | |
35 | |
33 | |
31 |