web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Apps - Search fu...
Power Automate
Unanswered

Power Apps - Search function to find multiple results

(2) ShareShare
ReportReport
Posted on by 56
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:
I have the same question (0)
  • fabiotodton Profile Picture
    56 on at
    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
        )
    )

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard