Unanswered

Filter Data by SharePoint Title field by two text values

(0) Share

Report

Posted on by Community Power Pla...

My filter worked great until I needed to add a second acceptable text value to the Title field how do I fix that filter line to ensure items with either of those two title values pull in?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Can you please post the entire code you have there in Text.

Was this reply helpful? Yes No
Verified answer

AsanKani 710 on at

Like (1)

Report
Hi @Anonymous
Update you code like below after your Filter('DataSource',

(Title = "FirstText" || Title = "Second Text")

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

that doesn't work either @AsanKani

@WarrenBelz here is my code, i think this is cuasing me issues when I do hard resets on these filters in my editable gallery too as it totally clears out my collection and never has data to reload once i do (Re: Gallery Items not showing after edit, patch, r... - Power Platform Community (microsoft.com)) i thought i had this fixed but just ran into it again today, here is my code for this item that relates to that one as well:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I take that back I see what i missed you were right @AsanKani

If either of you can help on the other ticket i refrenced above it would be much appreciated, i'm very close to wrapping up my project thanks for the help

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report

@Anonymous it's ok..
You must make () in Title otherwise some case your formula work wrong.
because your are using next of title &&
So, one case it's consider like this (Title ="FirstText") || (Title ="SecondText" &&.......). So, Your hard effort will be go wrong, So, make () in Title or condition.

If the content was useful in other ways or you liked the post and want to show some appreciation, please give it a Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report

@Anonymous ,

I am glad you got it sorted, but please remember to post code as Text (not an image)

Was this reply helpful? Yes No