Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

how to display all record if the search box is empty and how to patch as ALL not individually?



I have a search box current it's search by the item number if the user input

how to display all records in the gallery if there's  no search done.


I have a gallery , under Type there are 5 categories, I just want to show 2 type of all the records in the gallery  and user are able to search by the 

gallery is 

Filter('list', StartsWith(Item No, SearchGRQuery)) and also the record to display latest. by invoice date


Current I have a update (patch button for each record),  i try to patch all but cannot.


Kindly advise.


Thank you




Responsive Resident
Responsive Resident

Hi @bbsin ,


Your Gallery items will be

Search('list', searchGRQuery.Text, "POno")


Please Thumbs up if my post helped you solve your issue.

Post Prodigy
Post Prodigy

hi @Sid_Jafri 

not this will hv delegation problem.  the yellow triangle is out.

Responsive Resident
Responsive Resident

Hi @bbsin ,


Delegation will be in the filter too if you exceed the limit in your filter query. You may load data into the collection and do the search


Please Thumbs up if my post helped you solve your issue.


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,114)