Unanswered

Select a specific object from an array

(0) Share

Report

Posted on by MooFeR

I got an array of objects with many fields that i'm trying to return to powerapps.
A small part with just 3 properties of one object would look like this

{

"scope": "folder",

"createdDate": "2023-07-12T11:39:47Z",

"customFields"[

{

"id": "IEAFEJZDJUADBXOS",

"value": "KUAOWIZ7"

{

"id": "IEAFEJZDJUADBWJW",

"value": "500"

{

"id": "IEAFEJZDJUADBYJS",

"value": "100"

}

]

}

I know that the field with ID = "IEAFEJZDJUADBWJW" stores the value of "ProjectEffort". Since there are hundreds of properties in the object I don't want to return all of them in powerapps so I'm trying to do a select but not sure how to catch only the values from customFields where id = "IEAFEJZDJUADBWJW" (there are actually about 20custom fields and i need to grab 3 of them)

I figured that i can get the value by using filter array but this would create a separate loop and select wouldn't work.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

nichtaurelius 50 on at

Like (0)

Report
Copy link

Link copied!

Hi MooFer,
To retrieve the object with the ID 'IEAFEJZDJUADBWJW', you should iterate through every object in the array and implement a condition. Check if the ID of the current object matches 'IEAFEJZDJUADBWJW'. If the current object has the desired ID, assign it to a variable. If there are multiple possible objects, follow the same process, but instead of setting variables, use an append-to-array operation when the current object has the same ID you are looking for. The illustration below depicts the outlined process:
I hope this helps resolve your issue.

Greetings,

Aurelius 🙂

Was this reply helpful? Yes No
MooFeR on at

Like (0)

Report
Copy link

Link copied!

I think that's the same as my last image just using "condition" instead of "filter array" but the end result is the same. The issue is that after that I got an array just with the "customFields" so on the "select" action of my first image I could only fill the 3rd field and can't fill the first two anymore.

Was this reply helpful? Yes No
Anwarluck 113 on at

Like (1)

Report
Copy link

Link copied!
Hi @MooFeR , you can select the object based on id using filter array. Please try to update the item with the below expression.
item()['id']
That way you will only select the item having that specified id.

Please let me know if you still struggles with it, thank you!

Was this reply helpful? Yes No
jojos_iq 90 on at

Like (0)

Report
Copy link

Link copied!

Just for anyone else who comes across this thread, this worked - iterating through every object in an array one by one is just too slow - I ❤️ Filter Array

Was this reply helpful? Yes No