How to import excel in to powerapp

(0) Share

Report

Posted on by Community Power Pla...

Hi Mates,

Can we import excel in to powerapps ..?

example : Button click

open a form to select excel, then read columns and column values in powerapp

Yes, its not read excel data via dataSource.

By any chance can we achieve this requirement in powerapps...?

kindly guide me.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,
If you mean select an Excel file and import the data, then no, this cannot be done.
You can connect an Excel file in OneDrive as a data source, but this may not be what you are asking.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report
In importing excel into your app, I assume you mean a static excel data. (Non static mean connecting with the excel such that when you update the excel, it automatically updates in Powerapps)
Consider these steps:
In your Powerapps, GOTO View--Datasource Connection
In your Excel sheet, Create a Properly formatted excel Table inside the excel sheet covering where your excel data is located
To Import, Import from excel to pick the excel file data in powerapps.
To view the data, you can create a Collection or Use the TableName created in step 2 on a Gallery
For Dynamic Connection of your excel in onedrive in your Powerapps, follow this video:
https://youtu.be/-Z_13J02RPU?t=210

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

import.JPG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

Yes ish this can be done. I had a similar use case.

You cannot link Excel directly to your PowerApp but if you can create SharePoint list from an Excel Table. Then create a Microsoft Flow that will push updates to that SharePoint list when lines are updated or new entries are created.

You can then reference that Excel driven SharePoint list in your PowerApp.

Great article here on creating the Flow if you need a helping hand.
https://jamiemcallister.com/upload-update-excel-values-to-sharepoint-list/

Hope that helps 😊

R

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @eka24,

They just want to browse and select excel file then open the selected excel file in powerapp.
Users can not go though the dataSource option.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Anonymous ,

with the referance link i just learned one new thing here,
but instead of uploading in to sharepoint, is there any chance to load/update in to sql Table ...?
Actually they want to update from excel to SQL Table only.

Was this reply helpful? Yes No
mogulman 764 on at

Like (0)

Report

I've been confronted with with loading Excel data to a database probably a dozen times over the last 20 years. The overall solution varies based on requirements but I almost always create an Excel VBA addin (.xlam). The addin will check the data to make sure it is valid. If it is an on-premise server like SQL Server Excel can easily connect to it and load the data directly. I also have used Oracle and MySQL. You can also easily connect to Azure SQL DB but you must register IP address in Azure. For large international organizations I found having the addin FTP the user workbook to a central site and having a cron check every few minutes then upload data. You an also setup a website and have user manually upload workbook. A cron job can upload data from web server.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @eka24 , may i know if it is possible to update an existing gallery in powerapp based on the new excel I have imported? I have followed until step 3.
For my project, please refer to below image.

Was this reply helpful? Yes No
MarcSigrist 20 on at

Like (0)

Report

Please check out my blog post on this topic, where I present a solution for that. https://www.linkedin.com/posts/marc-sigrist-89b87b105_power-apps-let-users-import-data-from-excel-activity-7109256813643997184-jSek?utm_source=share&utm_medium=member_desktop

Does this help?

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Hi @MarcSigrist ,
Did try to access the link mentioned above but it was no longer available (content), I have a similar requirement could you check the following post:
My Post

Regards,
Sidhant.

Was this reply helpful? Yes No
MarcSigrist 20 on at

Like (1)

Report

Hi @Sidhant_02
Thank you for your message and sorry the link was not working.
Here is the link to my blog post: Power Apps: Let users import data from Excel (powerfully.ch)

Please let me know, if it helps.
Marc

Was this reply helpful? Yes No