Isystem.PowerShell.PowerPlatform.Dataverse
1.3.0
Minimum PowerShell version
7.5
Installation Options
Owners
Copyright
(c) Isystem. All rights reserved.
Package Details
Author(s)
- Ondrej Kracmar
Tags
Dataverse PowerPlatform Dynamics365 CRM PowerApps Upsert Windows Linux MacOS
Cmdlets
Connect-PSDataverse Disconnect-PSDataverse Get-PSDataverseConnection Get-PSDataverseRecord Get-PSDataverseRecordCount Get-PSDataverseTable Get-PSDataverseColumn Get-PSDataverseKey New-PSDataverseTable New-PSDataverseColumn New-PSDataverseKey New-PSDataverseLookup ConvertTo-PSDataverseObject Find-PSDataverseRecord Test-PSDataverseRecord New-PSDataverseRecord Set-PSDataverseRecord Remove-PSDataverseRecord Invoke-PSDataverseBatch Invoke-PSDataverseTransaction Invoke-PSDataverseFetchXml Get-PSDataverseTokenCache
PSEditions
Dependencies
This module has no dependencies.
Release Notes
## [1.3.0] - 2026-09-30
### Added
- **`New-PSDataverseTable`, `New-PSDataverseColumn`, `New-PSDataverseKey` and
`New-PSDataverseLookup`.** The module could read metadata and not write it, so every table a
script wanted to fill had to be built by hand in the maker portal first - for a mirrored model
that is a table, an alternate key, a soft-delete flag and a column per property, times eight
entities, with every typo surfacing later as a rejected row.
- **`-Wait` on `New-PSDataverseKey`.** An alternate key's unique index is built asynchronously, so
the request returning does not mean the key works; until the index reports Active an upsert
through it fails with a message that never mentions the index. `-Wait` polls until it is Active,
backing off as it goes, and says so plainly when the index fails - a duplicate in the existing
rows being the usual reason.
- **`-SolutionUniqueName` on all four.** Without it Dataverse puts the new component in the
Default solution, where it works but cannot be exported cleanly - discovered much later, when
someone tries to move the tables to another environment and finds there is nothing to move.
- `New-PSDataverseLookup` names the relationship explicitly. A lookup is a one-to-many
relationship and the column appears as a side effect; the relationship's schema name is what the
Web API navigation property and `@odata.bind` are built from, which is the detail that trips
people up when they hand-write OData.
### Fixed
- **The help for `Get-PSDataverseTable -IncludeSystem` said something untrue.** It claimed that
without the switch "only custom tables are listed", but the filter is `IsCustomEntity`, which
means "did not come with the base platform" rather than "you made it". Every table installed by
any solution passes - Microsoft's first-party ones included (`msdyn_`, `mspp_`, `adx_`) - so on
a tenant with apps installed hundreds of unrelated tables come back. The help now says so and
points at filtering by publisher prefix.
- `New-PSDataverseColumn` takes `-MaxLength` and `-Precision` as plain integers rather than
nullables, which surfaced in help as `Nullable\`1`. Whether one was supplied is read from
`BoundParameters`, so a legitimate `-Precision 0` stays distinguishable from not passing it.
FileList
- Isystem.PowerShell.PowerPlatform.Dataverse.nuspec
- CHANGELOG.md
- Isystem.PowerShell.PowerPlatform.Dataverse.Format.ps1xml
- Isystem.PowerShell.PowerPlatform.Dataverse.psd1
- Isystem.PowerShell.PowerPlatform.Dataverse.psm1
- LICENSE
- README.md
- bin\net10.0\Azure.Core.dll
- bin\net10.0\Azure.Identity.Broker.dll
- bin\net10.0\Azure.Identity.dll
- bin\net10.0\Isystem.AzAuth.Core.dll
- bin\net10.0\Isystem.PowerShell.PowerPlatform.Dataverse.dll
- bin\net10.0\Isystem.PowerShell.PowerPlatform.Dataverse.pdb
- bin\net10.0\Isystem.Shared.Infrastructure.Core.dll
- bin\net10.0\Isystem.Shared.Infrastructure.PowerPlatform.Dataverse.dll
- bin\net10.0\Microsoft.Bcl.AsyncInterfaces.dll
- bin\net10.0\Microsoft.Crm.Sdk.Proxy.dll
- bin\net10.0\Microsoft.Extensions.Caching.Abstractions.dll
- bin\net10.0\Microsoft.Extensions.Caching.Memory.dll
- bin\net10.0\Microsoft.Extensions.Configuration.Abstractions.dll
- bin\net10.0\Microsoft.Extensions.Configuration.Binder.dll
- bin\net10.0\Microsoft.Extensions.Configuration.dll
- bin\net10.0\Microsoft.Extensions.DependencyInjection.Abstractions.dll
- bin\net10.0\Microsoft.Extensions.DependencyInjection.dll
- bin\net10.0\Microsoft.Extensions.Diagnostics.Abstractions.dll
- bin\net10.0\Microsoft.Extensions.FileProviders.Abstractions.dll
- bin\net10.0\Microsoft.Extensions.Hosting.Abstractions.dll
- bin\net10.0\Microsoft.Extensions.Http.dll
- bin\net10.0\Microsoft.Extensions.Logging.Abstractions.dll
- bin\net10.0\Microsoft.Extensions.Logging.dll
- bin\net10.0\Microsoft.Extensions.ObjectPool.dll
- bin\net10.0\Microsoft.Extensions.Options.dll
- bin\net10.0\Microsoft.Extensions.Primitives.dll
- bin\net10.0\Microsoft.Identity.Client.Broker.dll
- bin\net10.0\Microsoft.Identity.Client.Extensions.Msal.dll
- bin\net10.0\Microsoft.Identity.Client.NativeInterop.dll
- bin\net10.0\Microsoft.Identity.Client.dll
- bin\net10.0\Microsoft.IdentityModel.Abstractions.dll
- bin\net10.0\Microsoft.IdentityModel.JsonWebTokens.dll
- bin\net10.0\Microsoft.IdentityModel.Logging.dll
- bin\net10.0\Microsoft.IdentityModel.Tokens.dll
- bin\net10.0\Microsoft.PowerPlatform.Dataverse.Client.dll
- bin\net10.0\Microsoft.VisualStudio.Threading.dll
- bin\net10.0\Microsoft.VisualStudio.Validation.dll
- bin\net10.0\Microsoft.Xrm.Sdk.dll
- bin\net10.0\Newtonsoft.Json.dll
- bin\net10.0\System.ClientModel.dll
- bin\net10.0\System.Configuration.ConfigurationManager.dll
- bin\net10.0\System.Diagnostics.EventLog.dll
- bin\net10.0\System.IdentityModel.Tokens.Jwt.dll
- bin\net10.0\System.Memory.Data.dll
- bin\net10.0\System.Runtime.Caching.dll
- bin\net10.0\System.Security.Cryptography.Pkcs.dll
- bin\net10.0\System.Security.Cryptography.ProtectedData.dll
- bin\net10.0\System.Security.Cryptography.Xml.dll
- bin\net10.0\System.Security.Permissions.dll
- bin\net10.0\System.ServiceModel.Duplex.dll
- bin\net10.0\System.ServiceModel.Http.dll
- bin\net10.0\System.ServiceModel.Primitives.dll
- bin\net10.0\System.ServiceModel.Security.dll
- bin\net10.0\System.ServiceModel.dll
- bin\net10.0\System.Windows.Extensions.dll
- bin\net9.0\Azure.Core.dll
- bin\net9.0\Azure.Identity.Broker.dll
- bin\net9.0\Azure.Identity.dll
- bin\net9.0\Isystem.AzAuth.Core.dll
- bin\net9.0\Isystem.PowerShell.PowerPlatform.Dataverse.dll
- bin\net9.0\Isystem.PowerShell.PowerPlatform.Dataverse.pdb
- bin\net9.0\Isystem.Shared.Infrastructure.Core.dll
- bin\net9.0\Isystem.Shared.Infrastructure.PowerPlatform.Dataverse.dll
- bin\net9.0\Microsoft.Bcl.AsyncInterfaces.dll
- bin\net9.0\Microsoft.Crm.Sdk.Proxy.dll
- bin\net9.0\Microsoft.Extensions.Caching.Abstractions.dll
- bin\net9.0\Microsoft.Extensions.Caching.Memory.dll
- bin\net9.0\Microsoft.Extensions.Configuration.Abstractions.dll
- bin\net9.0\Microsoft.Extensions.Configuration.Binder.dll
- bin\net9.0\Microsoft.Extensions.Configuration.dll
- bin\net9.0\Microsoft.Extensions.DependencyInjection.Abstractions.dll
- bin\net9.0\Microsoft.Extensions.DependencyInjection.dll
- bin\net9.0\Microsoft.Extensions.Diagnostics.Abstractions.dll
- bin\net9.0\Microsoft.Extensions.FileProviders.Abstractions.dll
- bin\net9.0\Microsoft.Extensions.Hosting.Abstractions.dll
- bin\net9.0\Microsoft.Extensions.Http.dll
- bin\net9.0\Microsoft.Extensions.Logging.Abstractions.dll
- bin\net9.0\Microsoft.Extensions.Logging.dll
- bin\net9.0\Microsoft.Extensions.ObjectPool.dll
- bin\net9.0\Microsoft.Extensions.Options.dll
- bin\net9.0\Microsoft.Extensions.Primitives.dll
- bin\net9.0\Microsoft.Identity.Client.Broker.dll
- bin\net9.0\Microsoft.Identity.Client.Extensions.Msal.dll
- bin\net9.0\Microsoft.Identity.Client.NativeInterop.dll
- bin\net9.0\Microsoft.Identity.Client.dll
- bin\net9.0\Microsoft.IdentityModel.Abstractions.dll
- bin\net9.0\Microsoft.IdentityModel.JsonWebTokens.dll
- bin\net9.0\Microsoft.IdentityModel.Logging.dll
- bin\net9.0\Microsoft.IdentityModel.Tokens.dll
- bin\net9.0\Microsoft.PowerPlatform.Dataverse.Client.dll
- bin\net9.0\Microsoft.VisualStudio.Threading.dll
- bin\net9.0\Microsoft.VisualStudio.Validation.dll
- bin\net9.0\Microsoft.Xrm.Sdk.dll
- bin\net9.0\Newtonsoft.Json.dll
- bin\net9.0\System.ClientModel.dll
- bin\net9.0\System.Configuration.ConfigurationManager.dll
- bin\net9.0\System.Diagnostics.DiagnosticSource.dll
- bin\net9.0\System.Diagnostics.EventLog.dll
- bin\net9.0\System.IO.Pipelines.dll
- bin\net9.0\System.IdentityModel.Tokens.Jwt.dll
- bin\net9.0\System.Memory.Data.dll
- bin\net9.0\System.Runtime.Caching.dll
- bin\net9.0\System.Security.Cryptography.Pkcs.dll
- bin\net9.0\System.Security.Cryptography.ProtectedData.dll
- bin\net9.0\System.Security.Cryptography.Xml.dll
- bin\net9.0\System.Security.Permissions.dll
- bin\net9.0\System.ServiceModel.Duplex.dll
- bin\net9.0\System.ServiceModel.Http.dll
- bin\net9.0\System.ServiceModel.Primitives.dll
- bin\net9.0\System.ServiceModel.Security.dll
- bin\net9.0\System.ServiceModel.dll
- bin\net9.0\System.Text.Encodings.Web.dll
- bin\net9.0\System.Text.Json.dll
- bin\net9.0\System.Windows.Extensions.dll
- en-US\Isystem.PowerShell.PowerPlatform.Dataverse.dll-Help.xml
- en-US\about_Isystem.PowerShell.PowerPlatform.Dataverse.help.txt