Answered

Get records from nested tables

(0) Share

Report

Posted on by jplug

For a gallery i am trying to combine different tables into the same gallery. These tables are nested in a single table as I am using a ForAll to retrieve the group members of certain Office365 groups. Sadly I have not yet found a way to show the nested items in the gallery.

Does anyone know how to access these nested items (it are multiple items in each table) or change the ForAll so that the table items are not nested?

Thanks for the help 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @jplug,

Could you please show me the completed ForAll() formula?

Actually, if you want to display nested table in a Gallery, you could either insert a Gallery or use Concat() to display a nested table in a format of a string.

Was this reply helpful? Yes No
jplug 53 on at

Like (0)

Report
Copy link

Link copied!

Hi Qi,

Thanks for your response, see below:

ForAll(
StaticFilteredGroupId,
Office365Groups.ListGroupMembers(ThisRecord.Title).value
)

Here StaticFilteredGroup are the group ids required in the list.

Jos

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @jplug,

Set the Items property:

Ungroup(ForAll(StaticFilteredGroupId,Office365Groups.ListGroupMembers(ThisRecord.Title).value),"Value")

Then set the Label text property with ThisItem.displayName

Was this reply helpful? Yes No
jplug 53 on at

Like (0)

Report
Copy link

Link copied!

Dear Qi,

Thanks a lot!
It works :).

Was this reply helpful? Yes No