How to import data from powershell to dataverse for teams?

[Alan2022]

How to import data from powershell to dataverse for teams? Thanks.

[rampprakash · Accepted solution]

Hello @Alan2022 

Hope you are doing good, Please find this Link for Your Reference.

https://www.aegissofttech.com/articles/use-microsoft-powershell-extensions.html

You can easily use Export and Import Solution option too.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

[Alan2022]

Hi @rampprakash 

I think this is possible. I will do a test for this.
Thank you for the support.
Keep up the good job. 😁

[Alan2022]

Hi @rampprakash 
Its works. Thank you very much.

# Online - use oAuth and XrmTooling Ui by providing your UPN and the enviroment url
connect-crmonline -Username "user@domain.com" -ServerUrl <orgurl>.crm.dynamics.com

ServerUrl = Instance URL.

[Alan2022 · Accepted solution]

REMINDERS: Don't use TABLE DISPLAY NAME & COLUMN DISPLAY NAME.

Custom Table
Name: cree3_tb_vm

Column Name
cree3_vmname, cree3_ipaddress, cree3_vmsize, cree3_number

# Install-Module Microsoft.Xrm.Data.PowerShell -Scope CurrentUser
# Update-Module Microsoft.Xrm.Data.PowerShell -Force

# User Authentication
$ua = Get-StoredCredential -Target <SERVER>
$credential = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $ua.UserName,$ua.Password

# Returns a connection to a Microsoft Dynamic CRM instance.
$conn = Get-CrmConnection -ServerUrl <INSTANCE URL> -Credential $credential -OrganizationName <OrgName>

# Create a record
$vmuid = New-CrmRecord -conn $conn -EntityLogicalName cree3_tb_vm -Fields @{"cree3_vmname"="vm01";"cree3_ipaddress"="192.168.1.2";"cree3_vmsize"="Dsv3";"cree3_number"="123"}

# Display the uid
$vmuid

# Retrieve a record
$vminfo = Get-CrmRecord -conn $conn -EntityLogicalName cree3_tb_vm -Id $vmuid -Fields cree3_vmname, cree3_ipaddress, cree3_vmsize, cree3_number

# Display the record 
$vminfo