You’re offline. This is a read only version of the page.
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.
This worked ! Thank you so much !
Hi @amritat ,
Sorry, have forgotten to expand the grouped tables.
Share
Report
All responses (
Answers (
Ungroup(
ForAll(
Gallery2_3.AllItems As G2,
Filter(
datasource,
userPrincipalName = G2.userPrincipalName
)
),
"Value"
)
Best regards,
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.
Hi @amritat ,
Please try below formula:
ForAll(
Gallery2_3.AllItems As G2,
Filter(
datasource,
userPrincipalName = G2.userPrincipalName
)
)
Hope this helps.
Best regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
143,487
