Power Apps Model-Driven Apps: Form Component Control Tutorial
HTML-код
- Опубликовано: 30 сен 2024
- Use a Form Component Control in your Power Apps Model Driven app so that you can edit a related record without leaving your form.
You'll find the formula you need for the XML snippet here (Step 11 in this doc)
docs.microsoft...
**********************************
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...
****************************
Connect with me on social media:
Twitter: / lisacrosbie
LinkedIn: / lisa-crosbie
Hi Lisa - Great tutorial. I have recommended your video series to other colleagues.
It seems that this process has been improved. It seems that you no longer need to go into the classic view to set the xml value, it appears to do it for you.
- Add a lookup field to the related record on to your source table
- Add components > Add form
- Select Lookup column
- Select Related Form
- Show component on Web, Mobile, Desktop
- Add a Lookup to the table you want in the section where you have added the Form component, this allows you to lookup or create the related record
- Just for fun I added a business rule to the source table that would hide/show the Lookup column, it hides the entire section when you hide the lookup column
Thank you, yes, I made this one a while back, great to see it's improved. I'll add it to my list for an update (meanwhile thanks for adding the steps for anyone else watching and for the tip about the business rule!)
Does this work only for Editing records of related table? I did the same exact steps by adding a new tab on my main form to show form of the related table and I get "Source record not selected" when am trying create a new form. Whats wrong here?
Hi Lisa this is great but what happens if the lookup is to Customer (Account or Contact)?
Show me how it will behaving on create of main form
This is great and very helpful, however I noticed it just pulls everything and not just the specific field controls configured for the form. I'm trying to grab primary contact details for and account I have associated (look up) to a custom table. SO, I'm my head it's like a grandparent/grandchild relationship if that's a thing.
Hlo Lisa, I tried this in my trial account but it showing error when i click on publishing.
I'd suggest posting in the Power Apps community with screenshots and details, there are plenty of people from both Microsoft and the community there available and willing to help with troubleshooting. powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1
Am a complete beginner and this looks cool but there is a bit missing. Where do you copy the pasted item from that you paste into notepad? Its not showing on the recording and it seems a vital step. Sorry to be a pain.
I’ve put a link to it in the video description. I copied it from the Microsoft documentation. I don’t write code myself, just used what they provided.
Hi - greate tutorial - thank you. I'd really like to be able to bring a grandchild record through to my form, ie Entity A is a 1:N relationship to Entity B, with a 1:N relationship to Entity C, with a 1:N relationship to Entity D - I'd like to be able to bring through the look-up field from the C form onto A. Is this possible? Thanks
Hi,
Quick question, what behaviour will JavaScript show on Account n Contact within same form?
Will we see 2 script firing for account and contact at same time or something else?
great video but I do not seem to be able to connect to the form i want to, it just keeps on going back to the main form for the connected opportunity, whatever i try, i will not let me use my custom form. Anyone else having the same issue? i have removed all security in case that was the issue but still the same problem.
Hi Lisa, I tried using the same now but the lookup field is not getting displayed after adding the xml it is getting published but when coming to the ui it is not showing the lookuphere as of such can you help me with that
Hi Lisa - thank you for this! Question: It looks like you used the Standard FormID instead of your Custom FormID. Or did you actually your custom FormID?
Would be great if not that the only thing I got is 'Error loading control'...
Would something like this be possible to leverage using a subgrid as a means to change the lookup value? So instead of having to click into each record from the subgrid (which opens up a new window/page), you could click on the subgrid record and this form component would change based on the selection and you'd stay on the parent page, while making changes to the subgrid values.
This component is going the other way around from what I think you're asking - it's showing the details of the parent record. You can now create an editable subgrid where you can edit each row in line without clicking away, which I think would solve your problem.
Thanks Lisa. Great video
Appreciate your work! Is there a way to make the form (FormId) that appears conditional on a value in the main form?
I'm sure there is a way to do it but you'd need to use code. Otherwise an embedded canvas app might be a better option.
Great feature Lisa! Too bad this is just available in classic mode. Maybe in the next release wave?
Yep, apparently everything will be at parity pretty soon, so here's hoping!
Great video. Is there anyway to do this for a One to Many relationship? I have tried to reverse engineer the Accounts > Contacts setup, but I am unable to get the same options as they have used (looks to be depricated). I want to View the list of Projects a Site has without the need to click to related dropdown option.
Nevermind, the modern interface uses Subgrids to produce relationship data for One to Many.
Spot on!
Cool feature, thanks Lisa! You're the best!
Thanks so much Debbie 😊
❤️ Promo>SM!
Nice one Lisa 👍
This is really awesome trick.
Thanks Lisa 🙏
Glad you liked it!
Thank you so much for your tutorials. I was wondering how can I create a field in a form which is a concatenated field based on values which you selected before with lookups.
So for example
I select Country : france
I select place : paris
Then the value of the field should be France-Paris.
Hopefully you understand me
Yes, you can do that with Power Automate - I'll do a tutorial on setting field values automatically like this, stay tuned, and thanks.
@@LisaCrosbie That's cool, would you also need to use Power Automate if you want to use the value from one column as the default in another column in another table or same table? e.g. when I create a new order request i want the values in the form to use all the values from the previous order for that customer (if one exists)
I think you can create the field type as calculated and using the concatenate rule ( concat "country" "-" "place")
STOP DOING TUTORIALS IN THE ASPX WYSWYG EDITOR... THIS WILL BE DEPRECATED.....
Yes, I know it will be deprecated, I hardly ever use it and but for now this is the only way to use this feature. There are still a few things that are not yet available in the modern experience.
This is tremendous!! Thank you
Thanks Alison 😊