Power Apps Related Galleries | Nested Gallery with Flexible Height

[@oluwatobipaul6171]

Thanks Reza. I learnt a lot from this video especially nested gallery

[@RezaDorrani]

Glad it was helpful!

[@sembunt8981]

Reza, first off, amazing video. This is teaching me so incredibly much about PowerApps. However, what I was most interested in, is the carousel you show in the preview of the finished nested gallery. With that I mean the part that seems to show a horizontal scroll function through the arrow on the right (visible at 11:54). You would make my year if you could show me how to do this.

[@RezaDorrani]

Most welcome! Check kzbin.info/www/bejne/mJ-maahpnMmKqdUsi=PDMjEP1V1JKUmYVL

[@nancynombo9141]

Thanks Reza. Always more than helpful. Is it possible to have all rows of a nested gallery printed if height is greater than the screen?.

[@RezaDorrani]

I have not attempted printing with this approach hence not sure about the possibilities

[@nancynombo9141]

@@RezaDorrani Thank you for quick answer. I appreciate all you do.

[@RezaDorrani]

@@nancynombo9141 Thanks

[@prosperkamana7146]

Thank you for your amazing video, is there a way I can create an power apps with related galleries and use editable grip in 2nd gallery(referring on your video editable grid in gallery will be connected to task list and task list is related to main list)? If item on main list is selected it will display related tasks in second gallery in editable grid mode.

[@RezaDorrani]

I recorded a video on related grids. Hopefully I will release it soon.

[@prosperkamana7146]

@@RezaDorrani Thank you I hope to watch soon.

[@KokoJambo-xl5rc]

Amazing, do you how to filter a lookup column in gallery or table using a combo box?

[@RezaDorrani]

I have done many videos on gallery filtering. Il recommend checking my playlist on Gallery control.

[@KokoJambo-xl5rc]

​@@RezaDorrani I saw all your videos on gallery filtering, but nothing on galleries with lookup columns / relationship :(

[@RezaDorrani]

@@KokoJambo-xl5rc You need to check again kzbin.info/www/bejne/pp-YYXSBo5iEZ7ssi=GY69q4BdmHoMzz4l

[@stevengutiierrez3538]

Nice video Reza. Does the performance of PowerApps not get overloaded by loading a gallery within another gallery? In advance, thank you

[@RezaDorrani]

Yes it does kzbin.info/www/bejne/lWPNdXqnqdakn5o

[@guilhermesouzagusmao715]

Thanks Reza, nice video !! Its possible with a horizontal gallery ?

[@RezaDorrani]

Should be possible

[@guilhermesouzagusmao715]

@@RezaDorrani help me, please kkkk

[@RezaDorrani]

@@guilhermesouzagusmao715 I am working on new video ideas and have no plans to work on this video. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@guilhermesouzagusmao715]

@@RezaDorrani ok, thanks. I'll take a look 👍

[@charlesdawnbeltran9603]

Amazing and useful video. Is it possible to nest a gallery inside a form? This gallery will list out the child data of the parent data on the form. I have tried it but when i put the gallery inside the datacard/form the child data disappears.

[@RezaDorrani]

I don’t think that is a supported feature

[@kimberlyeramian8212]

Hi, Reza - I've learned so much from watching your videos, thank you! At 5:32 you show the doc library has a column called Invoice Items. When you click the item in the row for ID 196 it immediately goes to your list. I can't figure out how to build the column in the library to do that. What am I missing? Thanks for any guidance you can offer.

[@RezaDorrani]

I have used Column formatting for that. It simply is a link to the list with the filter applied in URL.

[@jonathanfernandezferrer3470]

Hi Reza, one a question how do you add an emoji at minute 7:45. Thank you for your attention and nice tips

[@RezaDorrani]

Windows key + .

[@mariyamhiba3778]

Thanks Reza, i want to know if its possible to display the items in the nested gallery based on the selection of the 1st gallery- ex: in the main gallery i have Line 1 to line 6, if i click onto line 3 then only under that i want to display the items which comes under that line- so the UI will be Line 1 line 2 line 3 line 3 details line 4 ... so on. Please let me know if we can do this

[@RezaDorrani]

kzbin.info/www/bejne/a2ikdaubpMRkac0si=J3T2fqFDaziu7gKt

[@marcelonavarro3586]

Hi Reza, thanks for the video. One issue I have with nested galleries, is how to patch the data from a nested gallery, to a single Dataverse table. Is there a solution for this situation? Thank you!

[@RezaDorrani]

Welcome! I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@marcelonavarro3586]

Thank you! Will do it.

[@vidabailey16]

Thanks so much , so well explained! I am having an issue where I have a form with dataset 1 SP list. I want to pull into the form data from dataset 2 SP list to submit all in the same form. I also want to be able to use a dropdown to select what data I want to pull into the form from dataset 2. Is this possible? I couldn’t find a video on 1 form with 2 datasets that helps me. Lookup kind of works but won’t display the other data fields I need.

[@RezaDorrani]

This is not something I can assist with specially here in comment section. I do not have a video on this specific scenario. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@vidabailey16]

@@RezaDorrani Bummer. You’re the best! Thanks for the reply.

[@RicoFerrari-qi8lt]

Can I create three nested galleries? I’m trying to display a unique topic number with several categories for each topic. It gets tricky because there will be several subcategories for each category. I’ve come up with one solution using three tables: dynamically reading the topic to the page, adding a dropdown list for the categories, and presenting checkboxes to select subcategories. I’d like to try it with the three nested tables. Is that doable?

[@RezaDorrani]

I don't think nesting down to 3 levels is allowed and something I would not recommend due to performance challenges.

[@RicoFerrari-qi8lt]

@@RezaDorrani Thank you very much for taking the time to answer my question.

[@shaikmohammedabdulsamad343]

Nice Tips Reza.. It's very help and you have covered most of the common scenarios related to Gallery Control.

[@RezaDorrani]

Glad it was helpful!

[@SudhirKesharwanispxpertsolutio]

Thanks Reza, I find your videos very interesting and amazing workarounds.

[@RezaDorrani]

Glad you like them!

[@walgdrive-qx9pm]

Nice video. Is it possible to relate an Oracle table to a SharePoint list? Goal is to use a similar approach to what you have here, but use the Oracle view as source of truth, and the SharePoint as an editable form for requesting changes to source data.

[@RezaDorrani]

Should be possible using similar technique as shown in video. I have not done any work with Oracle though.

[@ElReyDrums]

Hi Reza, are there any alternatives to nested galleries? PDF function does not support nested galleries. Thanks

[@RezaDorrani]

I'm not aware of alternatives to nested gallery support for pdf function.

[@TheKermit2110]

great vid, Reza. Quick Q - how did u insert an emoji? thanks

[@RezaDorrani]

Windows+.

[@AlexRathwyn]

Reza, your videos are always the best. I am trying to do a version of this with only 1 table, where the 'parent' gallery is a choice field on that table and the 'child' gallery is all the items where that choice was selected. When I try to get the flexible height on the child gallery so there is no internal scroll as you explain in the last chapter, I am experiencing an issue where when I preview the app I have a LOT of white space at the bottom of each child gallery. Any thoughts?

[@RezaDorrani]

I do not have a video reference on a single table relationship scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@GabrielSDeBortoli]

Please share if you find a solution. I'm stuck on the same problem, getting some 'circular reference' errors. Basically, I have a milestones table with a column "parent_milestone" that can be filled with ID of another record (I'm working on restrictions - like no circular reference - within Power App). And I want to show all the 'parent' milestones (where 'parent_milestone' field is blank) and a sub-gallery with milestones that have the parent one assigned on 'parent_milestone' field. For now, I can have the parents (Filtering by 'ISBLANK') and a side gallery that shows the children WHEN a parent is selected. But I wanted to have that for all records.

[@RezaDorrani]

@@GabrielSDeBortoli I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

[@Nj-hw2cv]

Hi Sir, i have a vertical gallery having list of train Numbers Stored in a collection then inside the vertical gallery i added a horizontal nested gallery my question is how to access the trainno of outer vertical gallery inside the horizontal gallery? selected need not be used because i need to show all at same time like in 12:05

[@RezaDorrani]

I would have to try that out to know how to do it. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@rakshithsubraj2262]

Hi Reza, I am using flexible height gallery inside a vertical gallery. Everything works fine in the edit mode but in the play mode I cannot scroll till the end. But when I turn on Lock aspect ratio it works fine. But app will not look good while turning on the aspect ratio. Can you let me know how to resolve the issue

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@soniawoolf3875]

Thanks for this video Reza! I am building a simple powerapp from Dynamics and I would like to be able to do the same thing using two Dataverse tables. I'm struggling with getting the correct look up in the PowerFx formula. But this is exactly what I need. I'm just not familiar with Dynamics and Dataverse like I am with SharePoint.

[@RezaDorrani]

Check my playlist on Dataverse. Start with this video - kzbin.info/www/bejne/mKq4pnilebadn7c

[@iulianburlacu]

Nice work! Now... Long story short: I need to nest 3 galleries inside eachother. Can it be done?

[@RezaDorrani]

I have not tried that hence not sure. Nested galleries has performance implications. Going 3 levels down is not recommended from a performance standpoint + Im not sure if that is even allowed.

[@iulianburlacu]

@@RezaDorrani Thank you for answering Reza. You are always a big help for us in the community.

[@seatconnect224]

best Power Apps videos!

[@RezaDorrani]

Wow, thanks!

[@daxteoh27]

Hi Reza, when you perform SUM at 11:38, is there a delegation issue?

[@RezaDorrani]

As long as the number of items returned for that specific category is less than delegable limit then no

[@daxteoh27]

​@@RezaDorrani Thanks!

[@sachinsarode_sse]

Hello Sir, I have created a powerapps and added three galleries. Gallery -1 has PDF attachment files and using PDF viewer control to view the PDF. Gallery -2 has KZbin videos and using video tiles to view the video. Gallery -3 has plain text . Now I want to create a search box to search all the gallery simultaneously and once I click on results, it should be redirected to the respective PDF viewer or video viewer screen. Please help to provide the code. Thank you

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@sachinsarode_sse]

@@RezaDorrani thank you sir

[@turbotubbies]

Hi Reza.... It's very helpful can you help to shop how to edit related form from related gallery

[@RezaDorrani]

kzbin.info/www/bejne/iXS8imyQgZlrg9k

[@kazishahebaz4637]

Sir can we connect workplace with powetautomate

[@RezaDorrani]

Not sure as I have not tried this. I recommend posting your query on forums powerusers.microsoft.com

[@breadstick9487]

Hi Reza, I have a question for you. When I try to duplicate an app in Power Apps, it creates a copy of the app in the published app list in the environment instead of the solution. Is there any way to resolve this issue and have the app duplicated in a solution instead? Thank you for your attention!

[@RezaDorrani]

This is not something I have tried hence not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@sherinnedeFanti]

Hi Rza, how do I get my Parent Gallery to exclude headers where the child gallery has no content?

[@RezaDorrani]

For that you would have to use flexible height galleries and write additional logic to check if items exist for that category which would be a performance hit.

[@UD-Blackknight]

Excellent!!

[@RezaDorrani]

Thanks

[@flyingvink2282]

Hi Reza, could you do a dedicated video on PCF many of the devs wants to know it completely,Thanks

[@RezaDorrani]

I need to learn pcf first :)

[@flyingvink2282]

@@RezaDorrani Thanks for the reply😊👍

[@sebmir28]

Hi Reza, in 3:15. how to patch all listed item in Tasks list gallery to a new SP list?. Im trying to create a learning database that can enroll by role base. More power Reza!

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@andalamalasarathbabu2184]

Very useful video sir thank you

[@RezaDorrani]

Welcome

[@paolovr1970]

Thanks Reza always clear 🙏🙏🙏

[@RezaDorrani]

Always welcome

[@muskanali6854]

How can we make flexible gallery height dynamic?

[@RezaDorrani]

The height is automatically dynamic

[@vamsimohan2413]

very useful...

[@RezaDorrani]

Thanks

[@daxteoh27]

can you share a copy for this app? wanna reference the written fx :)

[@RezaDorrani]

This was done a while ago and I no longer have the App.

[@daxteoh27]

no worries!

[@kiruthikanagarajan]

Hi Reza , I want to develop a CallBoard application to display the Dials per day , Totalduration ,connected calls based on the userName for that day . wherein I have to refresh the datas every 10 mins and data has to be updated .and my sharepoint list dont have the data per user . evrything has to be calculated. Help me to get an insight .

[@RezaDorrani]

I do not have a video reference on this and something that I would have to try to provide insights. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@kiruthikanagarajan]

@@RezaDorrani Thankyou, Got some of the work done , Struggling to add Duration coloumn per user , to display Total Duration . Any references for this ? Time, Text, TimeValue, all tried .

[@RezaDorrani]

@@kiruthikanagarajan I do not have any references. Forums will be your best bet.

[@sksachingupta1]

Thanks Reza

[@RezaDorrani]

Welcome

[@alvarolang]

Thanks ! Congratulations for the vídeo and Channel!

[@RezaDorrani]

Many thanks!

[@ky0105]

How to delete the items

[@RezaDorrani]

Remove(datasource, ThisItem) Something on these lines

[@ky0105]

@@RezaDorrani Thanks alot, I am not a programmer, yet l like to see these magical things, curious and try to recreate them. Appreciate the way you present.

[@rikkilleen3169]

Worst tutorial ever. I mean "Little Caesars"? Really? :D Technically, however, this was awesome and inspiring. Great work. Buy better pizza.

[@RezaDorrani]

🤣 Not my data! This was based on sample content fetched from the web long back