web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Ba3879Fg7yxMp3vcfwbJ46
Power Apps - Building Power Apps
Answered

Get CRM 365 record id in canvas app to apply update

Like (0) ShareShare
ReportReport
Posted on 6 Oct 2020 11:27:48 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
    on 07 Oct 2020 at 10:51:31
    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 Choudhary Profile Picture
    9 on 07 Oct 2020 at 09:02:19
    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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete