Submit form not working

[Anonymous]

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?

[Mr-Dang-MSFT]

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]

here it is

[Mr-Dang-MSFT · Accepted solution]

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.

[Anonymous]

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

[Mr-Dang-MSFT]

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.