Thank you, Shane! I truly appreciate your videos - they are so easy to follow! I've been trying to figure this out for several hours and you came to the rescue!
Hi Shane, Great video as always. Just wanted to share a secret on another option with a toggle. 1) In the Toggle inside your gallery. Set the below properties as below - default: false - Reset: varResetToggle (I just created a variable as I can't enforce reset outside of the gallery). 2) In the OnVisible property of the screen. Set(varResetToggle, true); Set(varResetToggle, false) - We just need to switch on and off the reset property of the toggle through a variable . 3) In the OnSelect property of 'Expand All' button. Set(varResetToggle, true); Set(varResetToggle, false) - We just need to switch on and off the reset property of the toggle through a variable . The above steps will avoid creating a new column at the backend and using the patch formula. Thanks, Minte
I have no idea how you know what I currently need to know for my apps. So often it happens it comes right in time for me to use the content for the current project. This time the video came when I just had programmed this. Interesting to see that I found exactly the same way to solve it than in this video. Thanks for sharing all those good to follow videos.
Hi Shane, this was good and helped me fix one project, but not exactly what I needed for another one which is a gallery within a gallery and right now it's not working and I followed your instructions as best as I could to substitute gallery for the list
I don't know, I didn't think about that scenario. Hopefully you can come up with something If(IsEmpty(YourField), [ "No Items"],YourField) Something in that ballpark?
You could also use a variable as an alternative to the expand/collapse all. That’s how I did it. I liked the option of the toggle/checkbox for individual expand / collapse. Will use it. In my experience, when you use a child gallery to expand the height of the parent galley, you’ll see an strange behavior (delay to expand). This is caused to the time it takes for PowerApps to process the data and calculate the number of lines in your child gallery. The workaround I found was to create a transparent label with some data that will “mimic” the height of the child gallery. This label will process much faster and expand the parent gallery while PowerApps is still processing yogur child gallery. It’s not a big deal but improves the user’s experience.
Another great video. Keep them coming! You're very much appreciated. I have a question though, my flexible height gallery template looks fine in preview mode, but the published app the templates overlap. It appears that the height isn't being calculated correctly. Not sure what to do.
A really good tutorial. But if I use the flexible Height Gallery, i cannot use the datepicker. It won't change its value if i select a date. Do you have an idea or workaround?
@@ShanesCows It's really strange. I've tried everything. Could it be related to the fact that I'm using Dataverse for Teams as a data source? Whether it's modern controls or classic controls, it immediately takes the value of the data source again. In a normal gallery, everything works fine. Thank you anyway.
Wow I have been grinding one of these out. Hopefully that tip re the property in the DataSource instead of using variables is the solution to my current troubles. Have double / nested flexible height galleries, where the items in each expand on select. Struggled with this in V0 of the app. Now rebuilding a clean version and have been stuck on this for hours 😂
Hi @ShaneYoung- It works perfectly fine in case of zoom size is 100% but when i decreased my zoom size OR user screen resolution is larger then nested gallery is overlapping. any suggestion?
Hi Shane! really like your video! May i ask how can i fix a hidden column taking up space in powerapp? As it doesn't look neat at all and i've been struggling with this!
I'm facing a problem with the flexible height gallery. There is a unnecessary gap between templates in my, which is not going away and also gallery is not showing all the data, few of it remains hidden at the bottom. Is there a way it can be corrected?
Try looking at Padding, you should be able to get those gaps pretty tight but at the end of the day you can only do so much. As for hidden at the bottom. I haven't had any problems with that so not sure what is happening. Try setting template fill color to something bright and different. See if you can see what is or isn't happening, might help you troubleshoot.
Hi , I have created a people search directory using PowerApps and wants to redirect users to their Delve Profile after clicking on selected items?? Can you suggest?
@@ShanesCows Thanks for the reply. I am able to get the selected current item properties(Email, ID) and am able to launch to Delve search page. But for profile page it dynamically generate some keys, that I'm not sure how to get for everyone .
Hi Shane, another greate video! I want to ask, is possible to make something similar with width? I need something like vertical gallery with flexible width. Or gallery with flexible temple size? Thanks.
I think your videos are just awesome and very easy to follow... Unfortunately, I can't get along this time. I need a dynamic gallery row and fail at the height of the line! The elements are dynamic (as far as this feature exists) but the height is not dynamically adjusted... is there currently (1 year after this video) an bug? I also can't add controls like sub-galleries, they always end up in the root of the screen
Hi Shane, Can you do a video or answer the question how can you scroll to a certain point in a vertical gallery. I can use the Default to select an item in the gallery, but if it's say #30 in a list of 50 items it will select it, but it does not show it. Thus the user has to scroll to find the item in the gallery that is highlighted. Filter will not solve this because I want the user to see all the records. So I need a way to cause the gallery to be position so #30 is in view. I want all the items to stay in the same order as well. This has not been solved by anyone that I can find, but I would like scrolling to a particular position in a gallery would be useful, which is why I shocked this hasn't been solved (at least that I can find). I've spent hours on this. Hope you can help. Thanks!
There isn't a way the best I know. :( I show how I use a variable instead of gallery. selected in this video th-cam.com/video/691pRyRHWBU/w-d-xo.html but that isn't going to cause it to scroll like you want. :(
I rewatched the video. If you do a Reset(RequestGallery), it will bring the item into view(not at the top, which would be perfect), but nevertheless you see it highlighted. Of course, it can't be that easy. On the click of a button, I do multiple patches, etc. before the appropriate items are reloaded into the gallery. After all that is done, the very last statement I do a Reset(RequestGallery). This does not work. I assume because the RequestGallery really isn't populated until after everything in that button click event completes. I only know this because I put a button on the screen (Shane best practice) and put the same command "Reset(RequestGallery)" in it. After the Gallery displays the "Items" based on new criteria, I click on this button and "Voila!", it move to the record. I'm sure this is a timing issue, so my only solution unless someone thinks of something else is a button with the caption "move to selected record" so at least the user doesn't have to scroll. Sorry for the lengthy post, but though you and/or your many followers might be interested in this... maybe 🙂
Hi Shane.In my development environment I have installed about 4 different portals. Inside those portals I created scripts that make use of Liquid and Fetch XML to retrieve records from dataverse tables that are inside solutions ( each Portal has it’s own solution ). Those scripts were working properly. About 2 days ago, I migrated those portals to a new environment (production), to do that, I first moved the solution, then the data, then I migrated the Portal using the NuGet, data migration tool. When I did that, all those Portals config and dataverse solution schema and data where migrated with success. Then, I created a new Portal in the prod environment selecting data source as one of those migrated Portals to the prod environment. All was going well, but then, while I was adjusting a Fetch XML script on a Portal inside the production environment, the script stopped working properly and the Portal crashed, and I lost access to it. I was able to restart the Portal and recover access to it. The problem is that, from then on, all available scripts that make use of Fetch XML inside the portals ( inside the development environment as well ) stop work properly as soon as I sync a page that has a script of fetch XML inside. I don’t know what is causing this. Portals installed in different environments shouldn’t share any data/config Any one is facing an issue like this or knows any solution, please let me know.
thank u so so much for the HTML suggestion slipped in there! my need: ENG dept fills out a varying length "Description" column & my boss wants this field to be viewed in a spreadsheet style list gallery my boss suggested the flex height galleries ... but i didnt think there was an option for a flex height text box which! if there is such a control for a text label, please lemme know so i can save the trouble of HTML haha
Why can't I add a lookup field (not valid)? I wanted also a responsive app so I placed a flex gallery in a flex container but the flex container has a alignincontainer and i don't know what to put in it????
I've used the flexible height gallery to try to design a chat log, but unfortunately it's not flexible at all. I simply sets all items to the same height which is the high of the biggest item in the gallery.
How to add currency format to textbox control inside the editable grid. I have a requirement of showing the existing data in US currency format and change the format of new row added to the grid or exit the existing row to the same currency format. data source is SharePoint. Could you please help. Thanks in advance.
@@ShanesCows I'm asking because I cannot nest a third gallery in an already nested gallery. I tried everything and I just couldnt figure out how to do a 3 lvl collapsing accordion menu in powerapps. It is a requirement I have from a client and something I think im gonna be stuck with for a while.
@@ShanesCows , run the browser dev tools (F12) on a screen with a flex (accordion) gallery and see if you observe constant / continuous errors in the console. The screen caused CPU utilization to jump to >30% also. It was literally the sound of the desktop fans when entering that screen that lead me to finding the buggy control. I ended up switching to a standard gallery made to be dynamic based on combo box selections to show / hide content within the gallery.
This is a really bad tutorial. So much time waffling on with colours and other irrelevant properties when you could cut this down to less than 10 minutes and just clearly explain how to do a nested gallery.
I am sorry you didn't like it. Most people enjoy the added info and context. If I make a video that just shows the flexible height gallery then people would complain that I didn't explain why you need it or didn't show exactly the info they wanted. Cannot make everyone happy. Hope you have a great day.
Thank you, Shane! I truly appreciate your videos - they are so easy to follow! I've been trying to figure this out for several hours and you came to the rescue!
You are so welcome!
Hi Shane,
Great video as always. Just wanted to share a secret on another option with a toggle.
1) In the Toggle inside your gallery. Set the below properties as below
- default: false
- Reset: varResetToggle (I just created a variable as I can't enforce reset outside of the gallery).
2) In the OnVisible property of the screen.
Set(varResetToggle, true); Set(varResetToggle, false) - We just need to switch on and off the reset property of the toggle through a variable .
3) In the OnSelect property of 'Expand All' button.
Set(varResetToggle, true); Set(varResetToggle, false) - We just need to switch on and off the reset property of the toggle through a variable .
The above steps will avoid creating a new column at the backend and using the patch formula.
Thanks,
Minte
That is a cool Idea Minte. :)
Love that colloquial mispronunciation of the word "height" as you say "heighth" such as the word "width".
I mispronounce so many words it isn’t funny. 😁 I didn’t know this was one of them. I will add it to the list. Poem is the worst. 😂
Thank you for your videos but the title of the video says Flexible Height Container, but no mention of a container.
Weird, I don't know why the word container was in there. Sorry about that. Can you give me an idea what you are looking for and I can try to help.
How did you know that I was trying to get this to work LAST WEEK? Thanks for posting great content as usual!
I am always watching. 😂
you've just made my life alot easier
Awesome!!!
I have no idea how you know what I currently need to know for my apps. So often it happens it comes right in time for me to use the content for the current project.
This time the video came when I just had programmed this. Interesting to see that I found exactly the same way to solve it than in this video.
Thanks for sharing all those good to follow videos.
Andreas I have Chewy secretly spying one you. 🐶😂
Excellent Video.. MAny Thanks Shane. Cheers !
Glad to help. 😀
Thank you very much for this!!!
You bet!
Thanks for sir... Most helpful your videos very nice explain all videos ... Thanks so much sir.. From Tamilnadu..
Thanks and welcome. I hope you have a great day. 🐶
Hi Shane, this was good and helped me fix one project, but not exactly what I needed for another one which is a gallery within a gallery and right now it's not working and I followed your instructions as best as I could to substitute gallery for the list
Thanks for the vid. How do we achieve same if the above field is empty?
I don't know, I didn't think about that scenario. Hopefully you can come up with something If(IsEmpty(YourField), [ "No Items"],YourField) Something in that ballpark?
You could also use a variable as an alternative to the expand/collapse all. That’s how I did it.
I liked the option of the toggle/checkbox for individual expand / collapse. Will use it.
In my experience, when you use a child gallery to expand the height of the parent galley, you’ll see an strange behavior (delay to expand). This is caused to the time it takes for PowerApps to process the data and calculate the number of lines in your child gallery.
The workaround I found was to create a transparent label with some data that will “mimic” the height of the child gallery. This label will process much faster and expand the parent gallery while PowerApps is still processing yogur child gallery.
It’s not a big deal but improves the user’s experience.
Awesome. Thanks for Sharing.
Thanks for this awesome content. It came in handy
Glad to hear it!
Another great video. Keep them coming! You're very much appreciated.
I have a question though, my flexible height gallery template looks fine in preview mode, but the published app the templates overlap. It appears that the height isn't being calculated correctly. Not sure what to do.
A really good tutorial. But if I use the flexible Height Gallery, i cannot use the datepicker. It won't change its value if i select a date. Do you have an idea or workaround?
Weird, I just tested and I can change the date inside of a date picker when it is inside of a gallery. 🫤
@@ShanesCows It's really strange. I've tried everything. Could it be related to the fact that I'm using Dataverse for Teams as a data source? Whether it's modern controls or classic controls, it immediately takes the value of the data source again. In a normal gallery, everything works fine. Thank you anyway.
Wow I have been grinding one of these out. Hopefully that tip re the property in the DataSource instead of using variables is the solution to my current troubles. Have double / nested flexible height galleries, where the items in each expand on select.
Struggled with this in V0 of the app. Now rebuilding a clean version and have been stuck on this for hours 😂
Nested gets nasty quickly! Good luck 🍀
@ShanesCows You sir are amazing! Got this to work with columns in the DataSource with Patch and UpdateIf logic respectively. Beyond stoked
Hi @ShaneYoung- It works perfectly fine in case of zoom size is 100% but when i decreased my zoom size OR user screen resolution is larger then nested gallery is overlapping. any suggestion?
I haven't ran into issues with zoom causing it not to work so I am not sure. SOrry
@panand99. In the App Settings, under Display, change the setting for Aspect Ratio. That solved the overlapping problem I was seeing.
Hi Shane! really like your video! May i ask how can i fix a hidden column taking up space in powerapp? As it doesn't look neat at all and i've been struggling with this!
If Visible is set to false it shouldn't be taking up space.
@@ShanesCows it sure does set to fault but it seem to be not going by order.
I'm facing a problem with the flexible height gallery. There is a unnecessary gap between templates in my, which is not going away and also gallery is not showing all the data, few of it remains hidden at the bottom. Is there a way it can be corrected?
Try looking at Padding, you should be able to get those gaps pretty tight but at the end of the day you can only do so much. As for hidden at the bottom. I haven't had any problems with that so not sure what is happening. Try setting template fill color to something bright and different. See if you can see what is or isn't happening, might help you troubleshoot.
Who is Marc? Does he has a TH-cam-Channel, too? Very interesting topic. I have many ideas how to use this. Thank you very much.
❤
He doesn't but I sent him a link to this so you would see. 😍
Awesome as always
Thank you so much 😀
Hi Shane, could this be used to create a vertical navigation menu with sub menu?
I don’t see why not. Make a collection that is structured like you want. Then display it in the gallery inside of navigation. I think so. 😎
@@ShanesCows some great news, took some time to nut it out but I got the job done and on top I only used 1 collection for both galleries
Hi , I have created a people search directory using PowerApps and wants to redirect users to their Delve Profile after clicking on selected items??
Can you suggest?
You would need a way to get the URL to their delve profile. Then you could use the Launch function to open the URL.
@@ShanesCows Thanks for the reply. I am able to get the selected current item properties(Email, ID) and am able to launch to Delve search page. But for profile page it dynamically generate some keys, that I'm not sure how to get for everyone .
Hi Shane, another greate video!
I want to ask, is possible to make something similar with width? I need something like vertical gallery with flexible width. Or gallery with flexible temple size? Thanks.
I think your videos are just awesome and very easy to follow... Unfortunately, I can't get along this time. I need a dynamic gallery row and fail at the height of the line! The elements are dynamic (as far as this feature exists) but the height is not dynamically adjusted... is there currently (1 year after this video) an bug? I also can't add controls like sub-galleries, they always end up in the root of the screen
Hi Shane, Can you do a video or answer the question how can you scroll to a certain point in a vertical gallery. I can use the Default to select an item in the gallery, but if it's say #30 in a list of 50 items it will select it, but it does not show it. Thus the user has to scroll to find the item in the gallery that is highlighted. Filter will not solve this because I want the user to see all the records. So I need a way to cause the gallery to be position so #30 is in view. I want all the items to stay in the same order as well. This has not been solved by anyone that I can find, but I would like scrolling to a particular position in a gallery would be useful, which is why I shocked this hasn't been solved (at least that I can find). I've spent hours on this. Hope you can help. Thanks!
There isn't a way the best I know. :( I show how I use a variable instead of gallery. selected in this video th-cam.com/video/691pRyRHWBU/w-d-xo.html but that isn't going to cause it to scroll like you want. :(
@@ShanesCows Thanks for the quick reply! I saw some folks have posted that they want MS to add some type of scroll position property (HA HA!) 🙂
I rewatched the video. If you do a Reset(RequestGallery), it will bring the item into view(not at the top, which would be perfect), but nevertheless you see it highlighted.
Of course, it can't be that easy. On the click of a button, I do multiple patches, etc. before the appropriate items are reloaded into the gallery. After all that is done, the very last statement I do a Reset(RequestGallery). This does not work. I assume because the RequestGallery really isn't populated until after everything in that button click event completes.
I only know this because I put a button on the screen (Shane best practice) and put the same command "Reset(RequestGallery)" in it. After the Gallery displays the "Items" based on new criteria, I click on this button and "Voila!", it move to the record. I'm sure this is a timing issue, so my only solution unless someone thinks of something else is a button with the caption "move to selected record" so at least the user doesn't have to scroll.
Sorry for the lengthy post, but though you and/or your many followers might be interested in this... maybe 🙂
If you don't have a nested gallery, how can you do expand/collapse all without patch? Thanks
How to make the Parent Gallery to grow or collapse accordingly to avoid a scroll bar? If needed there is a scroll bar on a canvas.
Make the gallery height. Tied to CountRows * Self.TemplateHeight
@@ShanesCows Self.TemplateHeight is the default and not the actual
Thanks Shane
Happy to help
Thanks for sharing man
No problem 👍
Hi Shane.In my development environment I have installed about 4 different portals. Inside those portals I created scripts that make use of Liquid and Fetch XML to retrieve records from dataverse tables that are inside solutions ( each Portal has it’s own solution ). Those scripts were working properly. About 2 days ago, I migrated those portals to a new environment (production), to do that, I first moved the solution, then the data, then I migrated the Portal using the NuGet, data migration tool. When I did that, all those Portals config and dataverse solution schema and data where migrated with success. Then, I created a new Portal in the prod environment selecting data source as one of those migrated Portals to the prod environment. All was going well, but then, while I was adjusting a Fetch XML script on a Portal inside the production environment, the script stopped working properly and the Portal crashed, and I lost access to it. I was able to restart the Portal and recover access to it. The problem is that, from then on, all available scripts that make use of Fetch XML inside the portals ( inside the development environment as well ) stop work properly as soon as I sync a page that has a script of fetch XML inside. I don’t know what is causing this. Portals installed in different environments shouldn’t share any data/config Any one is facing an issue like this or knows any solution, please let me know.
thank u so so much for the HTML suggestion slipped in there!
my need:
ENG dept fills out a varying length "Description" column & my boss wants this field to be viewed in a spreadsheet style list gallery
my boss suggested the flex height galleries ... but i didnt think there was an option for a flex height text box
which!
if there is such a control for a text label, please lemme know so i can save the trouble of HTML haha
how can i use this to hide a ligne from gallery when i click on hide icone also with a condition of other column (empty or not)
Why can't I add a lookup field (not valid)?
I wanted also a responsive app so I placed a flex gallery in a flex container but the flex container has a alignincontainer and i don't know what to put in it????
I've used the flexible height gallery to try to design a chat log, but unfortunately it's not flexible at all. I simply sets all items to the same height which is the high of the biggest item in the gallery.
How to add currency format to textbox control inside the editable grid. I have a requirement of showing the existing data in US currency format and change the format of new row added to the grid or exit the existing row to the same currency format. data source is SharePoint. Could you please help. Thanks in advance.
Nice work. Now... can we add a third level? Like 3 tables (Parent - Child - Grandchild)?
I have never tried nested, nested tables but I don't see why not.
@@ShanesCows I'm asking because I cannot nest a third gallery in an already nested gallery. I tried everything and I just couldnt figure out how to do a 3 lvl collapsing accordion menu in powerapps. It is a requirement I have from a client and something I think im gonna be stuck with for a while.
The flexible gallery is a horribly inefficent object. It crippled an app and had to be removed and replaced with an alternative approach.
Interesting Jeff. We have used it in some larger scenarios and it worked fine. Sorry it isn't being good for you.
@@ShanesCows , run the browser dev tools (F12) on a screen with a flex (accordion) gallery and see if you observe constant / continuous errors in the console. The screen caused CPU utilization to jump to >30% also. It was literally the sound of the desktop fans when entering that screen that lead me to finding the buggy control.
I ended up switching to a standard gallery made to be dynamic based on combo box selections to show / hide content within the gallery.
Interesting. A quick peek I do see some errors but not the CPU spike. Hmmm.
p̷r̷o̷m̷o̷s̷m̷ 💐
This is a really bad tutorial. So much time waffling on with colours and other irrelevant properties when you could cut this down to less than 10 minutes and just clearly explain how to do a nested gallery.
I am sorry you didn't like it. Most people enjoy the added info and context. If I make a video that just shows the flexible height gallery then people would complain that I didn't explain why you need it or didn't show exactly the info they wanted. Cannot make everyone happy. Hope you have a great day.