Customer Engagement & Dynamics CRM Forum

We have an embedded Power App form in D365 on the Account record. This form is essentially used to create new child Account records. On the form, users make a selection in a choice field and the only option in the choice field is Account record they are on. When Account is selected in this field, other fields on the form populate based on fields on the Account record selected (the Account being used to access the embedded form). When the form is submitted, a child Account record is created, the selected record in that choice field becomes the Parent Account.

We had this formula behind the field:

First(Filter(Accounts,Account=GUID(First([@ModelDrivenFormIntegration].Data).ItemId)))

It accomplishes what we need. However, now the formula is throwing an error. It no longer works as expected, and we can't figure out how to fix it.

We need the Account record being used to access that embedded form to populate in that field as a choice. When users submit the form, the submitted record now has that Account as their Parent Account.

I have an open support ticket with Microsoft, but so far they have not been able to provide me with a solution that works, and say the formula came from a third party (true, I found it online, I think from here) and is therefore unsupported.

 Can anyone help me out? What formula should I be using here?

Hi Autumn,
You should be able to achieve the same outcome by just setting the Items property of the dropdown to [@ModelDrivenFormIntegration].Item and selecting Name for the Value Property.

I believe [@ModelDrivenFormIntegration].Data is no longer used, which might be causing your error.



Let me know how you get on.
Thanks

Calum

We have an embedded Power App form in D365 on the Account record. This form is essentially used to create new child Account records. On the form, users make a selection in a choice field and the only option in the choice field is Account record they are on. When Account is selected in this field, other fields on the form populate based on fields on the Account record selected (the Account being used to access the embedded form). When the form is submitted, a child Account record is created, the selected record in that choice field becomes the Parent Account.

We had this formula behind the field:

First(Filter(Accounts,Account=GUID(First([@ModelDrivenFormIntegration].Data).ItemId)))

It accomplishes what we need. However, now the formula is throwing an error. It no longer works as expected, and we can't figure out how to fix it.

We need the Account record being used to access that embedded form to populate in that field as a choice. When users submit the form, the submitted record now has that Account as their Parent Account.

I have an open support ticket with Microsoft, but so far they have not been able to provide me with a solution that works, and say the formula came from a third party (true, I found it online, I think from here) and is therefore unsupported.

 Can anyone help me out? What formula should I be using here?