cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Powerapps import Excel with the Upload Control

Hello All,

 

Is it possible to upload A Excel to PowerApps via the Upload Control and create A collection with the Table in the Excel file?

 

 

Thanks

1 REPLY 1
Microsoft
Microsoft

@Anonymous ,

 

Firstly you should connect to your Excel Data from your app:

1. click -> “Connect to Data” to create a connection, choose a connection where you save the excel, for example “one drive for business” or "Excel Online".

 

2. Then choose the Excel file from where you want to fetch the data

 import the data from Excel into a collection using the following function. 

ClearCollect(NameOfCollection;
             ShowColumns(NameOfExcelTable; 
"Column1";"Column2";"Column3"
) )

 

Please take this as an answer if it works.

 

 

 

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (74,483)