Answered

Filtering Choices Dropdown removes Search capabilities and Input Text Placeholder

(0) Share

Report

Posted on by Buckets

Hi all,

I have a large supply list dropdown that is a Choice field in SharePoint. I needed to not allow 3 items to show on that dropdown because they should only show in another form. I am able to get the dropdown list to not show the 3 items, but in Filtering the choices field, I lose the ability to search the list and then I lose the Input Text Placeholder. Here is the code used for the items field of choices dropdown:

Filter(Choices([@'Supply Receipt Logs'].Supply), And(Not(Id = 37), And(Not(Id = 56), Not(Id = 102))))

Is there a way to filter out the 3 items in choices dropdown while maintaining at least the search function and also the Input text placeholder feature (Not as important)?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Buckets,

Do you have a LookUp column?

I have a test and the situation is confirmed on my side that the search function could work when I use the formula you provided:
Buckets 35 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft

Yes, the column in the SharePoint list is a Lookup Column referencing another SharePoint List column in another table.
Verified answer

Buckets 35 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft

I was able to get it working, thanks. The field was initially "Searchable", but after I filtered the data, the "IsSearchable" option switched to "false". I did not change it. It is weird that it changed it itself.