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.
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
184 | |
95 | |
66 | |
64 | |
60 |
User | Count |
---|---|
243 | |
163 | |
94 | |
82 | |
80 |