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
Solved! Go to 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,
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,
User | Count |
---|---|
163 | |
90 | |
73 | |
64 | |
62 |
User | Count |
---|---|
210 | |
153 | |
96 | |
87 | |
66 |