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]

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]))))