Answered

Custom filter instead of startwith

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Folks!

I have a sharepoint list and I would like to search between them with text input. The below works like a charm but this solution only filter my items based on the starting characters. How can I create a filter what is works like "ctrl+f" in a acrobat reader(example)

Filter(Sp list, StartsWith(Title, TextInput1.Text))

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Anonymous

try Filter(Sp List, TextInput1.Text in Title)

Hope it helps

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @rubin_boer for your suggestion. This worked but the program higlightes this with delegation problem but at this: Filter(Sp list, StartsWith(Title, TextInput1.Text)) is not. Do you have any clue for it? What is the difference between the two filter?

Edit: Okay I see now. I think this has delegation problem due to the "in" within the filter. Do you have any solution for that? I mean that I can avoid the delegation problem.

Thank you

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@Anonymous

There are several depending on your situation and the size of your list. https://www.practicalpowerapps.com/delegation/power-apps-delegation-sharepoint/

Was this reply helpful? Yes No