
Announcements
Hi everyone,
This is my first post, and I'm a French guy, so please be gentle. The goal is to extract an Excel table from a SharePoint file, which might seem easy, but I’m facing an issue. Initially, on PowerApps, I created a new Excel online connection to the file, targeting the table named “Table1”.
However, I’ll need to update the file every month with an export from another software. This export doesn’t automatically define the table, so I set it manually with the same name, “Table1”.
My problem is that my app can never find the table “Table1” anymore after the replacement, even if the name of the table remains the same.
Could someone help me? Thanks.
That is correct - there is an identifier in the background unique to your Table. You cannot simply replace the Table with another one and have it work. As well there is a broader issue that once you attach an Excel Table to Power Apps, any additions need to be done in Power Apps as a hidden field is written with the Power Apps record reference.
If you have access to SharePoint Lists, I suggest you switch to one of those.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps