Answered

Filter based on textsearchbox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I am programming an application and I want startswith to be replaced with the function search. How can I do this?

SortByColumns(
 Filter(
 [@ProjectLijsten];
 StartsWith(
 Title;
 TextSearchBox1.Text
 )
 );
 "Title";
 If(
 SortDescending1;
 Descending;
 Ascending
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey mate,

Use the Search function like so:

Search([@ProjectLijsten], TextSearchBox1.Text, Title)

Regards,
Jacob Shand | Automation Specialist
NextStep Creations

Taking your PowerApps Skill the NextStep

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

Like (0)

Report
Copy link

Link copied!
Hey!

I have tried this but I get an error.

SortByColumns( Filter( [@ProjectLijsten]; Search([@ProjectLijsten]; TextSearchBox1.Text; "Subordernummer" ) ); "Title"; If( SortDescending1; Descending; Ascending ) )

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

Like (0)

Report
Copy link

Link copied!

What error are you getting? Add a screenshot and I'll take a look 🙂

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

Like (0)

Report
Copy link

Link copied!

Apparently it is expecting the column to be text only. So I'll need to change that. And then it's saying the filter and search functions have invalid arguments. @Anonymous

Changed it to a text column and I now get this error:
https://gyazo.com/8a7e79e6a5c429a012a7b14b8966dd43

And also this error:
https://gyazo.com/bc32897eec899d63821422449b0a5f20

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to replace the Filter function with Search function within your formula?

Based on the needs that you mentioned, I think there is something wrong with it. Please consider modify your formula as below:

SortByColumns( Search( [@ProjectLijsten]; TextSearchBox1.Text; "Title" ); "Title"; If( SortDescending1; Descending; Ascending ) )

More details about Search function, please check the following article:

Search function

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No