cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
winwell
Frequent Visitor

How to utilise same excel data source on a second user's oneDrive after exporting & importing PowrApp package

I have finished building an App using excel as data source on my One drive.

 

I now need to install everything on the main user's account as they will be maintaining it going forward.

 

I exported the PowerApp fine and he imported it on his account okay.

 

I emailed him the excel file and he uploaded it to his OneDrive for Business but when he tries to addd a new data source to the excel file on HIS One Drive, the excel file is not visible within PA.

 

Other excel files display okay so it must be something to do with the excel file itself.

 

Has anyone experienced this before? Any ideas on how to get the imported app to use the new data source and make that excel file visible?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @winwell ,

 

Please let the user open the excel file from his OneDrive for Business, and make sure that the data has been formatted as a table. If not, please format data to an excel table, then try to add this table as data source in the imported app again. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-monli-msft
Community Support
Community Support

Hi @winwell ,

 

Please let the user open the excel file from his OneDrive for Business, and make sure that the data has been formatted as a table. If not, please format data to an excel table, then try to add this table as data source in the imported app again. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,068)