Unanswered

Issue with OneDrive for Business to PowerApps

(0) Share

Report

Posted on by Lukescotr

Hello!

I have been having an issue where I connect my excel from OneDrive for Business to PowerApps. It works wonderfully until I edit the data in the excel in the OneDrive. The data connect is lost and I got to reconnect it and it says the data cannot be found. Currently, I'm building a new app each time, I would love to hear if there is a way to fix it.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

eisuan 146 on at

Like (0)

Report

@Lukescotr
If someone is editing excel file it get's locked.
I would susggest you use SharePoint list instead of excel file.
You can make Automated flow that sync your excel file with SharePoint list.
This way you won't have issues you have now.

Was this reply helpful? Yes No
Lukescotr 6 on at

Like (0)

Report

@eisuan thanks for your reply! I have been using OneDrive for Business over SharePoint because I am able to keep to the file more confidential. My issue is that with SharePoint people can find the file that's been shared with them. With the excel on OneDrive, even though I share it with them, I can turn the data white and protect the sheet.

The only issue still is that when I edit the data and then try and refresh or reconnect the data to the PowerApp it does not connect, and I have to create a new app.

Was this reply helpful? Yes No