Power Platform Community Forum Thread Details

Need help on filter fx.

I have a SharePoint List which goes multiple level of approval (below screenshot for ref.)

while I try to filter it

Filter(AIM,'1stApprover' & '2ndApprover' & '3rdApprover' = User().Email)

Attached screenshot of App.

its fetching correctly but missing the one which has the same user email for all three approvals.

Categories:

Need help of Filter Query.