Power Apps Model-Driven Apps: Subgrids and Quick Create Forms Tutorial
Vložit
- čas přidán 28. 06. 2024
- In this video you will learn how to create and configure subgrids and quick create forms in Power Apps model-driven apps. This tutorial covers the core concepts of what a subgrid is, how to add one to your form, and how to enable and create quick create forms for easy data entry.
If you're a complete beginner with Power Apps model-driven apps, make sure you watch my tutorial for complete beginners first here: • Power Apps Model-Drive...
****************************
Follow me on social media:
Twitter: / lisacrosbie
LinkedIn: / lisa-crosbie
****************************
Timestamps:
0:00 - Subgrids in model-driven Power Apps
1:33 - Create and configure subgrids
5:51 - Create and configure Quick Create Forms - Věda a technologie
I find your videos very easy to understand. Thank you so much
Simply the best. Your videos have given so much of great insights!! Well done Lisa.
Oh, thank you so much Bibek, really appreciate that.
Hi Lisa thank you for your well explained videos. I am exploring this new area of Power Apps, so far I am hooked to Model-Driven Power Apps due to the massive utilities that come bundled into it; and also, I am coming from the database-first development area.
For those of you, who like me were looking for QCF without having necessarily the table shown on navigation menu. You must at least add the table in Edit Apps/Tab table then shoose option not in navigation menu. This way the QCF will appear.
This is a really important comment, thanks!
Yes! Very good point. Spent hours trying to figure out why mine didn't work. A note in the video should be included.
Thank you Lisa! Even though the new table screen has moved the settings this video got me going!
So glad! Thanks for watching.
Hi Lisa, thank you for your video, crystal clear, very efficient, nice English speaking that I envy ;-). You have a lot talents.
Fun comment about the Related tab. As I wasn’t able to get rid of it in order to simplify the UI, I deleted my dedicated subgrid tab and reworked the default view offered by the Related tab. Yes it means more user clicks but a less confusing UI that presents redundant entry points.
I wait for your next vids.
Hi Lisa, I recently came across your videos and already watched a lot ! Keep them coming !
Programming within Dynamics is fairly new for me, I have some Power Apps experience and as such your videos are giving me a jump start!
(I also like the Lego Ghostbusters and Type Writer in the background :) )
Greetings from Belgium!
Thanks so much, and greetings back to you in Belgium all the way from Australia! The Lego Ghostbusters car is the most commented on thing in my backgroud - it's really cool, even has moving parts. The typewriter is also Lego but far fewer people notice that one!
@@LisaCrosbie Question on subgrids and quick create form: I have a table with 2 forms - one form for admins one for user (the latter has less fields - on each of the form I have a subgrid to the same table; I created 2 quick create forms (one for admin, one for user with less fields) and I want to attach them to their respective form (admin or user). The form settings of the quick create form lets me set the order but it does that automatically for both forms.... any idea on how to get the correct quick create form pop up in the admin/user form?
Hello Lisa, … definitely a great video I just reviewed once more time and still learning small key things you said. Thank you.
Oh that’s so great to hear, thanks Tristan.
@@LisaCrosbie Worth to add as comment, that may be Quick Edit might not appear so to fix it, we must add subcomponent to the solution. (I found that solution on microsoft forum)
Loving your videos! Can this be done the other way round? If I was in the equipment orders page, could I create an order and then have a tab for creating the parent (equipment)?
Instead of equipment-orders I’m trying to create something for recruitment, candidates (one) - positions (many). There may be many positions due to returning employees or contractors that return for additional stints with our org.
Sometimes I’ll want to start with the position, then add the candidate once selected and other times start with the candidate, and add their additional position.
Does that make sense!?
Clear explanation!
I was actually curious whether it is also possible to update rows in the subgrid itself, like in Excel. So without a separate form.
Yes you can, just use the editable subgrid option.
I have a lot of nice new things to have a think about 😊 THNKS
That's great!
Super red ergonomic chair - that'll be the chair I order. Thanks Lisa.
Good choice! (I need one myself!)
Hi Lisa, Thank you for your videos!!
I started learning model driven apps by watching your videos😊
I have a small doubt, we can lock fields using business rules with lock/unlock component but is there any way to lock the sub grids without allowing users to create new one once it is moved to approval stage
Hi Lisa. Thanks for this and is there anyway to filter sub-grid based on another subgrid values ?
hey lisa loving your videos i have a question i have entity named flight booking and have subgrid in form when i want to book flight i want to show some specific flights in subgrid which i choose how should i do it?
This was great, thanks Lisa! I was so glad to hear you were going to do a Quick View Form video also. I've been trying to find a way to make the Quick View Form read-only but the read-only checkbox for the individual fields (to the right) doesn't seem to work. Is there any way to make the Quick View Form or its fields read-only without writing any code?
Fields on a Quick View form are read only by default, you shouldn’t even need to select a checkbox option? docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-edit-quick-view-forms
I have the quick creat option enabled on the entity but it still goes to the main form, any suggestions on how to ensure the quick create displays?
Hello Lisa, on 2:54 you selected a view of related records. I Need to have a view with to many levels. Do you have any example ? I need to use an attribute of the form as the view parameter. Thanks!
Hi, if I create a new equipment, the subgrid would not show before I save the new equipment. Is there a workaround to, while creating the equipment the equipment order can be added too? My usecase is a bit different, but the same problem.
btw great video!
To enable 'Quick Create Form', the tick box for 'Leverage quick-create form if available' is now under the table 'Properties' cog.
Thanks for adding that to help others, the maker experience has changed a bit since I recorded this.
Thanks!
Thank you so much!
Hi Lisa, thanks again for your great work. When i have a subgrid in my table and i create a new Record in the original table (not in the subgrid), it will not be shown in my subgrid. Is this correct? So it seems to me, the subgrid is not really synced with the original table...?! I "Hope" it is only a settings thing, otherwise it would be really useless. ?!
The subgrid is for showing the related (child) records. If you have an account (original table) showing related contacts in a subgrid, and you create a new account record you don’t see that in the subgrid.
Thanks, Lisa, could you make a video for editable grid?
Indeed, yes, on my list of new things to cover, stay tuned.
I have tried this though with my own scenario. On clicking the "+ Add New Material Item" button, the system takes me to the "Main" form instead of the "Quick Create" form that I have created. Where could I be going wrong, OR, is there a way to force the Add New button to open the "Quick Create" form??
Hi Lisa, thanks for your videos, you are a great teacher, Im Jorge from Brasil, I was wonderignif you create solutions upon request and also if you can teach one of my developement teams.
Hi Jorge, thanks so much, I actually have a full time job, sorry, can't take on extra outside that.
Hello, I tried the same thing but I am not getting the result. What relationship did you use?
For my app to be able to use the Quick Create Form it seems I needed to add the sub Table (e.g. Equipment Order) as a menu item in my Model Driven App.
Thanks, this is what worked for me.
Yeah. This is an odd bug. They have to be inside the same group of tables in the app menu once. But you can move it out or delete it from the menu and it will continue to work correctly afterwards.
Hi, do know is it possible to use Quick Create form for Comments (or other records with "Regarding" lookup as parent)?
Yes, you can do this with activities when creating them using the + from the timeline.
I would like to ask, theres a question in one of the microsoft exams that asks how users can edit data from other entities in the main form, and many people chose subgrids, but i thought the right answer would be to add a quick create form. Can I get your opinion on this?
Hard to say without knowing the full details of the questions and answers which obviously you can’t share because of exam NDA. I’d lean towards the subgrids as the more likely correct answer if the question was about how to edit (rather than create)
Hi, I get a strange issue. I did everything to enable quick create (add a tab, add subgrid, create a lookup field in the child entity). However, when I click on the quick created form from the subgrid, I get the main form. Can anyone give me some point what I am missing. Thank you.
Have you also enabled Quick Create on the table in the subgrid, then published. Have you created a quick create form on that child table, and then added it to your app?
Don't forget to add the Quick Create Form to your App. If you don't do that, you'll drive yourself nuts for a few hours.
Can you tell me how to do it please?
@@Rokicin Go to the App Editor; Click on the Page that represents your entity (Table). Click on the " form" selection in the left hand menu. Then over on the right, click Add form. Find your Quick Create form and add it. Hope that helps!
Thanks for the tip!
@@carrema Thanks 🙏
Woww.. this is so good content. I have been waiting for your new video and this has made me keen to learn from you on Model Driven Apps. One question - how and from where the button "New Equipment Order" at czcams.com/video/baRLW8bak9Q/video.html has come from? Has it automatically come when you added a grid for related records?
When I create the subgrid it is automatically there. This didn’t used to happen, you had to enable quick create (shown in the second half of the video) before it would appear. If you don’t see that appear automatically on your table, follow the quick create steps in this video and that will fix it.
Hi Lisa, There is something wrong with this video. Can you please replace it? Thank you for all of your videos.
Hi Jill, I'm playing it back, can't see anything wrong with it? What are you seeing that's wrong?
@@LisaCrosbie Hi Lisa, Now, of course, it's working perfectly! I tried a few times yesterday and the video was scrambled. Your videos are so helpful. Thank you.