Data only displayed from local source but doesn't display from OneDrive (Same Functions/Data)

[Moorjani]

I'm fairly new to PowerApps, and i've ran into an issue I can't seem to find a solution to. My goal is to take information saved on an excel sheet and translate that to PowerApps.

I ended up making a working version of the application, a simple search box that looks through 500+ entries and filters client results/info which is then editable from another window within the app. These edits reflect back on to the original excel document, so 0 problems there.

When I try to translate the application from a local data source to OneDrive (Same exact document, different locations) since i'd want the related department to be able to make edits and have those edits reflect on the shared document, no data displays. 

I can't take a screenshot since the data is client information, but would there be any reason as to why the application works perfectly if the source is local vs on OneDrive? After adjusting the formulas to accomodate new column names ("Account Name" vs "Acount_x0200_Name"), they don't report any issues, but the issue of no displayed data persists. 

[RandyHayes]

@Moorjani 

Can you describe what you mean by "Local Source".  When you are using an Excel file as a datasource, it has to reside in your OneDrive for Business files.

If you are going to move the datasource around, you will most likely need to remove the DataSource within PowerApps and then add it back - pointing to the new location.

I hope that helps shed some light for you.  Post back if you're having problems.

[Moorjani]

Hey @RandyHayes,

When I say local, i mean an excel document located on my desktop. I'll create an application from this excel document and everything works out fine. When i transfer the same excel document to onedrive and create an application linking to that document in onedrive, nothing displays. Same document, same PowerApps format, same functions (with edited names, since the colum names change when linking from onedrive to powerapps). 

[RandyHayes]

@Moorjani 

Can you describe to me the steps you take to make a functioning read/write PowerApp from an Excel file on your desktop?

To the best of my knowledge, you must use an Excel file located in a cloud storage location.

[Moorjani]

@RandyHayes 

From a blank application, i'm able to click add data and select documents on my desktop. I feel like that might be the cause of the problem, but i just don't understand why an application would work in that situation, but an exact copy linking to a document in OneDrive wouldn't display the same information.

[RandyHayes]

@Moorjani 

Ah...gotcha.  

Please review your process again.  What you were clicking on was (most likely) "Import from Excel"

You will notice that this states "Add static data to your app".  

This kind of data source is a read-only static import.  It cannot be shared as a database-style solution.

What you need to do is to put the Excel file in your OneDrive, then add a Connector in PowerApps to OneDrive.  When you do that, it will ask you for the Excel file that you want to connect to.

As for sharing that, you'll need to make sure that anyone that needs to use the App will have full access to the file in your OneDrive.

[Anonymous]

Thanks for posting in the community @Moorjani - can you review the above reply and update the thread if it was helpful?

Thank you,

@Anonymous