Unanswered

Powerapps collections - drill down through 3 levels?

(0) Share

Report

Posted on by AFE2E

Hi,

My app has a flow which imports several collections when a user logs in. One of these is named 'Park' and contains a 'Category' which I need a gallery to access. The issue is that this is on level 4 of the table structure. I need a gallery of the values in 'green' but can't seem to get to it. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @AFE2E

Looks like Categorydetail is a table. So we have to use First() even though you may have a single record.

Category: Park.category.First(categoryDetail).Text

Please share the error. It helps to troubleshoot.

Was this reply helpful? Yes No
AFE2E 11 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have tried your suggestion..

I get the following errors. 'Invocation of unknown or unsupported function' when hovering over the park.category section. Then I get 'Name isn't valid. The identifier isn't recognised' on categorydetail and 'Invalid use of '.' on /Text at the end

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @AFE2E

Few troubleshoot items
Can you insert the label on the screen and set the text property to

Park.category.categoryDetail.Text

Can you Share Park and category structure?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AFE2E，

Have you solved your problem?

Do you want to add a record to your ParkCategories?

Could you please share more about your need, access this value in a Gallery or add it into a collection?

If you just want to access this in a Gallery, please set the Text property of the Label as below:

ThisItem.Category.CategoryDetail.Text

If you want to get this value into another collection, please modify your Collect() formula as below:

Collect(ParkCategories,{Category:First(Park).Category.CategoryDetail.Text})

Note that you should determine which record in the Park do you want to access to, I assume that you want to access to the first record.

Was this reply helpful? Yes No
ITBird 11 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your response.

I'm trying to display a question bank based on the categories for each park. So the Park is collected when the user logs in. The categories are pulled from the DB in to a collection. Then I want to use a gallery to display the questions for the categories that this Park has assigned to it.

I've tried both of your methods above and both work up to the point category.categoryDetail but the .Text is always underlined in red and says 'Name isn't valid' I just can't seem to get to that last level to extract the value. Please see my collection structure below...

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @ITBird

I created a collection similar to you to test it.
ClearCollect( Park, { Key: 0, Address: {Street1: "900 Main St"}, category: { organization: 1, categoryDetail: { Description: "Audit", Text: "First Aid", Key: 95 } } } ); Collect( ParkCategories, {Category: First(Park).category.categoryDetail.Text} )
When I assign Park or Category to Gallery as Items property than to display "Text" column
ThisItem.category.categoryDetail.Text
And also able to collect the "Text" column to the ParkCategories collection

Can you try this sample and see where the problem is.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @ITBird

Please let us know if anything needs on your post. We can help with this.

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Was this reply helpful? Yes No