Multiple Data Sources in one Gallery Power Apps

[@komminane]

Excellent , This is very much use scenario for replacing Sub Grids in MDA. Thank You for the Video

[@krishnavandanapu-mvp9302]

I am happy it helped to reduce your work !

[@earthlytable]

You just taught me exactly what I need right now! Have it working. Thank you!

[@krishnavandanapu-mvp9302]

I am glad that worked for you!

[@IHopeless]

Thanks dude... You helped me to filter 2 collections for security issue... thanks a lot

[@krishnavandanapu-mvp9302]

I am happy it helped you!

[@davidgiuliani1657]

Excellent video. Thanks for sharing.

[@krishnavandanapu-mvp9302]

Thank you

[@omarmorales909]

Wow Krishna, I been searching like crazy for this ..( haven't found the correct place ..😀. ) Thanks for posting this video!!!

[@krishnavandanapu-mvp9302]

I am very glad you got what you needed!

[@manishaholkar9514]

Excellent. Thank you for sharing vedio...Exactly what i needed to see right now....

[@krishnavandanapu-mvp9302]

I am happy I was able to help you!

[@jitendratrivedi7889]

Excellent .. Please post video how to build the same from scratch ...

[@krishnavandanapu-mvp9302]

Will do soon

[@9895321716]

@@krishnavandanapu-mvp9302 hi, please provide the link for building it from scratch. 😊

[@smbasha]

This video help me lot...thanks you and one doubt i want last record in lookup Suppose i add more project to the associate and i want to display current project he/she working ..

[@krishnavandanapu-mvp9302]

It shows up automatically as long as we have parent child relationship!

[@eliey4677]

Very insightful, thank you

[@krishnavandanapu-mvp9302]

Thank you for your support Elie, I am happy you like it.

[@jray1429]

Great Job! Thanks for the info

[@krishnavandanapu-mvp9302]

I am glad you see it is helping you !

[@LandscapeInMotion]

Very good concept, thanks! How do you show Parent with its Child records on the same row, using a grid with headers like you have?

[@krishnavandanapu-mvp9302]

Sorry didn’t get you could you please elaborate more on this?

[@LandscapeInMotion]

@@krishnavandanapu-mvp9302 yes, how do you show a 1:N relationship on each row. Example, Project has many tasks, for each project name, show its tasks on the same Row.

[@krishnavandanapu-mvp9302]

You should be able to see that 1:N relation result by end of the query.

[@LandscapeInMotion]

@@krishnavandanapu-mvp9302 end of what query?

[@krishnavandanapu-mvp9302]

I mean with this query should get that result also let me know if that is not working connect me on LinkedIn I shall help you further!

[@garykrauss9747]

Thank you so much! I've been looking for this

[@krishnavandanapu-mvp9302]

Thank you

[@trevbraith4746]

This is a really good presentation Krishna, I am trying to emulate your setup in my tenant with the same table /fields etc as much as possible. Can you share the syntax for the photo field (Device information list) to show in the Gallery in PowerApps.

[@krishnavandanapu-mvp9302]

Hi Trev, There is no formula I am referring the URL of the image as it is part of the list!

[@trevbraith4746]

@@krishnavandanapu-mvp9302 - Thanks, I will try that 🙂

[@ArohShukla]

This is awesome Krishna ...able to share Github resource of the app??

[@krishnavandanapu-mvp9302]

sure very soon..

[@ArohShukla]

@@krishnavandanapu-mvp9302 Thanks!

[@michaelgiorgio3774]

Thank you so much! Wonderful

[@krishnavandanapu-mvp9302]

I am glad that helped you

[@geralddahl9159]

Well done, thank you.

[@krishnavandanapu-mvp9302]

Thanks for watching!

[@maggieho9521]

This is Very Helpful!! Thanks! I am new to PowerApps. Learning a lot here. Questions: in the later part of the video, using only DataVerse tables, what about the 'Company Detail Order'? Is that a table in DataVerse too? Or, can I store the filtered data in a collection? Please advise. Thanks!

[@krishnavandanapu-mvp9302]

It works either way ! As we know collection is a small set of your table this logic works for both ! In fact collection work even more faster as it is at the app level data !

[@DanielADamico]

Awesome video!

[@krishnavandanapu-mvp9302]

Glad you enjoyed it

[@MohammadAli-ts2ev]

Great video...it's, indeed, very informative.. @Krishna -. Can you plz make a video on the issue we experience while picking up DATE to edit form from Excel online (for business). The date picker simply goes blank and it doesn't pick up date from Excel table (date column) while other details from the table appear correctly. Any get around will help many of the people. I got the same issue posted by someone on powerplatform community but none of the answers fixed the issue..

[@krishnavandanapu-mvp9302]

Sure I will do it down the line, I have added on my list !

[@sheebapradhan6399]

This is a great video Krishna. Thanks for this. I have one question - instead of filter, can we have a search option ? If yes then can you please guide ?

[@krishnavandanapu-mvp9302]

Search works on top a dataset so that dataset has to be a predefined or need to be a filter so use search on top of this filer

[@divyanshusoni3448]

Extremely helpful

[@krishnavandanapu-mvp9302]

Thank you 🙏

[@DanielChristian19]

Well done, Krishna.

[@krishnavandanapu-mvp9302]

Thank you Daniel you are always supportive.

[@avalanche240]

Hi Krishna, do the fields connecting the Sharepoint lists have to be lookup fields? What if the field aren't lookup fields but single line of text?

[@krishnavandanapu-mvp9302]

This approach works for both !

[@moyura2]

Thanks for sharing that's very usefully information. I was wondering, how would you apply this concept to a single table like a time table of partime emplyees table (ID, Name, Date, Time In, Time Out), how would you group the employee with date range in a week (eg.1 Jan 2021 - 7 Jan 2021).

[@krishnavandanapu-mvp9302]

In this video I have explained the join operation I highly encourage you to submit a ticket in community for help on grouping

[@maheshgolusula5092]

Thanks for Sharing !! This is very helpful for me. I customized the SharePoint form. In that one single line of text column data card I inserted one horizontal button gallery control. for that gallery I connected other list to display items the concern here is I'm not getting all items to the gallery where as I inserted the same gallery outside of the data card there I'm getting all items Why it is behave like this...? I want to display all items inside data card for that What should I do...? Could you please tell me the answer. Thanks in Advance...!!!

[@krishnavandanapu-mvp9302]

Please submit a ticket for a specific / your project related questions in powerusers.Microsoft.com for instant help. I am currently fully occupied with some personal and office work. I also come and help people in community as and when I get time. All the best!!

[@jasonholland83]

Awesome

[@krishnavandanapu-mvp9302]

I am happy you liked it!

[@ignaciovazquezsoneira3212]

If you could share a video making this app step by step, you would be my idol

[@krishnavandanapu-mvp9302]

That will be like be more than a hour let me what you are more interested I have shared the solution in GitHub

[@umarfarooq2813]

Hi Krishna, I wanted to ask if you please help me with one of the development part for my work project. Thanks,

[@krishnavandanapu-mvp9302]

Connect with me on my linked in

[@kraghavendra6440]

Hi Krishna am planning t learn power apps. Can u pls guide me where to start and how t Start?

[@krishnavandanapu-mvp9302]

I always advise you to start with community: powerusers.microsoft.com this is a best tutor for a new and experienced resources.

[@elanty1]

Hi sir, how to convert collection in power app to string variable, how to validate text file data number of columns is same in all rows

[@krishnavandanapu-mvp9302]

You can't convert a collection to a string because Collection represents table so you can't convert a table to a string. I am not quite clear on your second question.

[@sel_ha8008]

Hi Krishna, Could you make a video about setting up a complex dataverse database to accomplish what you are doing in this video? or just send a description of a download link for the project? Because I understand all the content but you go quickly enough on the dataverse part but I can not understand how you realize the foreign keys between tables, by reproducing your project I could not make your command work Thank you in advance for this quality work

[@krishnavandanapu-mvp9302]

Sure @sel_ha I added this on my list and will try to create a video down the lane

[@piush0402]

Hi Krishna, Thanks for sharing this solution. Somehow this is not working for me. I have 4 SharePoint lists where list1 is parent and list2, list3 and list4 are child. Parent - child has one-to-one relationship. To test this approach I first reset the "Data Row Limit = 5" and my list has near about 70 records but when i apply this AddColumns logic in filter it is only returning 5 rows (i.e Delegation issue). I am joining my list on a column which is a text field. Can you guide me where I am doing wrong. Let me know how do i share more details with you about my issue. Thanks in advance for your help.

[@krishnavandanapu-mvp9302]

Please submit a ticket for a specific / your project related questions in powerusers.Microsoft.com for instant help. I am currently fully occupied with some personal and office work. I also come and help people in community as and when I get time. All the best!!

[@piush0402]

​@@krishnavandanapu-mvp9302 Thanks Krishna for your response.

[@investrules2746]

Thanks Krishna - i love this concept however, I have a table with 450 records (dataverse) and I am using this with another table as a lookup to load up a gallery. It takes 30 seconds minimum to load up. Unfortunately this means it is unusable for me. Is this normal to be so slow, are you seeing similar times, or is it something i am doing wrong ? Thanks again.

[@krishnavandanapu-mvp9302]

Performance always depends on what columns you are performing look up in Dataverse if the column in primary table is indexed that will also improve the performance. What I noticed is 2 seconds max with a record count of 3500 and more. Also depending on your code running for the page/ control to load.

[@davediguer]

@@krishnavandanapu-mvp9302 Thanks - i will look into indexing. I am no where near as good as your numbers. thanks again !

[@davediguer]

@@krishnavandanapu-mvp9302 I am not finding much information on indexing dataverse columns. Do you have any good references or maybe this would be a good video for you to make ?

[@krishnavandanapu-mvp9302]

Sure I have added this on my list and will create a video down the lane !

[@Arjunsuganthar921]

Hi Krishna, Is it possible, Can you please share the data source records in the excel spreadsheet. I would like to try it out.

[@krishnavandanapu-mvp9302]

This is the sample data provided by Microsoft as per of App in a day you can download the same from this link: aka.ms/powerplatformlabs

[@VirtualSensations]

Hi Krishna, is this possible to use with SQL Tables? I'm trying to do the same but seems that doesn't work trying to join more than 2 SQL Tables in one gallery, have you tried this? or maybe do you have an idea why this isn't working? Thanks in advance!

[@krishnavandanapu-mvp9302]

SQL I have not implemented but try denormalize your data to make your code better

[@stephensuda1621]

Can this be achieved using a SQL Connection to multiple tables? For instance in an edit form.

[@krishnavandanapu-mvp9302]

I am not clear on question, in video I have explained how to show data in a gallery but you are asking about in edit form 😔.

[@sundrapillay6668]

Thanks Krishna

[@krishnavandanapu-mvp9302]

Thank you, I am glad you liked it.

[@LamNguyen-jp5vh]

Hi, so if you want to use multiple data sources, you have to combine all those data columns in one list right? Is there any way we can get the data from two completely different lists? Thank you!

[@krishnavandanapu-mvp9302]

In this video I have explained how to get data from more than one list. Yes you can get from two complete different lists but there must be one common column to join the data. It is as similar as SQL join queries

[@LamNguyen-jp5vh]

@@krishnavandanapu-mvp9302 Thank you so much!

[@LamNguyen-jp5vh]

@@krishnavandanapu-mvp9302 liked and subcribed!!! Keep going!

[@ivanmathias955]

I have the following two related tables in Excel: 1. Driver (Columns: Driver_ID, Driver_Name) 2. Drops (Columns: Driver_ID, Date, No_Of_Drops) Driver_ID is the primary key to the first table (Driver) and a foreign key to the second one (Drops). I inserted a gallery in my Power Apps app and set the gallery's datasource to Drops. When I associate the formula ThisItem.Driver.Driver_Name to the gallery's title field, it does not work. Requesting for help with this problem.

[@krishnavandanapu-mvp9302]

I don’t think it works on excel as Excel is not really meant for DB

[@snehaljain1441]

Can you provide details how you bind this data with UI?

[@krishnavandanapu-mvp9302]

I have explained the same in video

[@LandscapeInMotion]

Do you have a blog post with this code?

[@krishnavandanapu-mvp9302]

sorry for the late reply, I have not created any blog on this but may I know what exactly looking for?

[@LandscapeInMotion]

@@krishnavandanapu-mvp9302 do you know how to set the Default value for a datacard drop down box?

[@krishnavandanapu-mvp9302]

Post all these questions in the community for a better help: power users.Microsoft.com

[@VivekKumar-wm6ky]

Can we get source code ?

[@krishnavandanapu-mvp9302]

Sure I will create a GitHub source repository and will share the link here