Is it possible to created CDS tables and columns using PowerShell?
The import wizard/data flow was unable to correctly import a large SharePoint list.
Hello @ques0buffet ,
did you try to set the Power query in a Batch to accommodate that many records? If not, can you try that method and see if that works.
We can do it, however there is no public facing document to provide the steps. If the above method doesn't help, then I believe you might need to use the XRM tooling cmdlets for this. However, I would suggest to first try it on a test environment before running on production as this is not shared by Microsoft-
MS article to connect to CDS using Powershell-XRM tooling: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/xrm-tooling/use-powershell-...
Let me know if that answers your query.
I was not able to create a new table using Power Query due to the column types coming from SharePoint.
Thank you for the API documentation.
You can also use Dataflows with SharePoint as the data source to create your entity, map and import the records into CDS.
$entity = new-object Microsoft.Xrm.Sdk.Messages.EntityMetadata $entity.SchemaName = "schemaname" $entity.DisplayName = "name" //add other entity properties $request = new-object Microsoft.Xrm.Sdk.Messages.CreateEntityRequest $request.Entity = $entity //add other CreateEntityRequest properties $response = $Connection.ExecuteCrmOrganizationRequest($request)
Hope this helps!
Check out the News & Announcements to learn more.
Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.