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

How to read/import and write/export from and to user supplied excel file during run time?

My use case is that during run time I want to have my powerapps app to ask end user for the name of the excel file so my app can read/import and write/export from and to this excel file.

There are alot of post on importing and exporting excel file as data source during development time.  It even has the ability to create a new powerapps app from excel file.  But, what I need is same or similar capabilities during runtime instead of development time.  There are two buttons "Import Excel File" and "Export Excel FIle" during development time but can I expose that during runtime so the end user can inport and export excel file?  Any  other ways to implement this feature?

Thank You,

Please help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to read/import and write/export from and to user supplied excel file during run time?

Hi @techuvise ,

I'm afraid it's not supported to make this currently in PowerApps.

For now, PowerApps has only two controls about uploding file: Import and Attachments.

Import is used to upload the file that is exported by PowerApps (.msapp file).

Attachments os used to upload file to SharePoint list and Common Data Service entities.

However, you could not update data of the attached file in SharePoint list and Common Data Service entities currently.

So, I think both of them not meet your demands.

You could only connect with Excel file in the process of development.

Then, you could update the data of the Excel file when using the app.

About the function of creating connection with Excel when running app, I suggest you express your views on PowerApps Ideas Forum. Your precious advice will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
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
Highlighted
Community Support
Community Support

Re: How to read/import and write/export from and to user supplied excel file during run time?

Hi @techuvise ,

I'm afraid it's not supported to make this currently in PowerApps.

For now, PowerApps has only two controls about uploding file: Import and Attachments.

Import is used to upload the file that is exported by PowerApps (.msapp file).

Attachments os used to upload file to SharePoint list and Common Data Service entities.

However, you could not update data of the attached file in SharePoint list and Common Data Service entities currently.

So, I think both of them not meet your demands.

You could only connect with Excel file in the process of development.

Then, you could update the data of the Excel file when using the app.

About the function of creating connection with Excel when running app, I suggest you express your views on PowerApps Ideas Forum. Your precious advice will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,558)