Power Platform Community Forum Thread Details

Hello all,

I would like to Filter to retrieve records from the "list1" data source based on certain conditions. The condition is that the "Status" should be equal to " Approve", and the "Title" should match the "Title" field in the "List2" data source for any of the person field that is there are 2 person field, if the current logged in user is one of the person then it should display the record in his/her gallery.

I tried , the item property of gallery is

Filter( list1,Status.Value = "Approve" && ( Title = Look Up(list2, people field1. Display Name = User().Full Name, Title) || Title = Look Up(List2, People field2 .Display Name = User().Full Name, Title)))

It won't work and not shows any error, help me to figure out. Thanks

Categories:

Building Power Apps

@ThaarA-1424

your formula looks good Issue should be with data. Wild guess is cases/spaces of characters.

labelpeoplefield1:Look Up(list2, people field1. Display Name = User().Full Name, Title)

labelpeoplefield2:Look Up(list2, people field2. Display Name = User().Full Name, Title)

Take another gallery for testing the data

items : List1

label1:Status.Value = "Approve"

label2:Title

label3:Title = Look Up(list2, people field1. Display Name = User().Full Name, Title)

label4: Title = Look Up(List2, People field2 .Display Name = User().Full Name, Title)

This works for me always for such issues. i hope it works for you too.

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.