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
@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.
User | Count |
---|---|
183 | |
106 | |
89 | |
44 | |
43 |
User | Count |
---|---|
226 | |
108 | |
106 | |
68 | |
67 |