Announcements
Hi Guys,Does anyone know what happens to my formula? I can't filter the value of dropdown in the Gallery.I'm selecting Pending but no response in my gallery this is my formulaFilter(MasterCollection, ApprovalStatus = Dropdown3.Selected.Result &&If(_managerView, Approver =_myProfile.UserPrincipalName, Requester = _myProfile.UserPrincipalName))
Can you try this so that there is no delegation issues, and may solve your issue.
If(_managerView,
Filter(MasterCollection, ApprovalStatus = Dropdown3.Selected.Result && Approver =_myProfile.UserPrincipalName),
Filter(MasterCollection, ApprovalStatus = Dropdown3.Selected.Result && Requester = myProfile.UserPrincipalName)
)
Thank you! 🙂
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 421 Most Valuable Professional
11manish 153 Super User 2026 Season 2
MS.Ragavendar 116 Super User 2026 Season 2