Remove a entered item from a dependent dropdown list

Hi I have a app with that uses a dependent drop down list of raw materials to complete a bill of materials. However, the users find that it can be difficult to keep there place when selecting the raw materials.

Is there a way to remove an item from the list once it is selected ( I thought I saw a post detailing this before but I can find it)? The Raw materials table are ref to another table as well.

Solved Solved
2 12 1,789
1 ACCEPTED SOLUTION

@Elijah_Magrane
I donโ€™t know your expression for creating the dependent dropdown, but you can try this expression in your Valid_if

TableName[ColumnName] - SELECT(TableName[ColumnName],[ColumnA]=[_THISROW].[ColumnA])

View solution in original post

12 REPLIES 12
Top Labels in this Space