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 to Clear Cache in Canvas PowerApps while working on Offline mode?

  Introduction In this blog, we’ll look at how to clear cache in Canvas Apps when using the Power Apps mobile application, especially when t...