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
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.
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!