Thanks Daniel. I had to give a second logical test and the scroll on the Child-Gallery did not vanish, but I got the result I wanted. I've been struggling for a while now and I can't thank you enough for this video. God bless you
How would you add the components of the nested gallery. Let's say if there are multiple line items in the sub gallery and you want to add all the prices of the components in that nested gallery.
Very cool Daniel, I did a cenario where use two galleries, I need write in Sharepoint list. How I can make the forall formula? To each list item have a colunm that salve the child gallery content.
Thanks for sharing, what would you do, if there is no name or ID relationship between the tables, for example calendar table and purchase order table ?
Great video Daniel. I'm starting to work with PowerApps. But I'm starting from the beginning. Can you please share your data sources, the excel files, for referencing?
@@DanielChristian19 Got you, Is there any way around to get NestedGallery.AllItems without trigger in inside gallery? I have parent gallery which has questions section and child gallery has questions. So, I want to get all items from child gallery without trigger
Hey Daniel, I’ve never used nested galleries and it looks quite interesting. Question for you, currently I do use some lookup fields in a gallery, so I can pull values from a related table which will give me some of the same results you have shown. My question is, is it more efficient or decrease the workload (making it faster) to use the nested galleries instead of lookup fields❓ Thanks again for the video and the work you do!!
Hey J, Thanks for the compliment. Depends on how much data you are pulling and the source. If I have the option to choose, then I'd go with the gallery instead of lookup fields. Gallery gives me more flexibility and design option.
Thanks for the video, I am using Azure SQL db, where I have customer info and item details to be edited in one screen and once changes are made need to update the changes in different DB. How to do that?
Hi Ashwini, This is definitely doable. You can update multiple SQL db tables either sequentially or simultaneously. It sounds as if you will need to maintain relationships between the two tables so keep that in mind. Here's a new series of videos I have just started, it is referencing a SharePoint list but the idea works for SQL as well. Take a look --> th-cam.com/video/qU22DiaIPpU/w-d-xo.html
You are welcome Epic. You can add multiple second level child galleries. Currently copy and paste does not work in the child gallery. They are aware of this and are going to fix it.
Hi Daniel, I know that 3 level nested gallery not possible in powersapps, is there any other way to achieve this functionality. My requirement I have 3 level nested galleries.
Hey Rajesh, My workaround has been using a third gallery that filters based on the secondary gallery that is nested. You can also NOT nest the gallery and keep them separate and filtered. This gives you the flexibility to use as many tier levels as you wish.
Thank you Daniel, I also never thought about gallery in gallery. I always use excel query to combine more than two excel files/sheets and relate them together, but powerapps to connect to onedrive excel limit file size couldn't exceed 2M that a big issue for me. After watching this video, maybe I can try to use gallery in gallery to overcome my problem.
Is it possible to put one button whithin gallery to add some info. Like Button for Time in .when you click the button It will add automatic the datetimestamp with status in progress in your datasource.i did it using patch but it makes new row.please help🙏😊
Thank you Daniel! Is there a way to filter the main gallery from items in the sub-gallery? I have customers (main data) with different items (child data). Would like to only see customers with specific item. In your example, search and display requests with a mouse in the accessories.
Hey Greg, I can't think of a way to do that because the parent/main gallery is the one that dictates the internal/child gallery. What you can do is add the galleries one below the other or side-by-side and do it that way. Also, whatever is selected, save it to a variable using Set().
Hi Daniel, Great video! But what if the relationship to the head gallery (say Gallery1) with the nested gallery (Gallery2) is 1 to many? So for example in Gallery1 you have the salesperson and in Gallery2 you want to show all the products he has sold? And it is also possible to make a search or dropdown to filter Gallery1 on the input of Gallery2? So that you search on/select a specific product and than all the salespersons will return? Thank you in advance for your reply!
Hi Jenske, You can do all that using a combination of collections and the correct functions. So every time an item is selected in Gallery1, do a ClearCollect and save it to a ColTemp and display that in Gallery 2. Depending on which data source you use, Search should work. For SharePoint you have to use Filter.
Hello @Daniel Thank you very much for your video. I am trying that in another scene I can see a form of the sub gallery. How do you see the forms of both galleries on another screen? View mode forms. I have the following Galleries: 1.- BrowseGallery1_1 1.1 - Gallery1 Note: I can see the form of the parent Gallery (BrowseGallery1_1), but I cannot see the form of the child gallery (Gallery1), in the Items property I am indicating: Gallery1.Selected but it does not work, error. Could it be because it is a sub gallery? Regards
Hey Robinson, Thanks for the compliment. Try this, save the selected item to a variable. The formula will look like this Set(TempSelected, Gallery1.Selected.Item). Then reference that variable in the other screen.
@@DanielChristian19 Fantastic, I did it and it worked for me, only I have to do two clicks so they can bring the information to the form. That is, in the sub gallery I must click on it and then on the button that takes me to the form. Otherwise, the information does not reflect me.
Hi Shi, Yes it is but not directly. You first add a gallery anywhere in that screen, then do a copy and paste into the data card. I have reported this issue to the Microsoft Product Group. Keep Power Apping and don't forget to like my videos and subscribe to my channel!
Excellent Presentation! Great Instructor!
Thank you kindly!
Thanks Daniel. I had to give a second logical test and the scroll on the Child-Gallery did not vanish, but I got the result I wanted. I've been struggling for a while now and I can't thank you enough for this video. God bless you
You are most welcome Moriamo.
How would you add the components of the nested gallery. Let's say if there are multiple line items in the sub gallery and you want to add all the prices of the components in that nested gallery.
Mohit,
It will be a combination of Patch inside a ForAll.
Thank you Daniel, i wasn't aware you could do a Gallery/Gallery, interesting and very informative..
Your welcome Randy. Don't forget to Like and Subscribe!
Very cool Daniel, I did a cenario where use two galleries, I need write in Sharepoint list. How I can make the forall formula? To each list item have a colunm that salve the child gallery content.
Thank you so much Daniel. That is exactly what I was looking for
Your welcome Amr!
Thanks for sharing, what would you do, if there is no name or ID relationship between the tables, for example calendar table and purchase order table ?
Hey Moyura,
Email addresses are another great source to use as unique IDs.
Great video Daniel. I'm starting to work with PowerApps. But I'm starting from the beginning. Can you please share your data sources, the excel files, for referencing?
Hey /Go_Reddict,
Here is the link - aka.ms/appinaday It's also in the description now.
Thank you, How do we get AllItems from nested gallery?
Save them in a collection. You'll need to find some trigger where you can use ClearCollect()
@@DanielChristian19 Got you, Is there any way around to get NestedGallery.AllItems without trigger in inside gallery?
I have parent gallery which has questions section and child gallery has questions. So, I want to get all items from child gallery without trigger
Daniel do you have videos on the AI builder, very much would like to know how experts like you develop using such features.
Hi Chand72,
I haven't recorded any videos on those, however, now that you mentioned it I'll add it to my to-record list. 😀
Good Explanation of Nesting Galleries. Thank You.
You are most welcome
Daniel - do you have video on Flexible Height gallery in a flexible height gallery?
Hey Jamie!!
Always a pleasure reading comments from you.
No I don't but I'll add that to my list. Keep Power Apping!
This is cool.. Thanks Daniel...
Glad you like it!
Hey Daniel, I’ve never used nested galleries and it looks quite interesting. Question for you, currently I do use some lookup fields in a gallery, so I can pull values from a related table which will give me some of the same results you have shown. My question is, is it more efficient or decrease the workload (making it faster) to use the nested galleries instead of lookup fields❓
Thanks again for the video and the work you do!!
Hey J,
Thanks for the compliment.
Depends on how much data you are pulling and the source. If I have the option to choose, then I'd go with the gallery instead of lookup fields. Gallery gives me more flexibility and design option.
Thanks for the video, I am using Azure SQL db, where I have customer info and item details to be edited in one screen and once changes are made need to update the changes in different DB. How to do that?
Hi Ashwini,
This is definitely doable. You can update multiple SQL db tables either sequentially or simultaneously. It sounds as if you will need to maintain relationships between the two tables so keep that in mind. Here's a new series of videos I have just started, it is referencing a SharePoint list but the idea works for SQL as well. Take a look --> th-cam.com/video/qU22DiaIPpU/w-d-xo.html
@@DanielChristian19 thank you for the video 😊
Thank you Daniel
Your welcome, Ami
Thank you, Daniel. How many child galleries we can add? By the way, good information.
You are welcome Epic. You can add multiple second level child galleries. Currently copy and paste does not work in the child gallery. They are aware of this and are going to fix it.
@@DanielChristian19 Perfect! Thank you Daniel :)
Thank you for sharing this.
My pleasure!
Thank You Dan, you solve my problem..awesome
Great to hear!
Thank you so much!
You're welcome!
Hi Daniel,
I know that 3 level nested gallery not possible in powersapps, is there any other way to achieve this functionality. My requirement I have 3 level nested galleries.
Hey Rajesh,
My workaround has been using a third gallery that filters based on the secondary gallery that is nested. You can also NOT nest the gallery and keep them separate and filtered. This gives you the flexibility to use as many tier levels as you wish.
Thank you Daniel, I also never thought about gallery in gallery. I always use excel query to combine more than two excel files/sheets and relate them together, but powerapps to connect to onedrive excel limit file size couldn't exceed 2M that a big issue for me. After watching this video, maybe I can try to use gallery in gallery to overcome my problem.
Never hurts to try. Even if it didn't solve your original problem, you might learn a few new things in the process :-)
I really appreciate the videos! Thanks so much for taking the time.
Glad you like them and you are most welcome. It's positive feedback like this that gives me the motivation. Don't forget to subscribe!
Nice nice nice vidwo. Just what i needed Daniel :)
Glad I could help!
Is it possible to put one button whithin gallery to add some info. Like Button for Time in .when you click the button It will add automatic the datetimestamp with status in progress in your datasource.i did it using patch but it makes new row.please help🙏😊
Try using patch and in the condition use Selected.Item
Thank you very much. Great as always!!!!
Aww thanks for the compliment. Don't forget to subscribe!
Thank you Daniel! Is there a way to filter the main gallery from items in the sub-gallery? I have customers (main data) with different items (child data). Would like to only see customers with specific item. In your example, search and display requests with a mouse in the accessories.
Hey Greg,
I can't think of a way to do that because the parent/main gallery is the one that dictates the internal/child gallery. What you can do is add the galleries one below the other or side-by-side and do it that way. Also, whatever is selected, save it to a variable using Set().
Hi Daniel,
Great video! But what if the relationship to the head gallery (say Gallery1) with the nested gallery (Gallery2) is 1 to many? So for example in Gallery1 you have the salesperson and in Gallery2 you want to show all the products he has sold?
And it is also possible to make a search or dropdown to filter Gallery1 on the input of Gallery2? So that you search on/select a specific product and than all the salespersons will return?
Thank you in advance for your reply!
Hi Jenske,
You can do all that using a combination of collections and the correct functions. So every time an item is selected in Gallery1, do a ClearCollect and save it to a ColTemp and display that in Gallery 2.
Depending on which data source you use, Search should work. For SharePoint you have to use Filter.
Hello @Daniel
Thank you very much for your video.
I am trying that in another scene I can see a form of the sub gallery.
How do you see the forms of both galleries on another screen? View mode forms.
I have the following Galleries:
1.- BrowseGallery1_1
1.1 - Gallery1
Note: I can see the form of the parent Gallery (BrowseGallery1_1), but I cannot see the form of the child gallery (Gallery1), in the Items property I am indicating: Gallery1.Selected but it does not work, error.
Could it be because it is a sub gallery?
Regards
Hey Robinson,
Thanks for the compliment. Try this, save the selected item to a variable. The formula will look like this Set(TempSelected, Gallery1.Selected.Item). Then reference that variable in the other screen.
@@DanielChristian19
Fantastic,
I did it and it worked for me, only I have to do two clicks so they can bring the information to the form.
That is, in the sub gallery I must click on it and then on the button that takes me to the form. Otherwise, the information does not reflect me.
thank you so much ! you rock ! you gived me the solution for problem i had sine months
Glad to hear that Bsikri!
Is it possible to put a Gallery into a DataCard?
Hi Shi,
Yes it is but not directly. You first add a gallery anywhere in that screen, then do a copy and paste into the data card. I have reported this issue to the Microsoft Product Group.
Keep Power Apping and don't forget to like my videos and subscribe to my channel!
Nice
What done with Split function.... split my head off too
You and me both!. Don't forget to subscribe!