Patching Records to Salesforce

[jPruett]

Hi All!

I've had a lot of luck with patching records to SharePoint lists in Power Apps to update and store data, but I'm working with a Salesforce data set for the first time, and would love to know how to perform a similar Patch operation to a given Salesforce table.

SharePoint version:
NEW:           Patch(DataSource, Defaults(DataSource), {'Field Name': NewData});
UPDATE:      Patch(DataSource, First(Filter(DataSource,ID = Items.ID)),{'Field Name': NewData});

How can I do the same things for Salesforce tables? Thanks!
--Jon

[v-xida-msft · Accepted solution]

Hi @jPruett ,

Do you want to patch records back to your Salesforce Table using Patch function?

Regarding the needs that you mentioned, I think the Patch function could achieve your needs. The Patch formula is similar to the formula that you mentioned.

# Add new entry into your Salesforce table

Patch(
      'Salesforce Table',
      Defaults('Salesforce Table'),
      {
         Column1: "xxxx",
         Column2: "xxxxx",
         ...
      }
)

# Update an existing record

Patch(
      'Salesforce Table',
      LookUp('Salesforce Table', 'Primary Column' = "xxxxxx"), // find the record you want to update through Primary Key Column in your table
      {
         Column1: "xxxx",
         Column2: "xxxxx",
         ...
      }
)

Please try above solution, then check if the issue is solved.

Regards,