cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seccard
Level: Powered On

Random Error on data access

Capture.PNGSome Users get this message and others don't the file is an excel file with several tables hosted on one drive for business, I am at a loss on how to fix 3 users out of ten get this message.  Thanks in advance.

5 REPLIES 5
PowerApps Staff Mr-Dang-MSFT
PowerApps Staff

Re: Random Error on data access

Hi @seccard, have you shared the excel file with the 3 users?

seccard
Level: Powered On

Re: Random Error on data access

Yes I have shared with all users in my organization 

WI-User-01
Level: Powered On

Re: Random Error on data access

I was also seeing this error very frequently. It was random, not everyone would get the error, but...  

 

I had shared the entire folder that the Excel file instead of the actual Excel file.  You need to explicitly share the file, not the folder to your users (sharing the folder might still be needed, depending on your app, so don't unshare).

 

Here's the URL that states this:

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

Capture.JPG

 

 

 

 

 

For me, once I went in and reshared the individual file, I stopped hearing about the error popping up for users.

Hope that helps.

Highlighted
Community Support Team
Community Support Team

Re: Random Error on data access

Hi @seccard,

Do you share the file itself or the File Folder that contains the file to your users?

Are these 3 users internal users within your Org or external users?

I agree with @WI-User-01's  thought almost. Please check if you have shared the Excel file itself rather than the File Folder to your users.

Please also take a try to re-share the Excel file to the 3 users individually, then try your app again, check if the issue is solved.

In addition, please also consider ask the 3 users to re-create a connection to the OneDrive for Business connector within your shared app, then try it again, check if the issue is solved.

 

Best regards,

Kris 

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

Re: Random Error on data access

Hi @seccard are you still receiving this error? If so, please review the information provided by @WI-User-01 and @v-xida-msft and advise if it solves your issue. 

 

@TopShelf-MSFT

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 323 members 5,564 guests
Please welcome our newest community members: