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
