How to write formula to update values provided in canvas via textbox to excell

[Hemasai]

Hi,

Request to help

[Anonymous]

Hi @Hemasai ,

If your Excel file is connected as a data source of the Power Apps canvas, using SubmitForm can save the information back to Excel (including adding new record and editing existing record); and the textbox might be one of your columns.

[v-jefferni]

Hi @Hemasai ,

Assuming that you are working on an editable table, the way to submit data to Excel table depends on your scenario:

1\ If you would like to submit data on record level, that means once created a record the user should submit it, you should add a save button/icon in the gallery item. 

2\ If you would like to submit the whole table/collection to data table, you will need to add a separate save button out of the Gallery. Video and blog below would be helpful:

https://www.youtube.com/watch?v=mj4mKS1hS7M

https://www.sharepointsiren.com/2020/09/power-apps-editable-table/

&

https://powerapps.microsoft.com/en-us/blog/editable-tables/

Based on your screenshot, it looks like the scenario in the last blog is more likely as in yours.

So I think your formula could be:

Patch(Table1,Defaults(Table1),{EmpID:TextInput2.Text})

This would add a new row to the data table.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[v-jefferni]

Hi @Hemasai ,

Have you resolved the issue? 

If above post helps, then please consider Accept it as the solution to help the other members find it.

Best regards,
Community Support Team _ Jeffer Ni