Power Platform Community Forum Thread Details

I am trying to write filter condition for items in a dropdown list for which i am not getting idea how i can do it. Please assist. Below is the requirement.

We have 4 stages for a project(Gate1, Gate 2, Gate 3, Gate 4). We have dropdown in form of every stage. So if we want to select a project in Gate 3 form, then that project should be approved in all earlier stages i.e Gate 1,Gate 2. But we dont want both entries to show for the same project that is Gate 1 approved and Gate 2 approved. So only latest approved stage has to be shown for a project in dropdown list. How can be achieve that?

Example: In below screenshot, Sample 1 project has both Gate 1 and Gate 2 forms approved. Now i want to show only Gate 2 Sample 1 project in Gate 3 form dropdown list not both the items as both list items contains different data.