Tuesday, January 13, 2026

How do I patch a Currency field value from a Canvas Power App to Dataverse?

 Introduction:


In this blog, we will see how to patch a Currency field value from a Canvas PowerApps to Dataverse or MSCRM

Implementation Steps:

  1. Navigate to https://make.powerapps.com

  2. Click On Apps

  3. Click New and select Start from Page Design


  4. Click Create

  5. Now once the page opened Add a Datasource called Accounts



  6. Now Add a Gallery and Select Items as Accounts




  7. Now Add a Form and Select Items as Accounts and Gallery.Selected as Account






    ​​​​​​​
  8. Add a Column Annual Revenue ( in my case am using account table as my DS)

  9. Add a Submit Button

  10. On select of Submit button add below code

    Patch(Accounts,
    LookUp(Accounts,Account = Gallery1.Selected.Account),
    {'Annual Revenue':Value(DataCardValue1.Text)})
Descrption about Code:

  1. Patch - Save the record to DB
  2. Account - Table Name
  3. Lookup Query - Retrieve the record to Update
  4. Annual Revenue - Column Name
  5. Value - As Annual revenue is my Column to update it will expect Number 

Conclusion :

Using above code we can patch Currency field to Dataverse or MSCRM.

No comments:

Post a Comment

How do I patch a Currency field value from a Canvas Power App to Dataverse?

  Introduction: In this blog, we will see how to patch a Currency field value from a Canvas PowerApps to Dataverse or MSCRM Implementation S...