Power Apps: Gallery In A Gallery

Подписаться 26 тыс.

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

50% 1

This blog describes how adding a gallery in a gallery enhances your app's user experience. Watch how Daniel Christian builds an app from scratch and shows two scenarios on how the gallery in a gallery can be used.
Here is the link to the App In A Day I mentioned in the video - aka.ms/appinaday
Interested in my blogging gear? Then take a look at them on Amazon:
- Blue Yeti USB Mic for Recording & Streaming on PC and Mac - amzn.to/3d9g7bY
- Microphone Stand, Mic arm Desk Adjustable Suspension Boom with accessories - amzn.to/2N0YNLp
- Neewer 2 Packs Dimmable 5600K USB LED Video Light with Adjustable Tripod - amzn.to/3qteqdf
- Flexible Desk Mount Clamp Gooseneck Stand for Logitech Webcam - amzn.to/2Ozc4eH
- Sunpak tripod - amzn.to/3jJeov2
- Logitech C922x Po Stream Webcam - amzn.to/3aZlqrt

Наука

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

8 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

I really appreciate the videos! Thanks so much for taking the time.

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

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!

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

Thank you for sharing this.

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

My pleasure!

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

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

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

You are most welcome Moriamo.

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

Thank you so much!

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

You're welcome!

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

Thank you Daniel

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

Your welcome, Ami

@Amr-Ibrahim-AI 4 года назад

Thank you so much Daniel. That is exactly what I was looking for

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

Your welcome Amr!

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

Thank you very much. Great as always!!!!

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

Aww thanks for the compliment. Don't forget to subscribe!

@StephanOnisick Год назад

Excellent Presentation! Great Instructor!

@DanielChristian19 Год назад

Thank you kindly!

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

Thank you Daniel, i wasn't aware you could do a Gallery/Gallery, interesting and very informative..

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

Your welcome Randy. Don't forget to Like and Subscribe!

@StephanOnisick 3 месяца назад

Good Explanation of Nesting Galleries. Thank You.

@DanielChristian19 3 месяца назад

You are most welcome

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

This is cool.. Thanks Daniel...

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

Glad you like it!

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

Thank You Dan, you solve my problem..awesome

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

Great to hear!

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

Nice nice nice vidwo. Just what i needed Daniel :)

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

Glad I could help!

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

thank you so much ! you rock ! you gived me the solution for problem i had sine months

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

Glad to hear that Bsikri!

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

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.

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

Never hurts to try. Even if it didn't solve your original problem, you might learn a few new things in the process :-)

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

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 ?

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

Hey Moyura, Email addresses are another great source to use as unique IDs.

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

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 3 года назад

Hey /Go_Reddict, Here is the link - aka.ms/appinaday It's also in the description now.

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

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!!

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

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.

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

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!

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

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.

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

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.

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

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().

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

Daniel do you have videos on the AI builder, very much would like to know how experts like you develop using such features.

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

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. 😀

@plotnet 11 месяцев назад

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.

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

Daniel - do you have video on Flexible Height gallery in a flexible height gallery?

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

Hey Jamie!! Always a pleasure reading comments from you. No I don't but I'll add that to my list. Keep Power Apping!

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

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?

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

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 --> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qU22DiaIPpU.html

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

@@DanielChristian19 thank you for the video 😊

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

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.

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

Mohit, It will be a combination of Patch inside a ForAll.

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

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.

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

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.

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

Thank you, How do we get AllItems from nested gallery?

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

Save them in a collection. You'll need to find some trigger where you can use ClearCollect()

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

@@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

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

Nice What done with Split function.... split my head off too

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

You and me both!. Don't forget to subscribe!

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

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🙏😊

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

Try using patch and in the condition use Selected.Item

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

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

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

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.

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

@@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.

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

Thank you, Daniel. How many child galleries we can add? By the way, good information.

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

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.

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

@@DanielChristian19 Perfect! Thank you Daniel :)

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

Is it possible to put a Gallery into a DataCard?

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

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!