Filter on AAD table including ampersand

(0) Share

Report

Posted on by Kosenurm

802

Hi,

I am using the below to filter a combobox on the AAD table:

Filter('AAD Users', 'Company Name' = "Company1" || 'Company Name' = "Company2" || 'Company Name' = "Company3" || 'Company Name' = "Company4" || 'Company Name' = "Company5" || 'Company Name' = "Company6" || 'Company Name' = "Company7" || 'Company Name' = "Walker & Co")

The last || (or) is causing an error on the Filter command though, I think it is due to the ampersand in the company name. How can I change this last filter term so, instead, it looks up if Company Name CONTAINS "Walker", it is still included in the Filter?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RahulAnsari 58 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,Kosenurm
remove ampersand and use only Company Name="Walker" like i used in below

Filter( 'AAD User', 'Company Name' = "Company1" || 'Company Name'="Company2" || 'Company Name'="Company3" || 'Company Name'="Company4" || 'Company Name'="Company5" || 'Company Name'="Company5" || 'Company Name'="Company6" || 'Company Name'="Company7" || 'Company Name'="Walker" )

Was this reply helpful? Yes No
Kosenurm 802 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - thanks but that doesn't work. The Company Name on AAD table is "Walker & Co". Using = "Walker" doesn't include the records as it does not equal "Walker".

Thanks

K.

Was this reply helpful? Yes No
RahulAnsari 58 on at

Like
a
(0)

Report
Copy link

Link copied!
Kosenurm

try this i am not getting error in The last || (or) please change table name selectedRequestorList to AAD table
i also change Company Name "Walker " to "Walker & Co" see below

Filter( selectedRequestorList, 'Company Name' = "Company1" || 'Company Name'="Company2" || 'Company Name'="Company3" || 'Company Name'="Company4" || 'Company Name'="Company5" || 'Company Name'="Company5" || 'Company Name'="Company6" || 'Company Name'="Company7" || 'Company Name'="Walker & Co" )

Was this reply helpful? Yes No