Patching and Excel Table

(0) Share

Report

Posted on by colbyturybury

363

I am using Sharepoint as a datasource. I need to write the information from a sharepoint record to an excel spreadsheet that has a bunch of formulas. and a various number of tables within it. How do I patch an excel spreadsheet? Is the process that same as patching a sharepoint list? When importing the excel spreadsheet and I choose the table it asks if I want to use a created column as the key column or let power apps generate the column in the excel table. I let power apps take care of that addition.

I keep get the error, "This item has already been created on the server. This wont work because it would move cells in a table on your worksheet."

Below is my code:

Patch(
General,
{
'Project Name': ThisItem.Title,
City: ThisItem.City,
State: ThisItem.State,
'Requested By': ThisItem.RequestBy

}
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @colbyturybury ,

To add a new record into a table, you need below syntax:

Patch( General, Defaults(General), { 'Project Name': ThisItem.Title, City: ThisItem.City, State: ThisItem.State, 'Requested By': ThisItem.RequestBy } )

Best regards,

Was this reply helpful? Yes No