How to access nested table values

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a nested table as follows:

What I'm trying to do is loop trough the table and get ACTIVITY values. How can I do that?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Solved it by using temporary collections to "extract" the data.

Was this reply helpful? Yes No
Verified answer

PaulD1 2,914 on at

Like
a
(0)

Report
Copy link

Link copied!

One of the annoyances of the Collection view is that it does not distinguish between a nested table and a nested record, so I can't see from your screen shot if dll is a table or a record.

Assuming a record - the following should pull the dll associated with the first AddedActivity into a collection.

Collect(First(AddedActivity).dll)

If you want to return the Activity entry for the dll in the first AddedActivity row:

First(AddedActivity).dll.Activity

If dll is a table you would do (to get the first row from dll for the first AddActivity):

Collect(First(First(AddedActivity).dll))

First(First(AddedActivity).dll).Activity

If you just want to combine all the dll stuff together (and ignore the parent AddedActivity level) I think this would work:

ForAll(AddedActivity, Collect(colDll,AddedActivity.dll))

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(4)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to access the values within the dll column in your AddedActivity collection?

Have you solved your problem?

If you want to access the values within the dll column directly in your AddedActivity collection, please consider take a try with the following workaround:

Add a button control within your app, set the OnSelect property to following:

Clear(ActivityCollection); ForAll( AddedActivity, Collect( ActivityCollection, dll ) )

then within your app, you could use the ActivityCollection as data souce to access your Activity records.

You could consider add a Gallery within your app, set the Items property to following:

ActivityCollection

then all Activity records would be displayed within the Gallery.

Please take a try with above solution, then check if the issue is solved.

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome, thank you to both of you. I was using the dot in the wrong place. Thanks again!

Was this reply helpful? Yes No