To create a form to upload an Excel file to a Power App that updates an existing Dataverse table, you can follow these steps:
- Sign in to Power Apps.
- From the home screen, select Start with data > Create from data > Dataverse.
- Select the table you want to update and click Connect.
- From the Fields tab, select the fields you want to include in your form.
- Click Form and select Edit.
- From the Data tab, select Add field and choose File.
- From the Advanced tab, select OnAddFile and enter the following formula:
Patch(Table1, Defaults(Table1), {Filename: ThisItem.DisplayName, FileContent: ThisItem.'$content'})
- Save your form and publish it.
The real-life process for setting this up is not intuitive and by no means straightforward. I’ve had difficulties getting it working for my Model-driven app. I will update this article with more information and details as I figure out how to make this work more efficiently.
