cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leonardbd
Helper III
Helper III

PowerApps Display Form filter by other fields values

Hello there,

I would like to filter a Display Form that matches condition of two different fields values.

I have my data source "Exit Clearance V02" with Created (Date). Now I want to filter the record depending on last created date 

and Requestor(Person) with currently logged in user. My code is bellow,  

 

LookUp('Exit Clearance V02',Requestor.Email=User().Email && Created=First('Exit Clearance V02').Created)

 

This does't show any record because there is other records with latest request date by other Requestor.

And following Filter doesn't work either

 

FIlter('Exit Clearance V02',Requestor.Email=User().Email && Created=First('Exit Clearance V02').Created)

 

 PLease guide me on this.

Regards

Leo

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @leonardbd ,

 

You could try:

 

 

First(Sort(Filter('Exit Clearance V02',Requestor.Email=User().Email),Created,Descending))

 

 

Best Regards,
Bof

View solution in original post

WarrenBelz
Super User
Super User

Hi @leonardbd ,

As per your PM request

LookUp(
   Sort(
      'Exit Clearance V02',
      Created,
      Descending
   ),
   Requestor.Email = User().Email
)

View solution in original post

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

Hi @leonardbd ,

 

You could try:

 

 

First(Sort(Filter('Exit Clearance V02',Requestor.Email=User().Email),Created,Descending))

 

 

Best Regards,
Bof

WarrenBelz
Super User
Super User

Hi @leonardbd ,

As per your PM request

LookUp(
   Sort(
      'Exit Clearance V02',
      Created,
      Descending
   ),
   Requestor.Email = User().Email
)

Thanks Bof, This one works. 

Thanks Warren,

This one works also. I just learned the both way of doing this. 

Happy to be the member of this community 😄

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,388)