Is it possible to upload A Excel to PowerApps via the Upload Control and create A collection with the Table in the Excel file?
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.
ShowColumns(NameOfExcelTable; "Column1";"Column2";"Column3" )
Please take this as an answer if it works.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.