Announcements
Filtering of data to be displayed by user roles and execution status of the data
Hi @Elmer_Wan ,
Please try this in the Item of Gallery:
Switch( LookUp(personnelInformationSheet,Email=User().Email).Role, "RoleA", Filter(Col,ColumnName = Condition1), "RoleB", Filter(Col,ColumnName = Condition2), Blank() )
Hope this will help you,
Best Regards,Tina
Thank you very much for your help, you give the case of this function can meet my needs, according to the test has successfully solved my problem, thank you very much!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 400 Most Valuable Professional
11manish 141 Super User 2026 Season 2
MS.Ragavendar 109 Super User 2026 Season 2