Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Get CRM 365 record id in canvas app to apply update

(0) ShareShare
ReportReport
Posted on by 9

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 

  • v-jefferni Profile Picture
    v-jefferni on at
    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
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard