Nested Collection Tables to Gallery

(0) Share

Report

Posted on by Kashif1

Hi All,

Here is my scenario. I have PowerApps connected office365Users connector.

I have fetch all persons details reporting to a person to a collection called "centralheadlist". "centralheadlist" is successfully imported to gallery as well .
Now I have one more gallery . where I want to display all records belongs to first record of centralheadlist. Mail . Similarly I want data in same gallery from 2nd record , 3rd and so on . My gallery should change data as per my dropdown selection which has items from centralheadlist. Mail. Please help.

step 1. centralheadlist : ClearCollect(centralheadlist, Filter(Office365Users.DirectReports(If ("Head" in Office365Users.UserProfile(VarUserEmail).JobTitle,VarUserEmail,"You don't have any Delivery Head Under your Org")),"Delivery Head" in Job Title));
step2: ClearCollect(TestDataLM,{Gallery_Table:ForAll(centralheadlist. Mail,(Office365Users.DirectReports(Mail)))})
step3: dropdown: items=centralheadlist. Mail
how to make gallery to display data as per selection on dropdown and get relevant data from step2.

Aggregation nested collection Re: Create Nested Collections

Categories:

Building Power Apps

image.png

I have the same question (0)

All responses (5)

Answers (1)

v-bofeng-msft on at

Like (0)

Report
Hi @Kashif1 :
Please try this :
step 1. centralheadlist : ClearCollect(centralheadlist, Filter(Office365Users.DirectReports(If ("Head" in Office365Users.UserProfile(VarUserEmail).JobTitle,VarUserEmail,"You don't have any Delivery Head Under your Org")),"Delivery Head" in Job Title));
step2:

Clear(centralheadlist); ForAll(centralheadlist.Mail, Collect(TestDataLM, {Gallery_Table:Office365Users.DirectReports(Mail), Mail:Mail} ) )

step3: dropdown(Dropdown1)
items

TestDataLM

Step4:set the gallery's items properity to:

Dropdown1.Selected.Gallery_Table

Best Regards,
Bof

Was this reply helpful? Yes No
Kashif1 15 on at

Like (0)

Report

Hi @v-bofeng-msft ,
I tried but there is no data in centralheadlist now.
See my Onvisible screen property:
Rest i have updated as per your recommendation

Was this reply helpful? Yes No
Kashif1 15 on at

Like (0)

Report

Hi @v-bofeng-msft ,
After making //Clear(centralheadlist); this on onvisble property of screen i can see its loading as per Dropdown . Thanks .

I have last query . This data will autoupdate whenever there is change is outlook users (office365Users)?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @Kashif1 :
I suggest you put these codes into the OnSelect property of a button to test whether the code works correctly.
Best Regards,
Bof

Was this reply helpful? Yes No
Kashif1 15 on at

Like (0)

Report

HI @v-bofeng-msft ,

Thanks. It somehow solved my half now at least i have data in hand . Now i can apply filters refine my data.
I also got my mistake. Thanks for the guidance.

Was this reply helpful? Yes No