I am currently trying to connect existing database to excel and want to connect to powerapps form so people can submit their entry through powerapps and not excel. But when i try i keep receiving this notification alert.. I thought it was because there was existing data on the table, but when i try with empty table this notification keep showing. Does anyone know how to solve this? Any kind of solution is really appreciated, thank you!
I am going to assume based on the table name that you have multiple tables: due to the table name being Table1_1.
If that table is near another table and you are attempting to add another row they can't overlap with data in both table, try putting them on separate pages if there are multiple and they are needed.
The option that I assume that is more likely is that interfacing on Excel can be tricky. The entry that you add cannot modify the table structure so any of the fields or what is assigned to them.
Also using Excel is hard because unless you have a continuous patch function running the data can fall behind in the backend and you could be adding/updating a row or record that doesn't exist any longer or never did.
Lastly ensure if you have any Power Automate flows attached to this table as well that they are not running at the same time as your patch or update functions for only one API in the Power Platform can be making its edit at a time or you get some funky stuff.
Hopefully one of these helps you out. If you need more assistance, drop a reply with more information and let me know what is/isn't working.
If this helps and answers your question be sure to select this as the answer!
Have a wonderful evening!
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
50
Share
Report
All responses (
Answers (
