Answered

Expression to map all possible nested values

(0) Share

Report

Posted on by simondpalmer

131

I am using Select Data Operation to map values from Plan tasks. I am having trouble mapping the array "appliedCategories" as I want to create individual key and mapped values based on the nested values ("category1", "category2", "category3", "category4", "category5", "category6"). As you can see below (copy of body minus all the other fields for clarity) each nested value doesn't come through if it is false. However, I want a "null" value if it is false regardless.

 {
 },
 "appliedCategories": {
 "category2": true
 },
 },
 {
 },
 "appliedCategories": {},
 },
 {
 },
 "appliedCategories": {
 "category1": true
 },
 },
 },
 "appliedCategories": {
 "category1": true,
 "category2": true,
 "category3": true,
 "category4": true,
 "category5": true,
 "category6": true
 },
 ]
 },

I used the following:

if(empty(item()?['appliedCategories']),null,item()?['appliedCategories'])

but that doesn't apply to nested boolean values. So i created individual keys (for "category1", etc.) tried the below:

if(empty(item()?['appliedCategories'],[0]),null,item()?['appliedCategories'],[0])

But this doesn't work. Any help would be great

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @simondpalmer ,

Please share the full array and explain more details about the requirement so we could take a try to make a test on it and provide a proper solution for you.

I have made a test on my side to create the flow as below, does it meet your requirement?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
simondpalmer 131 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @v-alzhan-msft the flow looks like the below. "appliedCategories"s 'category1, category2, etc. I want to make separate keys from:
An example of a full array looks like the following:
{ "@odata.etag": "W/\"JzEtVGFzayAgQEBAQEBAQEBAQEBAQEBAZCc=\"", "planId": "BGdKsoj4AUuCWxQRd5DHAmUAEh6b", "bucketId": "VJ0R4ZZkZU-FrA9eDMA7imUAMA4S", "title": "RE: 19510 and 19520 Jamboree Rd - pedestrian bridge between buildings", "orderHint": "8586126197660276906", "assigneePriority": "8586126197660276906", "percentComplete": 100, "startDateTime": null, "createdDateTime": "2020-05-09T01:18:39.4498901Z", "dueDateTime": "2020-05-09T07:00:00Z", "hasDescription": true, "previewType": "automatic", "completedDateTime": "2020-05-12T18:55:32.1597893Z", "referenceCount": 0, "checklistItemCount": 0, "activeChecklistItemCount": 0, "conversationThreadId": null, "id": "9yqGCZJlxkG3qLP_juN3fmUAC41b", "createdBy": { "user": { "displayName": null, "id": "128a7b60-83ea-43d4-b228-2eb34c85f850" } }, "completedBy": { "user": { "displayName": null, "id": "128a7b60-83ea-43d4-b228-2eb34c85f850" } }, "appliedCategories": { "category1": true, "category2": true, "category3": true, "category4": true, "category5": true, "category6": true }, "assignments": { "128a7b60-83ea-43d4-b228-2eb34c85f850": { "@odata.type": "#microsoft.graph.plannerAssignment", "assignedDateTime": "2020-05-09T01:18:39.4498901Z", "orderHint": "8586126198261058635P7", "assignedBy": { "user": { "displayName": null, "id": "128a7b60-83ea-43d4-b228-2eb34c85f850" } } } }, "_assignments": [ { "userId": "128a7b60-83ea-43d4-b228-2eb34c85f850", "value": { "@odata.type": "#microsoft.graph.plannerAssignment", "assignedDateTime": "2020-05-09T01:18:39.4498901Z", "orderHint": "8586126198261058635P7", "assignedBy": { "user": { "displayName": null, "id": "128a7b60-83ea-43d4-b228-2eb34c85f850" } } } } ] },
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @simondpalmer ,

Please take a try to refer to my steps to create the flow.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
simondpalmer 131 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your help Alice,

So I put it all together. List Tasks > Parse JSON (appliedCategories have specific properties) > Select those values from Parse JSON. End product below.