web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Multiple values in fil...

Power Apps

Answered

Multiple values in filter clause in powerapps

(0) Share

Report

Report

Posted on by rupa1

72

hello,

i wanted to add multiple values in a filter statements but its not working - can you all help?

How can i add multiple names in filter clause?

Search(Filter('SP List','Name of User' <> "name 1" || "name2"),TextInput1.Text,"NameofUser")

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (3)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(2)

Report
Copy link

Link copied!

Try
Filter( 'SP List' StartsWith( Name1,TextInput1.Text ) || StartsWith( Name2, TextInput1.Text ) )

If you have issues, explain further the columns you want to filter
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

Loose Chippings 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rupa1

The syntax for Filter is Filter(Source, logical test, logical test,....), so I believe that Search(Filter('SP List','Name of User' <> "name 1", 'Name of User' <> "name2"),TextInput1.Text,"NameofUser") should work in your case.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rupa1 ,

Could you describe more clearly about your filter rule?

The syntax should be like:
Filter(data source, rule1,rule2,rule3,...)

"name 1" || "name2" does not represent name1 value or name2 value.

I assume that your filter rule is :
'Name of User' is not equal to "name1" or "name2" and filter based on TextInput1.Text.

If so, you should try this formula:

Search( Filter('SP List','Name of User' <> "name 1"|| 'Name of User' <> "name2" ),TextInput1.Text,"NameofUser")

Best regards,

Was this reply helpful? Yes No

Join the conversation