How to filter my dropdown list?

[AbdullaNsour]

Hi all,
Can we remove the rows that already exist from my dropdown list ?

thank you 

[Izzat_Safrah · Accepted solution]

From column [Jotform] go to valid If and use this formula

Select( Table_Name[Jotform], [Column_Status]<>"Exist" )

Change | "Table_Name"  to name of your table

Change |  [Column_Status] to name of your Column

[Vincent_P]

Hi, 

in your field Payment.Jot_form, you must use an auto compute/suggested value formula.

and u must have a formula like

select(Payment[Jotform], not(in([Jotform, select(Profit[Jotform]))))