cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
greggpowell
Helper II
Helper II

How to import excel spreadsheet into a dataverse table?

Looking for the Best instructions or better yet - youtube video on how to take existing excel .xlsx spreadsheets - there are 4 - and then import them into Dataverse as tables for use in a power app. Each of the 4 spreadsheets (Dataverse tables) will all be tied to the same power app. Right now, the plan is to use a power app per app license on top of a Business standard M365 license.  

 

Thanks in advance.

 

r/

Gregg

AZ

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

Hi @greggpowell ,

From your description, I know that you want to create four tables based on four Excel file.

I would suggest you use the "Get Data from Excel" function to import your Excel file into a Dataverse table. 

v-albai-msft_0-1623231705745.png

You can refer to below articles for more detailed information:

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-import-export 

https://powerapps.microsoft.com/en-us/blog/cds-for-apps-excel-importexport/ 

 

Besides, for your needs, it is enough to use the per app license, since you want to use these four tables inside a same app.

Note: The per app license gives a user access to two Power Apps and one portal for a single environment. If you want to create more than 2 apps inside a same environment, you need to buy another per app license or consider to change to the per user license.

v-albai-msft_1-1623232333639.png

v-albai-msft_2-1623232402115.png

 

Best regards,

Allen

View solution in original post

1 REPLY 1
v-albai-msft
Community Support
Community Support

Hi @greggpowell ,

From your description, I know that you want to create four tables based on four Excel file.

I would suggest you use the "Get Data from Excel" function to import your Excel file into a Dataverse table. 

v-albai-msft_0-1623231705745.png

You can refer to below articles for more detailed information:

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-import-export 

https://powerapps.microsoft.com/en-us/blog/cds-for-apps-excel-importexport/ 

 

Besides, for your needs, it is enough to use the per app license, since you want to use these four tables inside a same app.

Note: The per app license gives a user access to two Power Apps and one portal for a single environment. If you want to create more than 2 apps inside a same environment, you need to buy another per app license or consider to change to the per user license.

v-albai-msft_1-1623232333639.png

v-albai-msft_2-1623232402115.png

 

Best regards,

Allen

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Users online (1,719)