Get CRM 365 record id in canvas app to apply update

[choudhary_chand]

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 

[choudhary_chand · Accepted solution]

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!

[v-jefferni]

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