cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Submit form not working

Hello i am creating my first app, its a task manager for my company, it is connected to an excel workbook as a database (i know SQL is better but my company won't allow it) when I submit a new task from my form called Tareas it will display an error on the OnSelect category for the submit function Submit(form) and it will not update the excel table. How can i solve this?

1 ACCEPTED SOLUTION

Accepted Solutions

Thank you for getting the screenshot. Yes this error means you are not able to write back to Excel as it is locked for editing. All instances of the workbook need to be closed for you to write back. 

 

Excel is excellent for prototyping, but I would not suggest using it in production. As a freeform spreadsheet, it does not maintain data types for each column. And as you see here, it is not able to write when the file is still open. I would suggest migrating your data to a more appropriate location in this context.

View solution in original post

5 REPLIES 5
Mr-Dang-MSFT
Power Apps
Power Apps

Hi @Anonymous,

Can you hover over the error message when reporting errors? From your image though, it is likely not submitting since the Excel workbook is open in another tab. 

 

Let me know if that is the case.

 

Brian

Anonymous
Not applicable

here it is

Thank you for getting the screenshot. Yes this error means you are not able to write back to Excel as it is locked for editing. All instances of the workbook need to be closed for you to write back. 

 

Excel is excellent for prototyping, but I would not suggest using it in production. As a freeform spreadsheet, it does not maintain data types for each column. And as you see here, it is not able to write when the file is still open. I would suggest migrating your data to a more appropriate location in this context.

View solution in original post

Anonymous
Not applicable

thanks! it worked, yes i dont like excel for this either, what would you recommed that it is not a payed option?

Business data is valuable and sensitive. Power Apps aside, it is important to locate your data in an appropriate location for the business's sake. You will get back security, structure, maintainability, and more with anything that is more than a spreadsheet. Nowadays I use Excel more as a collaboration space for non-sensitive data and for quick data operations and fill-down.

 

You can look to Common Data Service, SQL, SharePoint as the Microsoft offerings, but there are many others that you can use as well. It would be worthwhile for you to open a discussion with your organization on what fits the business needs.

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,776)