web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter with variable t...

Power Apps

Answered

Filter with variable to partially match SP List value

(0) Share

Report

Report

Posted on by peeceeke

13

Hello All,

I'm building an app to quickly find phonenumbers or other data about employees in the firm.

I started with a basic page that shows an organisation chart of the different services and on which you can then click to get the right service in a second page. That works well.

Schermafbeelding 2021-07-08 om 09.55.09.png

But to improve the user experience, I also want to have a search field on the basic page that then displays the searched data in another page. To do this, I linked the search field in the first page to a variable that can then be used on the new page to search different fields.

Schermafbeelding 2021-07-08 om 09.59.29.png

And that is where it goes wrong. If you type in the exact keyword, you get results, but if you only type in a part of the word to be searched for, you get no results. (e.g. when you search for "vo" you should get "Bavo" but you get nothing. Even when you but the complete first word "Bavo" you get nothing. If you give the complete name "CLAES Bavo " then you get the desired result but I wanted it to filter on only a part of the string :-(.

Schermafbeelding 2021-07-08 om 10.01.09.png

The column is a TEXT field so nothing special there.

Schermafbeelding 2021-07-08 om 10.02.52.png

I already found and read different posts on the subject but not gave me a solution for my specific problem.

Does anyone have any idea how I can solve this?

Thanks for any thoughts on the subject.

Grtz

Peeceeke

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

try this

If(
IsBlank(TextInput1.Text);
CellPhoneNumbers
;
Search(CellPhoneNumbers;TextInput1.Text;"User";)
)
Verified answer

WarrenBelz 156,768 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @peeceeke ,

I am assuming these are fields you are searching

Filter( Personeelslijst_complete; ( varSearch in Afdeling || varSearch in ACTpersoneel || varSearch in Graad || varSearch in Dienst.Value ) && Actief )

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.
peeceeke 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Works like a charm!
Great thanks a lot

Join the conversation