Unanswered

Group By

(0) Share

Report

Posted on by Aliwells632

Hello i have a gallery which display flight number and date but adds a flight no to each new line. How do i group the gallery by Flight number and date.

This is code i have entered

GroupBy('Flight Folder Upload',"ETD/ETA", Filter('Pallets on Hand', 'ETD/ETA'= gal_CargoLoadULDFlightDetails.Selected.'ETA/ETD(Use Original ETA/ETD)' And StartsWith('Flight No', gal_CargoLoadULDFlightDetails.Selected.'Name ({Name})'))))

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Aliwells632 ,

Your description does not make sense to me. Could you share a sample of your data together with the output you're expecting? I suggest doing this in Excel and then pasting it as an image in your reply.
Aliwells632 on at

Like
a
(0)

Report
Copy link

Link copied!

So effectictly a new entry would be Pallet No, CW etc etc. Then what you do is assign each pallet number to Flight number and date. But because you do this to each ACP it comes up with a new line. What i want to happen is it groups all the Flight No and Dates together so you see all ACP allocated to same flight No and date
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aliwells632 - as requested earlier, please share a sample of your data together with the expected result, you will have a solution a lot quicker.
Aliwells632 on at

Like
a
(0)

Report
Copy link

Link copied!

Its the gallery with the 6629. i want them all grouped
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aliwells632 ,

Forget the Power App.

Just "draw" an example of your data in a table (e.g. in Excel), and then draw an example of how you want them grouped.
Aliwells632 on at

Like
a
(0)

Report
Copy link

Link copied!

I want it in the gallery down left all RR6629 on 30 to be one entry like in this list
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aliwells632 ,

You will need to build out a Grouped Gallery for this sort of functionality.

https://www.youtube.com/watch?v=57ADxeo_13k

https://www.matthewdevaney.com/group-the-items-in-a-power-apps-gallery/

You could also use Nested Galleries but in my experience, these result in poor performance, particularly if you know your data will reach high volumes.

https://www.youtube.com/watch?v=25_bdexevGk&t=288s

https://www.youtube.com/watch?v=MDhIjM08u-w&t=552s

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan