web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps ComboBox Filter Items ...

Power Apps

Answered

ComboBox Filter Items Formula to Exclude One Row of Sharepoint List

(0) Share

Report

Report

Posted on by NHammond37

27

Hello,

I am having trouble getting my ComboBox to filter out a single row that is in a SharePoint List. I have been trying a whole bunch of different variations of a formula in the Items property but can not get it to work. A few examples of formulas I have tried:

//Made a new column on the list to try to filter on that column.

Filter('Admins List', 'Admins List'.'Software Request Approver' = true)

//Trying to filter on the text value

Filter('Admins List', 'Admins List'.'Full Name' <> "John Smith")

Filter('Admins List', 'Admins List'.'Email' <> "John.Smith@domain.com")

As well as many other variations of functions and operators but I just can't seem to get it to exclude that one persons row in the SharePoint List. Is the function Filter not the correct one to use in this situation?

Any suggestions greatly appreciated.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 154,481 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @NHammond37 ,
Dealing with your list
Filter( 'Admins List, 'Software Request Approver' = true ).'Software Request Approver Filter( 'Admins List', 'Full Name' <> "John Smith" ).'Full Name'
Note that the second one is not delegable On the <> (Not) parameter

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation