Power Apps: Gallery In A Gallery

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น • 67

  • @StephanOnisick
    @StephanOnisick 2 ปีที่แล้ว +1

    Excellent Presentation! Great Instructor!

  • @moriamoraimi2232
    @moriamoraimi2232 3 ปีที่แล้ว +1

    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

  • @itsmemohit
    @itsmemohit 3 ปีที่แล้ว +1

    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
      @DanielChristian19  3 ปีที่แล้ว

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

  • @Randyr1963
    @Randyr1963 4 ปีที่แล้ว +3

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

    • @DanielChristian19
      @DanielChristian19  4 ปีที่แล้ว

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

  • @plotnet
    @plotnet ปีที่แล้ว

    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.

  • @Amr-Ibrahim-AI
    @Amr-Ibrahim-AI 4 ปีที่แล้ว +2

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

  • @moyura2
    @moyura2 3 ปีที่แล้ว +1

    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
      @DanielChristian19  3 ปีที่แล้ว

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

  • @gregcalvert4645
    @gregcalvert4645 4 ปีที่แล้ว +1

    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
      @DanielChristian19  4 ปีที่แล้ว +1

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

  • @krishnamurthyelumalai3751
    @krishnamurthyelumalai3751 2 ปีที่แล้ว +1

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

    • @DanielChristian19
      @DanielChristian19  2 ปีที่แล้ว +1

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

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

  • @Deadpool12353
    @Deadpool12353 4 ปีที่แล้ว +1

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

    • @DanielChristian19
      @DanielChristian19  4 ปีที่แล้ว +1

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

  • @StephanOnisick
    @StephanOnisick 9 หลายเดือนก่อน +1

    Good Explanation of Nesting Galleries. Thank You.

  • @JamieWillisRose
    @JamieWillisRose 4 ปีที่แล้ว +1

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

    • @DanielChristian19
      @DanielChristian19  4 ปีที่แล้ว +1

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

  • @chrupes
    @chrupes 4 ปีที่แล้ว +1

    This is cool.. Thanks Daniel...

  • @jray1429
    @jray1429 3 ปีที่แล้ว +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
      @DanielChristian19  3 ปีที่แล้ว +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.

  • @ashwinidas7142
    @ashwinidas7142 4 ปีที่แล้ว +1

    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
      @DanielChristian19  4 ปีที่แล้ว +1

      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

    • @ashwinidas7142
      @ashwinidas7142 4 ปีที่แล้ว

      @@DanielChristian19 thank you for the video 😊

  • @ImranAmiKh4n
    @ImranAmiKh4n 3 ปีที่แล้ว

    Thank you Daniel

  • @MoTheSeeker
    @MoTheSeeker 4 ปีที่แล้ว +1

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

    • @DanielChristian19
      @DanielChristian19  4 ปีที่แล้ว

      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
      @MoTheSeeker 4 ปีที่แล้ว

      @@DanielChristian19 Perfect! Thank you Daniel :)

  • @danishislam692
    @danishislam692 4 ปีที่แล้ว +1

    Thank you for sharing this.

  • @ramlia72
    @ramlia72 2 ปีที่แล้ว +1

    Thank You Dan, you solve my problem..awesome

  • @brendaguzman7539
    @brendaguzman7539 2 ปีที่แล้ว +1

    Thank you so much!

  • @rajeshy9363
    @rajeshy9363 4 ปีที่แล้ว +1

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

  • @ShihChiWang
    @ShihChiWang 4 ปีที่แล้ว +1

    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
      @DanielChristian19  4 ปีที่แล้ว +1

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

  • @ericmild4050
    @ericmild4050 4 ปีที่แล้ว +1

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

    • @DanielChristian19
      @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!

  • @franknielsen3219
    @franknielsen3219 4 ปีที่แล้ว

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

  • @jjayceeb
    @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
      @DanielChristian19  3 ปีที่แล้ว

      Try using patch and in the condition use Selected.Item

  • @sokgat7019
    @sokgat7019 4 ปีที่แล้ว +1

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

    • @DanielChristian19
      @DanielChristian19  4 ปีที่แล้ว

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

  • @gregmurnock7032
    @gregmurnock7032 4 ปีที่แล้ว

    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
      @DanielChristian19  3 ปีที่แล้ว +1

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

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

  • @habemusmusica
    @habemusmusica 4 ปีที่แล้ว

    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
      @DanielChristian19  4 ปีที่แล้ว +1

      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
      @habemusmusica 4 ปีที่แล้ว

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

  • @bsikrimohamed168
    @bsikrimohamed168 4 ปีที่แล้ว +1

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

  • @shiyong6444
    @shiyong6444 4 ปีที่แล้ว +1

    Is it possible to put a Gallery into a DataCard?

    • @DanielChristian19
      @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!

  • @gerfer6261
    @gerfer6261 4 ปีที่แล้ว +1

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

    • @DanielChristian19
      @DanielChristian19  4 ปีที่แล้ว

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