cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
golfnutt82
Super User
Super User

Filtering data on a form using a Lookup

I am struggling to find a way to filter the form to only show items that have not been processed.
It is possible that there could be multiple entries for the same "Role" but there can only be one that is open.
I have a field in my list called Approval Status and I only want the lookup to show items where the Approval Status is not equal to "Processed". So my first thought was, could I reference two different data sources in my "Search(Filter( function used in the dropdown. My next thought was changing the formula for the Item property of the form.
Can anyone please assist?

golfnutt82_0-1651679622743.png

 

10 REPLIES 10
golfnutt82
Super User
Super User

I wound up making some changes. The Roles list wasnt the correct list to point at so once I changed up the logic it now works as expected.

golfnutt82_0-1651757941996.png

 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (5,386)