Boost Your Model Driven App's Functionality: Creating Nested Child Grids in Under 5 Minutes
Vložit
- čas přidán 24. 07. 2024
- Looking to show a list of related records in your model driven apps? In this short and fun tutorial, I walk through the steps to go from a simple app view to a fully nested child grid. I demonstrate how to add controls, choose child tables, set up lookup fields, and even add some color.
- Věda a technologie
Connect with me:
☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie
🖇 LinkedIn: www.linkedin.com/in/lisa-crosbie/
📼 TikTok: www.tiktok.com/@lisa.crosbie
🐦 X (Twitter): twitter.com/LisaCrosbie
📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps www.linkedin.com/learning/microsoft-power-platform-fundamentals-pl-900-cert-prep-power-apps/
You've shown how to add colors to the lines! You made my morning, Lisa!!
Awesome; it’s beautiful isn’t it!
This video couldn't be more perfectly timed for the project I'm working on. Thank you, Lisa!
Hi andrew... I am from india... current learning power apps. Can we connect on linkdein. Thanks in advance
Holy smokes I can litterally hug you right now. I was working on a showcase app and was stuck with a issue of linking child records to a master record and this solved it. So embarrassed as a Cert app maker that it took me too long to figure it out on my own. TYSM.
Hahaha, thanks for the virtual hug, and glad to have been able to help!
Excellent Lisa, YOU ARE THE BEST!!!! thank you for all your very clear explanations, but this time you reach the highest point!
Wow, thank you!
Thank you so much, Lisa! Your tutorials are amazing and of big help to me.
That is pretty cool. I can't wait to test that out. Thank you very much for providing this little tip.
Absolutely amazing. Maybe make 5 minute powerapps model driven hacks part of your content. More content about on how to color columns would be interesting. Keep going Lisa!!
Cool idea, thanks.
Great work and an easy to understand briefing. Thanks!
Another awesome tutorial Lisa, thanks. I am wondering if there is a way to achieve the same nested grid behaviour on columns from the same table. For example, from a list of Salespersons user can use the arrow button to open a grid containing list of Customers of that specific Salesperson. Perhaps you covered that in one of your videos.
Thank you Lisa! regards from Venezuela, i'm a follower of you work and video, thank you a lot for the insight
Hey Lisa, awesome video.
I was messing around and you actually don't need to go to the classic experience to do this any more.
You can go to edit a view. In the view, you have a new 'component' button on the grid. Click on add a component and add the Power Apps Grid view component and link the table as you showed. Bet cha you can do this under 3 mins now 😊
Would be cool if you could do a video on different components that you could add to a view and give some different ideas on types of views that could be possible
Yeah this video got out of date in almost record time! Thanks for adding that detail for others to follow. If you take out the wait for switching to classic it’s WAY under 3 minutes for sure. 😊
Thanks for this tip. Sadly, I get an unhelpful generic error when I try to save and publish any view on any of my custom tables when I try to use this method.
s0 weird, been able to add almost any plugin in my views, including a few custom components to a custom table.
You may need to raise a ticket with Microsoft
@dvspriest, I can confirm it works! Thanks, man!
This is pretty slick for the user who is not adding a new candidate.
So cool and worked great, thank you! I tried it with a Solution that has a Parent with child items, and those child items have their own child items. I added the Power Apps Grid control to the Middle level table as well, hoping I'd be able to drill two levels down from the main Parent Grid.... no luck yet, but maybe in the future??? lol
Worth a try! Glad it worked for that first level for now anyway.
Brilliant again - thank you for making my morning!
this video made my day ! quick qustion, can you get an "Add New" option for the subgrid?
Not for this control yet as far as I’ve seen but they do seem to keep adding to it. Make sure you’ve got quick create enabled for that child table
Awesome material! thank you for it. Do you have a video to add totals to views? For instance, I have a list of invoices per Customer, I'd like to sum the total of all invoices per customer. Thank you again! :)
Really useful tip. Works like a charm with a standard table but when my client suggests replace this child table with a custom activity table (ouch!). I think this hits a limitation with the PowerApps grid control: The child-> Master record relationship is created implicitly through adding it the timeline control which gives you a many-to-one relationship ( Regarding) . However, this doesn't appear on the Lookup.Simple dropdown which only seems to shown the standard lookup columns. Is there a way around this ? Update: we added an additional lookup ( many to one) to the child table and then you can use this as a Lookup.Simple . The result being we can show our custom activity table in the PowerApps grid .
Hi @LisaCrosbie great video. Is there any way to get the selected rows of a 2nd level (for example the guids) to make some actions in a custom button only for the selected records of the subgrid, it doesn't matter if the selection is in the 1st or 2nd level. Thanks
Wonderful, Thank you Lisa
Awesome! Do you have a more in depth video of this particular recruitment solution? Would love to see more of it if possible. Thank you!
Coming soon yes!
Hello Lisa, Have been learning a lot from your video lessons for last week or so. Have a question about the Nested Child Grid. Is it possible to add a record in the child record directly in Grid itself on the same screeen?
Hi Lisa,
Can I get and show the timeline for all records from a table and sort them by date? Or how do I see timeline activities from all table records?
Amazing, would it work with Sharepoint files to roll out all the major OR versions with check-in comments of the files?
Is there a way to add a label/title/header to the nested grid?
I have been looking everywhere to find how to activate the option list color. Thank you!
Glad I could help!
Can you put this in a section on a form? Let’s say you have different events with different groups of people and you want to add people to each group on the form of the event?
Thanks a lot Lisa
I discovered your videos just at the right time. Getting a little bit frustrated but not enough where I was ready to stop trying to get Power Apps and Model Driven Apps to work for me.
Do you have a video that would help me get the colors that I have for my Choices to match the colors that show up on the chart? So, if I've got a selection that is red = fail, then when I graph it, the part of the pie that shows the Fail # would be red as well.
Sorry, no, charts are not that flexible, and I've seen nothing invested in them for years. All the direction now is the ad hoc Power BI reporting, better grid display options, and I now Copiolot to generate reports on the fly.
Lisa, thank you as always for your fantastic videos. One issue that I would love to see a video on is how to leverage the @mention notifications for timelines and rich text fields, I have followed all the guidance but still when typing @chris for example nothing happens. I have enabled sharing and in app notifications and my app is on the monthly release channel. Other notifications work fine and people are receiving them if I interact with the notification table but for the life of me I cannot get the @mention working. Your guidance as always would be appreciated. Thanks for the UK. Joe
Thanks - to be honest it’s not a feature I’ve used or valued much, I think the embedded Teams chat is probably the more effective way to do this now, is that an option?
Thanks for the great vid. Can't for the life of me work out where to enable the colours for my global choice list. Added colours to them afterwards but they will not appear in say my Active view
Excellent 😊
Can you used it in a Power Page?
so helpful! thank you!!!🥰
This is so awesome! Is it just me or does not it work for the "Customer" type Look-up fields? I was trying to get this in a view of Accounts with Invoices nested. But the "Customer" (in our case always an Account) is not available as the child field.
Hi Lisa! Great video, thank you!! I am having an issue where the child table is not populating any information. I have a lookup column, with purchase order being the common datafield between the 2 tables. Any guidance would be fantastic, thanks again!
There isn’t enough information there for me to work out what the problem is sorry. Perhaps try posting more details with screenshots in the Power Apps Community forum.
I've been pretty keen to get some of these features in my view, but for some reason they just don't work. I had previously tired as you demonstrate here, using classic experience, and it just doesn't work despite having Web Tablet Mobile all clicked off. Yesterday I tried the modern add component button as per a suggestion below and this also doesn't work, but at least it gives me an error when I try to save & publish. Unfortuneately, the error just says it cannot save and publish right now, try again later.
The odd thing is it only doesn't work for my custom tables. If I add these components via either method to Account or Contact, these features work fine. None of my custom tables allow me to do this. I tried a brand new view to see if some column wasn't compatiable and no still had no luck. Today I'll probably try a fresh test table and maybe a blank solution.
Really stumped on why I can't get the new view control to work on my custom tables.
How frustrating. First thing - are you working with Dataverse in the Default environment (that will be a problem, the full features aren't available there)? If you're in another environment with a full license, I'd suggest asking this question in the community forums to see if anyone else has come across it.
Really nice Lisa!! Thanks a lot!!!. Is there a way to do something similar with N to N relationships as the intermediate table for this case is not considered as an entity.
Sadly not that I've seen at this stage.
How to you add a new record in the subgrid ?
Great video - have you noticed we can do it via the new designer now ? - via the Components and add the Power Apps Grid control - it gives us the possibility to set it up from the view designer as well
Thanks for adding that tip and update - that might be the shortest time between recording a video and finding it outdated!
@@LisaCrosbie Yes - its really hard to keep up :-)
Thank you! I turned this on a couple weeks ago but now have changed my mind - I want to turn it off but "switch to classic" is gone - is there a way to do this in the modern interface?
Actually, yes, they made that change about a week after I posted this video! In the bottom right corner of your form designer you'll see a section called Components, you'll find it there now.
Thank you for this!
I also Enabled editing in the PowerApps Grid control settings but got errors.
I can see the grid is editable. But when an item is edited it gives me an error 100 - Unknown Error Format.
Any reason why ? And how would one fix this issue?
Very hard to troubleshoot here, I haven’t seen that before. Perhaps try positing a screenshot and full details in the power apps community forum
Hi, thanks for the video!
- Is it possible to have more than one depth of child? Ex. Parent > Child1 > Child2 > ...
- Is it possible to nest lines of the same table? Ex. Table1Parent > Table1Child
- Is it possible to combine these two scenarios to have more than one depth of nested lines from the same table? (If it's possible, do you have the repeat the process shown in the video for each depth or it's going to self-replicate to n depth).
Ex. You interact with a Business that has two Bureau, each of which has two Employees. In the Contacts table, you create a contact for each of these entities.
Can your Contacts table look like this:
Business > Bureau-1 > Employe-A
> Employe-B
> Bureau-2 > Employe-C
> Employe-D
Hi Lisa! Do you have any video teaching how to make a followup email? Like getting data from a table (or more) making an email template and send it with the history of all events? Like post office, FedEx would do
This might help: czcams.com/video/_u0Or8gFbxw/video.html
Hi Lisa! First of all, thank you for all your videos about Power Apps! I want to be able to send an email ( of the content added in a form) to multiple users (AAD users), but I cant find any videos or information about this. Lets say I would write title, status, and other information about a product or case in a form. Thereafter I would like to add participants to this document in the form and also have the ability to send the same people and email with an automatic generated pdf/word from the information put in a form. In order to do this i need to be able to add several users in a form. Until now I cant figure out how to do this. Could you make a video about this as I think this could be relevant for many people? When I say several users it could be a sales team. I have added a table for lets say sales team, but this is not my main table. I tried to use lookup function, but this seems to just enable me to select one person from the AAD user tabel and not several like you would do in for example a normal email sent out. Thank you. Greetings from Norway
I'll add it to the list but it might take me a while to get to it. In the meantime the answer is that you need to create a related child table (not a lookup). So, one Product can have many Sales Users assoicated with it. On the product form you create a subgrid to show the related Sales Users. In your email flow, when you get the product, the next step in the flow is to list all the rows in that related Sales users child table.
Do you happen to know IF it is possible to create a further nested grid under the one you created? So for me I have a view that shows "Seasons" and under it , listing "Productions" and I would like that to open up into nested "Performances", all of which have relationships. I did try creating another grid control but as best I can see it only shows one or the other. Thoughts?
At this stage no, this control doesn’t let you do that - although it’s what everyone is asking for so I did pass the feedback to Microsoft.
Hey Lisa, is there a way to add a row to the child grid to the selected parent? Would this be conditional programming on a custom command button? Using PowerFX or a web resource?
I don't know if I'm understanding the question correctly, but you can use Power Automate - on create of a row (parent table), create a row in the child table related to it.
This is wonderful Lisa... Thank you! Odd, but I don't have "Application" in my Data Source Entity dropdown. Ideas?
Application is a custom table I built. The principle will work here with whatever tables you have. If you want to use out of the box tables, try it with Account (parent) and Contact (child) tables.
@@LisaCrosbie Ahhhhhh… Thanks so much Lisa! You are Appreciated!👍🏾
Hey Lisa :-) Is there an easy way to hide those roles that does not have applications (child records)?
The way I'd do that is using a rollup column and a filter. On the Role table, create a rollup column that is a count of the number of applications (child table). Then on the Role View, add a filter to only show roles where that value is 1 or more.
Great stuff! Can this go down another level to grandchildren records?
Unfortunately not
Nice one👏👏
awesome!!!!👏🏼 thanks
Lisa, thanks for the insight and tips🙏🏼
A question: what's the tables' setup?
You have a sort of "master" *Roles* Table. The *Application* table then has a column _Role_ , which looks up the *Role* Table (probably the _Name_ of the Role🤔) and the _Candidate_ column is a lookup into the *Contact* table?
Did I understand it correctly?
I mean, I would have had no problem if you had taken more time and gone the entire Project/App😂
Thanks again.
Greetings from Germany.
It's a one-to-many relationship. One Role has many Applications. Role is the parent table and Application is the child table. Hopefully that helps to explain it for you.
I'm working on a whole tutorial video, I recorded this as a snippet while I was putting the rest of it together - stay tuned. The Candidate is the Contact table. The Application table has a lookup to a role table and a candidate (contact). The application table is used to manage an end to end process when someone applies for a role - going through screening calls, interviews, reference checks etc.
Let’s just say it people….Lisa is All-Knowing!
LOL, I'm not sure if that's true. Certainly all-learning!
wow... it's amazing...
How may child levels we can add? Is possible to have Parent->child->child->child?
Same question
It only goes to the one level with the child table. If you want that multiple drilldown experience you'd need to use a custom page.
It only goes to the one level with the child table. If you want that multiple drilldown experience you'd need to use a custom page.
Hi how long does it take to become power platform expert as I am relatively newbie to this.
Honestly that's a really hard question to answer, it depends on your experience and how much time / energy you can dedicate to learning, getting practical experience, and how fast you learn. I'd suggest picking one part of Power Platform (it's not possible to be expert in everything) and a use case that means something to you - e.g. building an app to solve a business problem and go from there. You might also like to start with the PL-900 and PL-100 certification learning paths. Good luck.
I can add my recent experience starting Power Platform as a bit of a guide for you.
I started working with model-driven apps, power automate, business process flows and PowerBI to report off them in June of this year. My work week is probably 25% spent on power platform stuff. In the first couple of weeks, it was pretty painful as I was reading the official docs and just heading forward blind (no one else at my company to guide my learning). Within the first 2 months work was slow and functionality was basic. Then I finally spent the time required to find good learning material (like Lisa here). Two days working on my overal knowledge made a huge difference.
Today, 5 months later, I can throw together any of the simple 'example' apps in an hour or two, assuming I know 100% what problems I want to solve. I've learned that you need to plan a lot more with your stakeholders (users, managers) than anyone wants and make sure your data model is planned out. Once that is done, building the tables, columns and app is pretty easy. I'm now learning about Power Pages and javascript client scripting to make the user experience bettter and replace some of the flows (which have delay) with real-time client logic. I'd say I am currently an advanced beginner or intermediate of the portions of the system that I use. There are still things I haven't even touched.
At this rate of learning, I would need another year to consider myself anything like an expert on the corner of Power Platform I am using most. In reality, I wil llikely slow down learning and solve more business problems with what I can already do in the coming couple of years, so it could easily be 3-5 years before I would use the term expert to decribe myself.
I expect I am learning pretty quickly, since I have a strong background in Excel, some experience in SQL, use Python to avoid work, etc. If you have a weaker 'data' background, I would expect it to take longer.
At @1:24 the sound drops out for half a second and it makes it sound like you've edited out a rude word 😆
Haha, sometimes there are rude words when o have to re-take too many times but they never make the final cut 😂
is this applicable to canvas app?
Else, I change my datatable view to this format?
No, this is only a model-driven app component. If you are building a canvas app on dataverse you can use the new Data Table (Preview) component which is similar.
You would need to build your app using dataverse and model driven apps.
Thanks! No love from Microsoft for many-to-many though. :(
Yeah, many to many is a whole other thing!
I feel like this should be an option for many-to-many relationships. Do either of you know if there is a way to show many-to-many (read-only) in a comma delimited list on the main view?