Can't access files from Excel Online (Business)

(0) Share

Report

Posted on by AM-29051822-0

Hello,

I'm doing one of the lessons on how to use PowerApps and I'm trying to access my excel tables. Even though the Excel Online (Business) shows status of Valid connection. I have an Error loading. Try again . I've cleared cache and cookies, tried incognito mode to no avail. I've deleted and remade the connections. The connection works fine in PowerAutomate on some flows I have there but I don't know what it wouldn't work here. Any advice? Thanks.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

ronaldwalcott 3,906 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try recreating the connection and ensure that the excel file has a range on a worksheet created as a table.

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Since the Excel Online (Business) connection is valid and works in Power Automate, I would focus on verifying the workbook itself: ensure the file is stored in

OneDrive for Business or SharePoint Online, confirm the data is formatted as an Excel Table, and test with a new workbook containing a simple table.

If the issue persists in a brand-new app, check for connector-related service issues or permissions problems with the workbook.

Was this reply helpful? Yes No
AM-29051822-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

What I mean is that the file structure is not loading, I can't even go find a file. Nothing loads at all.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@AM-29051822-0,

Where is the file stored (OneDrive or SharePoint) and can you see and open it directly in Excel with the same account permissions you are using in Power Apps. Also does it have a valid Table you can see in Name Manager in Excel ?

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AM-29051822-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No