cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
techuvise
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
v-yutliu-msft
Community Support
Community Support

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
v-yutliu-msft
Community Support
Community Support

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.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,288)