Unanswered

I am trying to show one recent record per quotenumber in the browsegallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi I am trying to display the record for the last id per quotenumber in the browse gallery. I tried using max id but I keep getting just one record to populate. using this syntax
Table name: quotedata
SortByColumns(Search(Filter(quotedata,Last(Sort(quotedata,id,Ascending)).id=id,quotenumber),TextSearchBox1.Text, "customername","customerno","shiptoname","shiptocode","id"),"quotenumber", If(SortDescending1, Ascending,Descending))

Here's the data

id	quotenumber	customerno	customername	shiptoname	service	contractsize	dateadded	datemodified	user
1	20-10-01	1447	0001447 AMERICAN REALTY MGT-ALBANESE	GARDEN CENTER CITY ASSOCIATES	Coil Cleaning	$5,000	10/20/2020 4:00		Ola Akinruli
2	20-10-02	1574	0001574 BOSTON UNIVERSITY MEDICAL CAMP	BOSTON UNIV. SCHOOL OF MED. STOU	Coil Cleaning	$500	10/27/2020 4:00		Ola Akinruli
3	20-10-02	1574	0001574 BOSTON UNIVERSITY MEDICAL CAMP	BOSTON UNIV. SCHOOL OF MED. STOU	Coil Cleaning	$5,000	10/27/2020 4:00	10/27/2020 4:00	Ola Akinruli
4	20-10-02	1574	0001574 BOSTON UNIVERSITY MEDICAL CAMP	GREGG JACOBSON JACO	Coil Cleaning	$5,000	10/27/2020 4:00	10/27/2020 4:00	Ola Akinruli
5	20-10-01	1447	0001447 AMERICAN REALTY MGT-ALBANESE	GARDEN CENTER CITY ASSOCIATES 1050	Coil Cleaning	$5,000	10/27/2020 4:00	10/27/2020 4:00	Ola Akinruli
6	20-10-02	1261	0001261 HARRY GRODSKY COMPANY	HARRY GRODSKY COMPANY BOEH	Domestic Water Tank Cleaning	$9,000	10/27/2020 4:00		Ola Akinruli
7	20-10-03	1603	0001603 BROWN PRINTING	BROWN PRINTING GRAV	Legionella Testing	$34,000	10/27/2020 4:00		Ola Akinruli
8	20-10-03	1603	0001603 BROWN PRINTING	BROWN PRINTING GRAV	Legionella Testing	$34,000	10/27/2020 4:00	10/27/2020 4:00	Ola Akinruli
9	20-10-02	1574	0001574 BOSTON UNIVERSITY MEDICAL CAMP	test	Coil Cleaning	$34,000	10/27/2020 4:00	10/27/2020 4:00	Ola Akinruli

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@Anonymous

Check the following post:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Gallery-Filter-for-the-most-recent-records-for-given-ID/m-p/696253

I hope it will give you some clue to work on.

GroupBy and Sort functions will help you to achieve what you need.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for the tip @rsaikrishna It worked. Only issue I have now is when I select a record from the browsegallery, it takes me to a blank Detailed Screen.

Script for the browsegallery
Search(AddColumns(GroupBy(quotedata, "customername","customerno","quote","shiptoname","GroupByquotenum"),"id", First(Sort(GroupByquotenum,id,Descending)).id),TextSearchBox1.Text, "customername","customerno","shiptoname","quote")

Blank details screen

Was this reply helpful? Yes No