Step 4 - Import data into Dataverse tables

To import data into the Dataverse tables, perform the following steps:

  1. Download the Yume Card Data V3 initial content CSV file from the VivaSolutions GitHub repository if not already downloaded as part of the prerequisites.

  2. Sign in to https://powerapps.microsoft.com and select the environment to which you'll be deploying the CSV file.

  3. On the left navigation pane, select Dataverse > Tables.

    The page on which we select Dataverse and Tables options

    The page listing the Dataverse tables is displayed.

    The page listing the Dataverse tables

  4. Find the Yume Cards table using the search box as shown in the following screenshot.

    The search box using which the user can find the Yume table

    The Yume Cards table is displayed.

  5. Open the Yume Cards table by selecting the three-dotted option and then selecting Open.

    The page from which the user can launch the information of the Yume Cards table

    The screen containing information of Yume Cards is displayed.

    The page from which we can select Import > Import data from Excel

  6. Select Import > Import data from Excel. The page as shown in the following screenshot is displayed.

    The Import data pane

  7. Select Upload. A dialog box listing files and folders are displayed.

    The dialog box listing files and folders that the user can select to upload

  8. Select the YumeCardDataV3_initialcontent.csv file. This selected file is displayed in the File box as shown in the following screenshot.

    The page on which the file to be uploaded is displayed in the File box

  9. Select Map columns on the far-right side of the page. The column mapping page is displayed, as shown in the following screenshot.

    Column mapping

  10. Select Save changes on the top right. You return to the Import data pane, as shown in the following screenshot.

    The Import data pane on the right side of the page

  11. Select Import on the top right. A notification message denoting a successful import is displayed, for example, the following screenshot.

    The notification that the import has been completed successfully