You’re offline. This is a read only version of the page.
18
Hi,
I'm using the Leave Request App. By default the datasource is an Excel in OneDrive. My question is if I could move this Excel to Sharepoint and it continues being the datasource.
@Sandritto What field type in SP did you have to use to get the data to populate?
Hi @v-xida-msft,
I tried, I created 3 different SP lists with the same data structure as the Excel and next thing you know everything full of errors...
Hi @Sandritto,
You could change your Excel table data source to a SP list. But the data structure of the SP list must be defined the same as that within the Excel table data source.
In other words, the SP list must have same data structure (same columns) with the Excel table data source.
Best regards,
Kris
Hi @Sandritto,
Do you want to move the Excel table data source from your OneDrive to your SP library, then connect your app to the Excel table stored in your SP library?
Currently, within PowerApps, we could not use a Excel file stored within SP library as a data source in an app.
If you want to move the Excel table data source from your OneDrive to your SP library, then connect your app to it, I afraid that there is no way to achieve your needs in PowerApps currently.
If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
Best regards,
Kris
#1
Michael E. Gernaey
9
Super User 2025 Season 1
#2
bscarlavai33
5
Super User 2025 Season 1
#3
getsplash
2
Share
Report
All responses (
Answers (
