Answered

Compare two sentences split with space

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a complex requirement that I cannot figure out the correct syntax. I have a gallery control load with various UserNames.

e.g. Peter OO Parker, Michael AZ Jackson, Turd AB Ferguson.

In the TextSearchBox1 user can type in multiple keywords. e.g. "Peter Parker", "ter ker"

I want user can find "Peter OO Parker" when type in "Peter Parker". He should not find it by type in "ter ker".

Thank you very much.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous :

I'v made a test for your reference:

1\My data source:

ClearCollect(Testcollection,["Peter OO Parker","Michael AZ Jackson","Turd AB Ferguson"])

2\The formula

Filter( Testcollection, Sum( ForAll( Split( TheTextInputControl.Text, " " ), If( !(Result in Split( Value, " " )), {Count: 1}, {Count: 0} ) ), Count ) = 0 )

Best Regards,

Bof

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

Like
a
(0)

Report
Copy link

Link copied!
I amended some syntax to fit my original query. But it prompt me "The function Split has some invalid agrument". The warning line is under Split(Value," ")

// some conditions ||(Sum(ForAll(Split(TextSearchBox1.Text," "),If(!(Result in Split(Value," ")),{Count: 1},{Count: 0})),Count) = 0) || // some conditions

Is my change cause Value not being recognized?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous :

On your side the formula should be:

Filter(
YourDataSource,
Sum(
ForAll(
Split(
TheTextInputControl.Text,
" "
),
If(
!(Result in Split(
Name,
" "
)),
{Count: 1},
{Count: 0}
)
),
Count
) = 0
)

Best Regards,

Bof

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks v-bofeng-msft, the formula is working now. Is it possible to change the compare condition to "StartsWith"? So that input "Pet Par" can return result?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous :

Yes.

Best Regards,

Bof

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

Like
a
(0)

Report
Copy link

Link copied!
Because "StartsWith" do not work with a collection or table (e.g. Split(Name," ")). Should I use a nested "ForAll" for my purpose?

It is my start but full of syntax error:

(Sum(ForAll((Split(TextSearchBox1.Text," ") As A),(ForAll(Split(Name," ") As B),If(!(A.Result in B.Result),{Count: 1},{Count: 0}))),Count) = 0)

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

Please try :

Filter( Testcollection, Sum( ForAll( Split( TheTextInputControl.Text, " " ) As Table1, If( Sum( ForAll( Split( Name, " " ) As Table2, If( StartsWith( Table2[@Result], Table1[@Result] ), {Count: 1}, {Count: 0} ) ), Count ) = 0, {Thecount: 1}, {Thecount: 0} ) ), Thecount ) = 0 )

In addition, if your previous problem has been solved but you still want to ask a new one, please consider marking my reply as "solution" and creating a new thread.

Best Regards,

Bof

Was this reply helpful? Yes No