Answered

Custom filter instead of startwith

(0) Share

Report

Posted on by Community Power Pla...

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:

Using Apps Using Formulas

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report

Re: Custom filter instead of startwith

@Anonymous

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

Community Power Pla... on at

Like (0)

Report

Re: Custom filter instead of startwith

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
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

Re: Custom filter instead of startwith

hi @Anonymous

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

Hope it helps