Answered

Compose action not showing values from Parse JSON

(0) Share

Report

Posted on by RADical

164

Please help! I've done this quite a few times in the past and not sure where I'm going wrong this time. I have a Parse JSON action which takes the values from a GET HTTP request and I'm trying to pass the array of excludeUsers values to a Compose action. The Flow runs successfully, but the compose box just shows me the option to download the Inputs and Outputs and loads a blank page when I click either one.

From the screenshot below you can see there are values returned from excludeUsers:

My JSON Schema is below:

{
 "type": "object",
 "properties": {
 "id": {
 "type": "string"
 },
 "displayName": {
 "type": "string"
 },
 "createdDateTime": {
 "type": "string"
 },
 "modifiedDateTime": {
 "type": "string"
 },
 "state": {
 "type": "string"
 },
 "sessionControls": {},
 "conditions": {
 "type": "object",
 "properties": {
 "userRiskLevels": {
 "type": "array"
 },
 "signInRiskLevels": {
 "type": "array"
 },
 "clientAppTypes": {
 "type": "array",
 "items": {
 "type": "string"
 }
 },
 "servicePrincipalRiskLevels": {
 "type": "array"
 },
 "platforms": {},
 "times": {},
 "deviceStates": {},
 "devices": {},
 "clientApplications": {},
 "applications": {
 "type": "object",
 "properties": {
 "includeApplications": {
 "type": "array",
 "items": {
 "type": "string"
 }
 },
 "excludeApplications": {
 "type": "array"
 },
 "includeUserActions": {
 "type": "array"
 },
 "includeAuthenticationContextClassReferences": {
 "type": "array"
 }
 }
 },
 "users": {
 "type": "object",
 "properties": {
 "includeUsers": {
 "type": "array",
 "items": {
 "type": "string"
 }
 },
 "excludeUsers": {
 "type": "array",
 "items": {
 "type": "string"
 }
 },
 "includeGroups": {
 "type": "array"
 },
 "excludeGroups": {
 "type": "array"
 },
 "includeRoles": {
 "type": "array"
 },
 "excludeRoles": {
 "type": "array"
 },
 "includeGuestsOrExternalUsers": {},
 "excludeGuestsOrExternalUsers": {}
 }
 },
 "locations": {
 "type": "object",
 "properties": {
 "includeLocations": {
 "type": "array",
 "items": {
 "type": "string"
 }
 },
 "excludeLocations": {
 "type": "array"
 }
 }
 }
 }
 },
 "grantControls": {
 "type": "object",
 "properties": {
 "operator": {
 "type": "string"
 },
 "builtInControls": {
 "type": "array",
 "items": {
 "type": "string"
 }
 },
 "customAuthenticationFactors": {
 "type": "array"
 },
 "termsOfUse": {
 "type": "array"
 },
 "authenticationStrength@odata.context": {
 "type": "string"
 },
 "authenticationStrength": {}
 }
 }
 }
}

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @RADical ,

if it doesn't work I'd try to do it without the 'Parse JSON' action (which I really don't like) and extract the values directly from the output using an expression as explained e.g. here.

It might look like:

outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['conditions']?['users']?['excludeUsers']

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report
Copy link

Link copied!

Thank you for you help @tom_riha!
I tried that in the compose but I receive and error once I try to include any property pass <outputs('Get_CAP1')?['body']?['value']>. I'm receiving the following error:

Any thoughts?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Show your Compose in edit mode.
Also please show real output of GET HTTP request.

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report
Copy link

Link copied!
Thanks for the swift response @VictorIvanidze!

Compose action in edit mode:

HTTP Action Output:
{ "@odata.context": "https://graph.microsoft.com/beta/$metadata#identity/conditionalAccess/policies", "value": [ { "id": "4cd70812-xxxx-481d-b31a-xxxxxxxxxxxx", "displayName": "Prohibited Countries Access", "createdDateTime": "2021-10-17T00:30:56.1615208Z", "modifiedDateTime": "2023-03-29T23:27:17.4658922Z", "state": "enabledForReportingButNotEnforced", "sessionControls": null, "conditions": { "userRiskLevels": [], "signInRiskLevels": [], "clientAppTypes": [ "all" ], "servicePrincipalRiskLevels": [], "platforms": null, "times": null, "deviceStates": null, "devices": null, "clientApplications": null, "applications": { "includeApplications": [ "All" ], "excludeApplications": [], "includeUserActions": [], "includeAuthenticationContextClassReferences": [] }, "users": { "includeUsers": [ "All" ], "excludeUsers": [ "7c9743fd-a1ad-xxxx-8f4f-xxxxxxxxxxxx", "eb5e114c-d8bf-xxxx-b1a9-xxxxxxxxxxxx", "2cb91480-a63e-xxxx-aa0e-xxxxxxxxxxxx", "11ea3731-bb5d-xxxx-8114-xxxxxxxxxxxx" ], "includeGroups": [], "excludeGroups": [], "includeRoles": [], "excludeRoles": [ "62e90394-69f5-4237-9190-xxxxxxxxxxxx" ], "includeGuestsOrExternalUsers": null, "excludeGuestsOrExternalUsers": null }, "locations": { "includeLocations": [ "1f6dcecf-4e89-4ac2-bf08-xxxxxxxxxxxx" ], "excludeLocations": [] } }, "grantControls": { "operator": "OR", "builtInControls": [ "block" ], "customAuthenticationFactors": [], "termsOfUse": [], "authenticationStrength@odata.context": "https://graph.microsoft.com/beta/$metadata#identity/conditionalAccess/policies('4cd70812-5293-481d-xxxx-xxxxxxxxxxxx')/grantControls/authenticationStrength/$entity", "authenticationStrength": null } } ] }

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!
Try to use this:

outputs('Get_CAP1')?['value'][0]?['conditions']?['users']?['excludeUsers']

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report
Copy link

Link copied!

@VictorIvanidze
Getting a different error when I tried that:
"Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'outputs('Get_CAP1')?['value'][0]?['conditions']?['users']?['excludeUsers']' cannot be evaluated because property '0' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.:

When I add the "?" before [0], it runs successfully, but now I'm back at square one where it asks me to download the output and there's nothing.

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!
What about
outputs('Get_CAP1')?['body']?['value'][0]?['conditions']?['users']?['excludeUsers']

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report
Copy link

Link copied!

MAGIC! That worked! Thank you so much @VictorIvanidze! Can you please explain why it wouldn't work without the array index?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

You have a JSON array that consists of a single element, whose index is 0.

Was this reply helpful? Yes No
55552 676 on at

Like (0)

Report
Copy link

Link copied!

Thanks. This helped me also. I was trying to use Parse JSON and getting blank values in my compose statement following the parse json. Switched to the direct method of retrieving values directly from the HTTP output and it worked perfectly. In my case there were no arrays, only objects, so my compose code was:

outputs('HTTPStatic')?['document']?['inference']?['prediction']?['total_amount']?['value']

Was this reply helpful? Yes No