Dataverse For Teams - Import Excel Spreadsheet Data

In this episode I demonstrate how import data into your Dataverse for Teams table from an Excel Spreadsheet.

LinkedIn Post: LinkedIn: power-query-teams-import-excel-keith-craigo

Timestamps:
00:00 - Pin Power Apps Button to the Teams panel
01:30 - Why am I here?
02:30 - Select Data Table view
03:10 - Select Tables Link
03:20 - Power Query
04:00 - One Drive-connect to Excel csv file
04:32 - Load the source data
04:50 - Shape the source data
06:00 - Tip #1
06:35 - Tip #2
08:06 - Be patient after publish
09:49 - Data populates
11:07 - Import vs Data Entry
11:45 - RANT ALERT! Why not use the Microsoft Excel Add-in?
12:25 - Why use a DB, why not keep the data in Excel?
13:42 - Wrap it Up!



--------------------------------------------------------------------

Disclaimer: I am not affiliated with any company nor entity mentioned in this video unless specifically stated.
All opinions are my own!

Blog Post: https://www.kcraigo.com/post/powerpla...

🔔 Please Consider Subscribing To My Channel:  
https://www.seevid.ir/c/kcraigo?sub_...

Other Playlists:

PowerApps
✅. Video

Tech Videos
✅. Video


Share this video: Dataverse For Teams - Import Excel Sp...

Twitter: @keithcraigo
gitHub: https://github.com/kcraigo
Blog: https://www.kcraigo.com/

#powerapps #powerappsforteams #dataverse #dataverseforteams #powerquery #importexcel

• #science_technology
• #powerapps
• #dataverse
• #power_query
• #dataverse_for_teams
• #power_apps_for_teams
• #microsoft_teams
• #msteams
• #sharepoint_o365
• #excel