Answered

Get CRM 365 record id in canvas app to apply update

(0) Share

Report

Posted on 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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Chandan Kumar Choud... 9 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No