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

Announcements

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 671

#3
Haque Profile Picture

Haque 551

Last 30 days Overall leaderboard