Upload Excel file from PowerApps to SharePoint List
Budget: $10 – $30 CAD
Hello,
Create a Power App in tablet mode that will have 6 fields to be entered in a canvas with a file upload button. The manual fields data will be imported into the SharePoint List and all the data in the attached file (Simple DailySiteActivity) will be imported into the same SharePoint list upon Submit. I would like to upload the attached excel file inside of a folder in SharePoint and have all data imported to an existing SharePoint List to be stored along with the data from the attached file.
The tricky part will be grabbing the row data and placing it into the SharePoint List. When the upload with manual entries is submitted to the SharePoint List, I want the excel files in the folder on SharePoint to automatically delete after 30 days.
Thanks
Create a Power App in tablet mode that will have 6 fields to be entered in a canvas with a file upload button. The manual fields data will be imported into the SharePoint List and all the data in the attached file (Simple DailySiteActivity) will be imported into the same SharePoint list upon Submit. I would like to upload the attached excel file inside of a folder in SharePoint and have all data imported to an existing SharePoint List to be stored along with the data from the attached file.
The tricky part will be grabbing the row data and placing it into the SharePoint List. When the upload with manual entries is submitted to the SharePoint List, I want the excel files in the folder on SharePoint to automatically delete after 30 days.
Thanks