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.

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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,830)