Answered

Need help with Gallery filter

(0) Share

Report

Posted on by AT-07111408-0

Need help with filtering gallery

I have a created powerapp which have 2 gallery controls on the screen . first gallery connects to Office365 connector and gets direct reports of logged in user, second gallery connects to dataverse table which has UPN and Status of all users. I want to show status info of all direct reports in the screen .

when i use below formula, it works but for mutiple direct reports i have to select each cell to get info, my requirement is to show value for each user in gallery 1 in table format .

Filter(datasource,userPrincipalName=Gallery2_3.Selected.userPrincipalName)

Please help!

I followed Reza Dorrani's video for direct reports to build this app.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @amritat ,

Please try below formula:

ForAll( Gallery2_3.AllItems As G2, Filter( datasource, userPrincipalName = G2.userPrincipalName ) )

Hope this helps.

Best regards,

Was this reply helpful? Yes No
AT-07111408-0 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response ! I tried this formula but it does not give me desired results, when i apply above formula to gallery and add label to gallery , i get 2 options - Thisitem.isselected and Thisitem.value . This item.value.<somefield> , gives me scope error so i am not able to get the field data from the Datasource i am looking for.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @amritat ,

Sorry, have forgotten to expand the grouped tables.

Ungroup( ForAll( Gallery2_3.AllItems As G2, Filter( datasource, userPrincipalName = G2.userPrincipalName ) ), "Value" )

Best regards,

Was this reply helpful? Yes No
AT-07111408-0 on at

Like (0)

Report
Copy link

Link copied!

This worked ! Thank you so much !

Was this reply helpful? Yes No