Get CRM 365 record id in canvas app to apply update

Like (0) Share

Report

Posted on 6 Oct 2020 11:27:48 by Chandan Kumar Choud...

Hi Expert,

Need your help. I have a canvas app which is integrated with CRM 365 project form. It shows list of products in a list box and has a submit button. On submit of the form I need to store the selected values to the corresponding project record.

I am not able to get the project Id in canvas app to apply Update.

Below code on submit button is working fine when I hardcode Project number but i need to make is dynamic so that update is applied to corresponding project record.

Patch( Projects, ~~First( Filter( Projects, 'Project Number'= "305519315" ))~~, { 'Products (abc_products)': Concat (lst_Product.SelectedItems, Name& ", ") } )

Please let me know your thought.

Thank you!

Chandan

All responses (2)

Answers (1)

v-jefferni on 07 Oct 2020 at 10:51:31

Like (0)

Report
Re: Get CRM 365 record id in canvas app to apply update

Hi @choudhary_chand ,

Glad to hear that you have resolved the issue on your own. Great job!

For a supplement, you could also get the Project Number and patch in Power Apps with a formula like:

Patch(Projects, Filter(Projects, 'Project Number'= Form.LastSubmit.'Project Number')), {'Products(abc_products)': Concat(lst_Product.SelectedItems, Name& ", ")})

Form.LastSubmit.'Project Number' would get the project number of the record which submitted just now.

Best regards,
Community Support Team _ Jeffer Ni
Verified answer

Chandan Kumar Choud... 9 on 07 Oct 2020 at 09:02:19

Like (0)

Report

Re: Get CRM 365 record id in canvas app to apply update

I was able to resolve the issue. I supposed to create the app from CRM form but i had created directly in powerapps and i was not getting ModelDrivenFormIntegration object. I created another app and initiated it from CRM form then i was able to get the ModelDrivenFormIntegration.Item.'Project Number'.
Thank you!