Why can't users access my PowerApp, Flow, Datasource properly?

[gerrysr6omfg]

I have a PowerApp that uses a spreadsheet on my business onedrive as a datasource. I have shared both with two users, but their access is completely random. The first user had no problems for a while, but now can could no longer access the datasource. The second user has never been able to access the app at all, even though I shared the app/datasource in the same way. Both users have full licenses for everything Microsoft. Nothing changed between having or not having access. Like I say, it's like it's completely random whether or not users have access. What is going on?

[gerrysr6omfg]

I gave full control of everything to both users and one user still cannot access the datasource. While editing the power app they see:

No idea why they do not have access.

[iAm_ManCat · Accepted solution]

Hi,

It looks like you have stored the data on your OneDrive for Business - I would recommend instead storing this on an actual SharePoint site within a library - the tenant-my.sharepoint.com/personal indicates that OneDrive for Business storage was used, and although you may have shared this directly with them, the OneDrive shared items can be difficult to get working - there is a likely a security setting on your tenant that removes shared access for OneDrive after a length of time or limits access in other ways

Cheers,

Sancho

[gerrysr6omfg]

We have added a SharePoint site with a documents folder and a data folder and put the xlsx into that folder. But I cannot access from my app. The instructions at https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-sharepoint-onl... are out of date.

I tried "Add Data", SharePoint, then enter the URL (I used Copy Link to get the URL) and Connect and it says:

This is the same file I had on my onedrive that was working. Some kind of permissions thing somewhere?

Also I tried to add a SharePoint Sites (site) and I can see my folder but not the file.

[gerrysr6omfg]

Apparently you can't just drop an excel file into SharePoint, you have to go through an add List process