PowerApps: Gallery / SubGallery using GroupBy and Flexible Height

Подписаться 3,5 тыс.

Просмотров 64 тыс.

50% 1

Nesting a gallery with another gallery to show related data - e.g. an Order Header with multiple rows of Order Details beneath.
A key concept is the GroupBy function to 'shape' your data and controlling the height of flexible height galleries so your detail rows are always visible.

Наука

Опубликовано:

16 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 57

@joelpeterson2074 8 месяцев назад

Hi Paul! Just got a nasty nested gallery to work using this video, FIVE years later! You are such a lifesaver, thank you so much! +1 subscriber for you good sir!

@lorivalone4179 5 лет назад

Excellent tutorial! With the aid of this video I was able to quickly solve my remaining problems with my GroupBy with nested galleries. Thanks Paul! I look forward to your other videos including the one you mentioned here regarding using normalized data instead of a single record.

@miryam5390 6 лет назад

Hey Paul, thank you for taking the time to produce this excellent video.

@b0rme 3 года назад

Just came to say this is the exact solution I needed. Thank you and keep up the good work

@alterdom 2 года назад

Thank you Paul! Great video. In the nested table, I have added an auto-height label where the size of, say "Beef Burger", can end up being "100% Certified Vegan Plant-Based Burger Patty with....." and so on, so the auto height is meant to capture more text. So in this case instead of multiplying the Count of Rows from the nested gallery with 60 I would multiply it by the height of that label (assuming it could grow or shrink depending on the item in that nested gallery). However, I seem to be running into issues with the height of the label returning Blank or 0 ex. galNestedGallery.Height = CountRows(colNestedGallery) * AutoHeightLabel.Height where AutoHeightLabel.Height would return Blank or 0 but if I click into directly, the label control itself is giving me a height in the formula bar. Have you encountered this issue?

@tommikarppinen4316 Год назад

Hi, if you alterdom or anyone else have found a solution to implement flexible nested gallery with flexible text label size please let us know. I have tried exact same solution than you :)

@dimitribarbaressos Год назад

@@tommikarppinen4316 Hi! I am also looking for a solution to this exact issue. Please do let me know if you find anything!

@Davenettletontube 6 лет назад

This is so useful, and such a practical approach! thank you so much!

@milinprkh 4 года назад

Too good! Excellent Paul! Thanks a lot!

@aaronroth3926 6 лет назад

This is exactly what I needed. Great presentation. Thank you.

@Test27344 4 года назад

This is perfect! Thank you so much!

@colinbromage8270 5 лет назад

Very useful Paul, many thanks!

@LucaChiamenti 6 лет назад

Hi Paul, great video !

@rodrigopresencebagarolo2892 3 года назад

That's exactly what I needed, thank you!

@jray1429 2 года назад

Excellent information - Very useful. Thank you for taking the time to do this.

@notonurnelly 3 года назад

Still extremely useful after 3 years :)

@grahamsheeley 6 лет назад

Supper informative, many many thanks. As a minor give back: To deal with the wrapping of the subgallary text then affect the calculated gallery height. What I did was 1) added to the subgallery a hidden field called NoRowsForTheSubCategoryLabel. 2) set the NoRowsForTheSubCategoryLabel Text to be RoundUp(Len('SubCategory (title)'.Text)/32,0) Obviously the 32 will dependant on the width of the subcategory title label, but you can amend this until it gets it right 3) Then add to the Parent gallery a field called CalculatedHeighofSubGallary 4) Set CalculatedHeighofSubGallary text to Sum('Gallery-SubCategories'.AllItems,NoRowsForTheSubCategoryLabel) * 45 You can play with the *45 to meet you specific need. Many thanks once again for sharing how you did your work.

@pauloflaherty6757 6 лет назад

Thanks Graham - interesting solution to the text wrapping issue, I'll have to give that a try!

@jalalsemaan8129 3 года назад

Excellent Tutorial! Thank you

@onurcam 3 года назад

This is great. Thank you!

@carlw 6 лет назад

Cool thanks. Have you done anything with editing the data (sub items?). I have a parent child setup using clearcollect and a patch function but as expected, is providing some problems. This may be an alternative method to use rather than Gallery/sub-gallery (or form)

@rodolfo602 4 года назад

top notch please keep going!

@atmikes1 3 года назад

Great! thanks for good explanation and sharing, Just what I was looking for and was nowhere to be found

@johnheck1551 4 года назад

Paul thanks for the great video. The gallery/subgallery using groupby works great. How do you go about connecting a form for add/update/delete from a subgallery item? Do you have a video that talks about this option?

@imranfc 4 года назад

superb work.

@johnheck1551 3 года назад

Hello Paul, you mention an example of using the GroupBy function for a Gallery-in-a-Gallery with a normalized SQL database. Have you done a video on that yet? If so, can you share the link? I really like how this works, especially with SPO list, would like to implement this same concept using SQL tables.

@pratk30 5 лет назад

Hi Paul, it was great session, but i am stuck here at one step. I am using nested gallery and creating some control. I need to read all these control or you can need to store all value of these control(in sub galleries) in another table.

@DIYCreditRepairKit 5 лет назад

Awesome video but how would you send that in a email with the same format as it shows? I'm struggling trying to figure that out

@marialekalakala4578 5 лет назад

Hi Paul. This is a great video. It helped me greatly. I want my users to search/filter by the items in my main gallery. How do i go about doing that? I would really appreciate your assistance

@MinhNguyen-fu5xr 3 года назад

Hi Paul, can you please give a hint on how to make the subgallery collapsible? Thanks!

@isaidstream4547 3 года назад

AWESOMEE

@altfo 4 года назад

Nice Tutorial

@kevindoesnotmatter5220 3 года назад

Quick Question... What if your column you want to GroupBy is a collection in itself? How do you reference it? I am putting a SharePoint List into a Collection, but the value I want to GroupBy is a Lookup value in SP, which comes across as a sub-collection. So it is as if I need "OrderHeaderID.Value" since "Value" is the column name of my sub-collection for the field "OrderHeaderID".

@maxwendorff8826 5 лет назад

How would I add a search field to this to search by a column?

@lorianderson2639 2 года назад

This is awesome. In my app I am displaying the users' photo from Office365Users.User Photo for items where a true contact exists in my SP list column and if there is no person assigned it uses a generic photo. But when I apply sorting to the gallery (in the items property), the first image that loads will be displayed for other items that have no contact and no image. Any idea why the first image would be duplicated down the gallery?

@larryheimendinger6952 2 года назад

I creeated an app in tablet layout and the parent gallery remains statc height. Using the exact same values for a mobile layout, it works exactly as expected; both parent and child gallleries resize. I noticed you use a mobile layout as well: does it only work in that mode?

@wilsonajames 4 года назад

Every time I try to adjust the height my grouping disappears. All I can see is the second gallery I added; the details. Even when I preview the data it has disappeared. Any suggestions?

@notonurnelly 6 лет назад

Excellent Video Paul, I will use this technique on a project I'm working on. Do you think there is a possibility to collapse the sub galleries. Perhaps an onselect trigger off the main gallery which adjust the viable property of the sub gallery. I'll keep my eyes peeled for further videos.

@pauloflaherty6757 6 лет назад

That is an excellent idea. Yes, this can be done easily. In the Height property of the SubGallery simply add: If(GalOrderHeader.Selected.OrderHeaderID = ThisItem.OrderHeaderID, Count(GrpOrderDetail.MenuItemID)*33+3,3) In this case: GalOrderHeader is the Parent (top level) gallery. OrderHeaderID is the field that I've grouped on. GrpOrderDetail is my name for the grouped (nested) records within the datasource. 33 is my line height within the sub-gallery 3 is the gap I want to leave between header gallery items MenuItemID is a numeric field (use CountA for a text field) that is included within the GrpOrderDetail 'nested' record. I just gave this a try and it looks great - the detail records (sub gallery) appear when you tap on the header record (main gallery). When you tap on one header, the records for the last header are collapsed. If you want all the items to expand/collapse, just use a toggle button and replace the IF condition in the above example to sometime like If(tglCollapse = 0, 3, Count(GrpOrderDetail.MenuItemID)*33+3) If you wanted the ability to open/close multiple galleries, you could use a collection to add/remove the IDs that should currently be 'open' and in the Height property test for the presence of ThisItem.ID in the collection and only expand if it is there... this might warrant another little video later in the week :)

@notonurnelly 6 лет назад

Many Thanks for explaining this Paul, I will have a go at the full tutorial and add the extra functionality that you have described. Keep up the good work and I will subscribe to your channel and look out for further videos

@milinprkh 4 года назад

Hello Paul, Your videos are absolutely helpful and great presentation. I had one query please, i am not able to add a search formula for the galleries screen. Example: If i want to search the gallery with OrderHeaderID what will be my Items formula? In my first Gallery.Items is GroupBy(TimesheetTable,"Application_x0020_Contract","grpApplicationContract") In my nested Gallery.Items is ThisItem.grpApplicationContract I want to search using the Application_x0020_Contract field. Please please do let me know your reply.

@michelhaffar 6 лет назад

Hi Paul, very helpful videos. Thank you for producing them. Do you help people develop their apps as a freelancer?

@pauloflaherty6757 6 лет назад

Hi Michel, yes, happy to take on freelance work - you can reach me at paul 'at' pdtech.co.uk if you want to discuss further.

@kmuralikrishna1582 4 года назад

Though it is in highest(420p) but stll can't see properly since you are using 75 browser , you should of use in maximize the browser. What I mean to say is when you are entering formulas for the controls not able to clear. Seems like small ants

@kbirstein 6 лет назад

Microsoft needs to add a real expand and collapse control. This won't work in the real world because of the problem of lines wrapping, which will happen in most instances, especially on a mobile screen.

@altfo 4 года назад

Expander/Accordion is very much needed with animation !!

@funnycutevideo7561 4 года назад

Question, I had been following steps in your video and at step: Height = CountA(grpOrderDetail.Category) *60, I kept on getting this error "this formula uses scope which is not presently supported for evaluation", how did you avoid this error? Thank you very much!

@funnycutevideo7561 4 года назад

Here are my detailed steps: Gallery 1: the outside gallery: items = GroupBy(Table1,"company_name","grpCompanyDetail") Gallery 2: the embedded/inner gallery: items = ThisItem.grpCompanyDetail height = CountA(grpCompanyDetail.Category) *60

@kendallphillips3341 3 года назад

I'm have the same issue. Did you ever figure this out? It appears if you use ThisItem it will fetch the row count, but has to be selected for that to happen. I also notice, when referencing text boxes back the the data source, he didn't use ThisItem, just typed in the column name. If I use ThisItem, I can click the headers and they will show up the first time, but if I don't close it before trying another, I have to click it again to activate. Strange....

@moyura2 2 года назад

Thanks for sharing that's very usefully information. I was wondering, how would you apply this concept to a single table, like a timetable of part time employees (ID, Name, Date, Time In, Time Out), how would you group the employee with weekly date range (eg.1 Jan 2021 - 7 Jan 2021) ?

@pauloflaherty6757 2 года назад

Hi Moyura. That depends a lot on your data source. If you are using SQL you can create a View that gets the data into the correct 'format' on the server and then just add that View as a Datasource. There are standard functions for getting a week number, but you may want to look up the concept of dim date tables so you can easily specify your own grouping periods in case these are specific to your organisation. I'm not so familiar with SharePoint, but you can possibly add a calculated column to SharePoint to give you a week number. Not sure at all what options you have for Dataverse as I really dislike Dataverse and try to avoid it as much as possible. You can try posting a question in the PowerApps community forums - they have a section for Dataverse questions: powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

@moyura2 2 года назад

Hi@@pauloflaherty6757 Thanks for taking your time to respond to my query. My data source is a single Excel file store in One Drive. Shane Young, a youtuber shows how to create a monthly/weekly calendar, but I couldn't group the names with weekly date range. I tried to post my query on the community forum, but I haven't received any suggestion or solution so far.

@edhalsim 3 года назад

Nice video, but you're cheating when setting the height. What if, like in my case, the nested gallery items range from 1 line to 5 lines of wrapped text? Then you can't just multiple n * 60 as each one can have a different height. What do you do then?

@pauloflaherty6757 3 года назад

Thanks for the feedback. Yes, if the template sizes (heights) of your inner gallery 'rows' are variable this method isn't going to work for you and when I was first looking into this I didn't find a working solution for that scenario (trying to return the height of each inner row and summing them didn't work back when I was experimenting with this, not sure if there are any improvements that would make that work now).

@cazillo 3 года назад

Tons if great info but slllllooooowww. Like watching paint dry!

@anabylmychel5599 Год назад

Hi, loved the video on how to make galleries in another gallery. How do I proceed if I want to open the selected form from my sub gallery?? I've tried subgallery.selected. it doesn't work