Import a File Template to Dataset in Power Apps.

1. Prepare the file template.

   a. Export the table data to the CSV file. Follow the steps in Export data to CSV.
   b. Define a plan to make sure data is unique. Use either primary keys or Alternate Keys.
   c. Refer to the next section for instructions to make sure data is unique before you import it into a table.

2. Modify the file with your data.

   • Copy data from your Excel or CSV file into the template that you just created.

3. Import the file.
   a. On powerapps.com, expand the Data section. Select Tables in the left navigation pane.
   b. Select the table that you want to import data into.
   c. Select the ellipsis or menu at the top. Select Get Data. Select Get data from Excel.

   Note

   To import data into more than one table, in the top menu, select Get Data. Select Get data from Excel. Then you can choose multiple tables and select Next.

   

   d. On the Import data screen, choose whether to import data from an Excel or a CSV file.
   e. Select Upload.
   f. Choose your file. Follow the prompts to upload your file.

   g. After the file is uploaded and Mapping status is green, select Import in the top-right corner. Refer to the next section to navigate and fix any mapping errors.

   h. After the import finishes successfully, you'll see the total number of inserts and updates.

   Note

   Use the Upsert (Update or Insert) logic to either update the row, if it already exists, or to insert a new row.