
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!
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.