Error loading data source

(0) Share

Report

Posted on by sr12

125

Hello,

I have created an app using two excel tables in one drive as the data source. When I shared the app with other users the data sources couldn't load as it said "Table X failed to load etc". I tried refreshing the data sources but still it didn't work. Is there a way to fix this?

I read that switching to SharePoint is much better. Is there a way to replace my existing excel data source to SharePoint without affecting the existing data and repeating the whole app?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey! Make sure that you shared the Excelwith the other ones. Plus, you can chnage the datasorce but you will have to re-check if the forms are okay, you have to change the Itens in gallerys, etc

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sr12 ,

First did you checked users have access to the files ?
For sharepoint try making the schema as it is in excel and add the sharepoint data source and update the datasource name and column names in the apps.

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.

Was this reply helpful? Yes No