Migrate Excel data source file from one drive to Sharepoint

(0) Share

Report

Posted on by TheGallons

Hi All,

I completed my first Powerapps application based on an Excel File created in my One Drive Cloud.

This application will be used to create a New Release Schedule product with som validation steps, automatic email info etc etc. This app should be used from more than 20 users.

I don't want to share my One Drive file to each user and the better thing is to move the file excel to Sharepoint Cloud that is already shared to all business users.

I tried to create a Sharepoint List with the same fields name but when I change the data source on my app, all fields features, aspect and settings has lost.

Do you have some suggestion to move the data source without made big changes in my app?

Thanks a lot

Davide

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

There really is no way to easily do what you are describing. If you change the connection it will invalidate a lot of the dynamic content you are using. So you will have to go back and fix it.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report

Hi @TheGallons ,

Do you want to export excel file to sharepoint list?

Actually, you do not need to create a new sharepoint list. In excel, it already has the function of "export to sharepoint list". Then it will automatically generate a new list stored the data of the excel file.

Firstly, you need to download this excel file. Only excel in local has this function.

Secondly, please format your data as a table.

Thirdly, choose this table, in the design pane, select export.

Click "export to sharepoint list"

Then, the data will be exported to sharepoint list.

Best regards,

Was this reply helpful? Yes No