How to collapse and expand (Group/Ungroup) using Power Apps

In this video you will learn how to expand and collapse rows in a gallery!
Allowing you to create custom applications and interfaces that are similar to Excel and more.
This will be a step by step guide on creating the visual with it's logic so you may customize to your needs.
I'd love to hear feedback and suggestions in the comments.
More videos to come!
Let’s connect on social:
LinkedIn: www.linkedin.com/in/arslan-muhammad-a7a09a106
#PowerApps

[@Arthuro3513]

U really helped me
thanks

[@danher4607]

Excellent technique for displaying the table with expand and collapse. Thank you very much for sharing your knowledge!!! 👏👏👏👏👍👍👍

[@dinubartwal]

love you buddy, you saved lots of effort.

[@BrentonCollas]

Awesome concise video. You seem like a man who has more to teach the community ;)

[@Tycoon33333]

Excellent work. Changing the background colour of the expanded group would be a nice feature.

[@moinamalek3059]

All I’ve thought about all day is you ❤

[@JenMayB]

Love it! Thank you!

[@shaantoshholaay3310]

Superb Bro

[@DjOxid32]

Thank you very much!!! 👏👏

[@JorgeMorales-yd4xc]

Thanks a lot!

[@pallomacarvalho5071]

you saved my life! :D

[@rarun0080]

Nice Video. Thanks for posting. I do have an question I want to expand and shrink based on two columns say Sales Rep and Region. Assume Region is a date field. How to perform it. Any pointers I highly appreciate it.

[@iulianburlacu]

Nice work. Now... can we add a third level? Like 3 tables (Parent - Child - Grandchild)?

[@thanghuu887]

🎉🎉🎉🎉🎉

[@zerocool200380]

Hi Arslan, can we expand the same concept one level down? so we group under the sale rep and then under different projects/products he is selling? if Yes, can you share with me the code for expanding the items ?

[@Toranoshis]

Is there a way to start the app with all collapsed? I put the "collapse all" code in the "onStart" event, but it doesn't seem to work.

[@frankitacker5103]

wheres my sub?

[@Power-Apps]

Subbed to you!

[@frankitacker5103]

@@Power-Apps thank you. Liked for you

[@Ian_Enterprise]

Hello, Just awesome
Could you helpme out please
It seems when i press the minus it hides everything exept the first one?
What do i wrong, i want the other data still visible
With(
{WMST: myData};
SortByColumns(
Filter(
WMST;
(
Len("john doe") = 0 ||
"john doe" in CUSTOMER && TYPE = "PICKUP" && ADDED = Blank()
) &&
Or(
frmSearchBox1 in Notes.Value && TYPE = "PICKUP" && ADDED = Blank();
frmSearchBox1 in DateText && TYPE = "PICKUP" && ADDED = Blank();
frmSearchBox1 in 'ITEM NAME' && TYPE = "PICKUP" && ADDED = Blank();
frmSearchBox1 in CUSTOMER && TYPE = "PICKUP" && ADDED = Blank()
)&& If(CUSTOMER exactin colCollapsetExpandGroup.CUSTOMER And Not('Id (ID)' exactin colCollapsetExpandGroup.'Id (ID)');
false;
true
)
);
"Title";
If(
SortOrder.Descending;
SortOrder.Ascending
)
)
Thank you