Power Apps - Search function to find multiple results

(2) Share

Report

Posted on by fabiotodton

Hey guys.

I created a Microsoft List with some columns.

These columns allow users to enter information.

From this Microsoft List, I created an application in Power Apps (Canvas).

1º = ThisItem.'Nº NF'

2º = ThisItem.CC

3º = ThisItem.Fornecedor

However, on the first screen, where you have the gallery (where new items appear), just above there is a "search" field, to easily locate these items.

But it doesn't work.

I try to search for ANYTHING that appears in there, and in none of the cases did it come up).

My gallery have this expression:

SortByColumns(Filter([@'Notas Fiscais']; StartsWith(Title; textolocalizar.Text)); "Title"; If(SortDescending1; SortOrder.Descending; SortOrder.Ascending))

where:

"Notas Fiscais" is the name of my Microsoft Lists
"textolocalizar" is the field where we type what we want to search for

I wanted to look for any of the 3 that appear there, it could be anything that appears

Can you help me?

Categories:

Business Process Flows

All responses (1)

Answers (0)

fabiotodton 56 on at

Like (1)

Report

Power Apps - Search function to find multiple results

Solved:

SortByColumns(
Filter(
[@'Notas Fiscais'];
StartsWith(
Title;
textolocalizar.Text
) Or StartsWith(
Fornecedor;
textolocalizar.Text
) Or StartsWith(
'Nº NF';
textolocalizar.Text
) Or StartsWith(
CC;
textolocalizar.Text
)
);
"Title";
If(
SortDescending1;
SortOrder.Descending;
SortOrder.Ascending
)
)