Answered

Submit form not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Mr-Dang-MSFT Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

here it is

Was this reply helpful? Yes No
Verified answer

Mr-Dang-MSFT Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mr-Dang-MSFT Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No