cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RonHappel
Resolver I
Resolver I

Failed to read meta data from file source

Hi,

 

I've granted access rights to a guest user.

The app works fine, however the datasource doesn't.

It's an Excel workbook with 8 tables in it. It's located on my OneDrive for Business.

I've granted read/write access to the excel workbook as instructed by Microsoft:

https://docs.microsoft.com/nl-nl/powerapps/maker/canvas-apps/share-app-data

 

When the guest users opens the app the first screen is presented and then:

"Failed to read metadata from file source ......". It seems that each time the message refers to different tables.

 

I'm reading a lot about this problem, but I don't read a solution.

PLease, does anybody have an idea?

Thanks a lot.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @RonHappel ,

Did you read this issue?

https://powerusers.microsoft.com/t5/Connecting-To-Data/excel-getrows-on-created/td-p/19336

Someone has chosen the same solution like you listed to solve this problem.

I'm very glad you've solved your problem!

If you do not have any other problems ,could you change your issue's status to "Answered"?

 

Thanks!😁

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
RonHappel
Resolver I
Resolver I

It seems a Onedrive for Business issue/limitation. 

I've converted my Excel workbook to sharepoint lists

I don't have the problem anymore. 

 

Hi @RonHappel ,

Did you read this issue?

https://powerusers.microsoft.com/t5/Connecting-To-Data/excel-getrows-on-created/td-p/19336

Someone has chosen the same solution like you listed to solve this problem.

I'm very glad you've solved your problem!

If you do not have any other problems ,could you change your issue's status to "Answered"?

 

Thanks!😁

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mattie021
Frequent Visitor

I have the same error although this only occurs while in incognito mode. 

@v-yutliu-msft  I didnt understand how the File Identifier from Flows, can be used in the Powerapps File Path for the excel with the Table. Having the same issue but could not see the solution in place.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,709)