Hi @jlr89
First add Excel as a data source:
I think you're looking for the Patch function?
Word of advice though avoid spaces in column names if you can - but assuming your text input is called "TextInput" and your name column in Excel is called "NameColumn1";
For a new capture you want;
Patch(
ExcelSource,
Defaults(ExcelSource),
{NameColumn1: TextInput.Text, NameColumn2: TextInput2.Text}
)
where ExcelSource is the name of your Excel connection, and TextInput is whatever you're using to store the input of the powerapps.
"Defaults" tells patch you want to create a new record and to use the Default data properties for each column in the table - this record will automatically be appended to the end of the Excel table.
If you wanted to update an existing record, you'd need to tell it which record to update first - so assuming that the name is unique, you could do the following;
Patch(
ExcelSource,
LookUp(ExcelSource, NameColumn=TextInput.Text),
{NameColumn1: TextInput.Text, NameColumn2: TextInput2.Text}
)
Hope this helps,
Source: https://powerusers.microsoft.com/t5/Building-Power-Apps/Write-and-append-to-an-Excel-file/td-p/131194
-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
