Import Excel Data to Dataverse Table

Customers want to create Employee Information and Import Excel Data to Dataverse Table in Model Driven APP

High level resolution steps

· Import Data to Excel or .CSV file

Detailed resolution steps

Step 1: Create Excel File

Import Excel Data

Step 2: Save As File .CSV

Step 3: Go to the Power Apps à Select Environment

Step 4: Select Tables à Create with Excel or .CSV file

Step 5: Click à Select from Device

Step 6: Select Excel or .CSV File

Step 7: Edit Table Name or Edit Table Properties

Step 8: Click Use First Row as a Column Header

Step 9: Click à Create

Step 10: Excel File Add to Dataverse Table

Output: