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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / how to display all rec...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by bbsin 1,994

hi

 

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

1.PNG

 

 

Categories:
Building Power Apps
  • Sid_Jafri Profile Picture
    Sid_Jafri 478 on at

    Hi @bbsin ,

     

    Your Gallery items will be

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

     

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

  • bbsin Profile Picture
    bbsin 1,994 on at

    hi @Sid_Jafri 

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

  • Sid_Jafri Profile Picture
    Sid_Jafri 478 on at

    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.

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 360 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 325

#3
Mohsin Ali Profile Picture

Mohsin Ali 232

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans