cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbsin
Post Prodigy
Post Prodigy

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

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

 

 

3 REPLIES 3
Sid_Jafri
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.

bbsin
Post Prodigy
Post Prodigy

hi @Sid_Jafri 

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

Sid_Jafri
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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,482)