Power Platform Community Forum Thread Details

I'm trying to hide a value in a drop-down if a value is selected in the other drop-downs. (in a gallery)

I have the following:

- Collection list of my drawdown choices:

ClearCollect(colDrpdwnJobType,{ID:1, Name: "Job1"}, {ID:2, Name: "Job2"}, {ID:3, Name: "Job3"});

- Formula where i collect the selected items after the creation of a new item in a gallery

If(
 Not(
 LookUp(
 GalleryJobs.AllItems,
 ID = LastJobID
 ).Dropdown2.Selected.ID in colSelectedJobData.ID
 ),
 Collect(
 colSelectedJobData,
 LookUp(
 GalleryJobs.AllItems,
 ID = LastJobID
 ).Dropdown2.Selected
 )
);

- OnChange of the dropDown:

If(Not(Self.Selected.ID in colSelectedJobData.ID),Collect(colSelectedJobData,Self.Selected))

- My filter on items of the dropdown:

Filter(colDrpdwnJobType, !(ID in colSelectedJobData.ID))

What I'm trying to achieve is that when a user adds a new item in a gallery, only the left 2 values are displayed and the 1st dropdown is filtered too depending on what default in the second one.

Now the dropdown filter applies to all my dropdowns in a gallery

Thanks

Categories:

Building Power Apps