Questions tagged [common-data-service]
90 questions
1
vote
2 answers
How can I do bulk inserts into the Common Data Service?
I have 1000 records that I need to sync daily from an API. I am currently bulk inserting them into a SQL Database, however I would like to use Dataverse/a Common Data Service database instead.
The Logic App connector seems to do 1 record at a time…

Rodney
- 5,417
- 7
- 54
- 98
1
vote
1 answer
How can I insert selected Listbox items as a new record in to a common data service table
I have a PowerApps canvas App and I have a requirement of creating new records for all selected listbox items in to a table. I am acually trying to implement a many to many relationship scenario
my Listbox name is: ListBox1 and my table name is…

MJ X
- 8,506
- 12
- 74
- 99
1
vote
1 answer
CDM Nuget Packages
I am looking to create ADF pipeline to load data to powerapps entity using CDM. I have exported the data from powerapps to ADLS. I was following this…

Chandru lots to do
- 13
- 2
1
vote
2 answers
Set PrivilegeDepth with Microsoft CDS Web API
I'm trying to create an application user, along with its Security Role, for my Common Data Service environment using only the Web API. I've managed to create both the User, the Role and associate some Privileges to the Role. The only thing I can't…

Pedro Rosa
- 35
- 5
1
vote
2 answers
Deadlock issue in MSFlow - Update data from CDS to SQL
I have created a Flow to update the GUID(the unique identifier of CDS entity records) into an SQL Server table From CDS whenever a new record is created in CDS. The flow is working fine If I create records one by one. But If I import multiple…

Kathir Subramaniam
- 1,195
- 1
- 13
- 27
1
vote
1 answer
Register app in Azure AD to access CDS Web API
I'm trying to figure out how to integrate an external app with Microsoft CDS Web API. The first step would be to try the Wep API with Postman. Following this document I could authenticate and make requests to the API using the client id provided in…

Pedro Rosa
- 35
- 5
1
vote
1 answer
ADF CDM Source Transformation not reading data
I am having an issue with the inline data set for Common Data Model in Azure Data Factory.
Simply, everything in ADF appears to connect and read from my manifest file and entity definition - but when I click the "Data preview" button, I always get…

MadDog
- 21
- 2
1
vote
1 answer
Error when using Alternate Key in CDS connector
I'm using the Common Data Service for Apps connector in Azure Data Factory to load data into Dynamics 365
I've done this successfully before using the entity key. See this question: Loading records into Dynamics 365 through ADF
Now I'm trying to use…

Nick.Mc
- 18,304
- 6
- 61
- 91
1
vote
1 answer
Making a PATCH method request with a file to Common Data Service
I'm trying to create a Python script which can use the PATCH method to upload a file into MS's Common data service. I'm successfully making GET, POST, PATCH, and DELETE calls with simple data, but have so far been unable to configure it so that I…

Whambulance
- 113
- 3
- 13
1
vote
1 answer
Creating a clickable grid scheduling-like tool thing for D365 MDA on CDS
I'd love to be able to create an interactive something like the picture below to include in an app - rows represent partners that we'd work with, and columns represent how many widgets they are assigned to build per month (those numbers come from…

Chris Koenig
- 2,736
- 18
- 17
1
vote
1 answer
No "Common Data Service" API option Azure
I need to add the "Common Data Service" API in my Azure account in order to implement an integration to Dynamics 365.
However, it is not listed
Also, the following error appears during my attempt to connect to Azure:
The app needs access to a…

Qwerty
- 19
- 4
1
vote
1 answer
How to add headers to Common Data Service data store in Microsoft Azure Data Factory
I am new to Azure Data Factory and have a requirement to pull data from Common Data Service (PowerApps) application to Azure SQL Database.
I can pull data directly from the entities using a linked service. The problem arises when I want to include…

sameet90
- 123
- 7
1
vote
1 answer
How to insert JSON records into a Common Data Service Entity in PowerApps?
I need to insert data entries into Common Data Service(CDS) Entity in PowerApps.
This is how my entity looks like:
Now if I try to insert the entries by importing an excel table, like shown below, power query correctly interprets it into its own…

Sumit Nagpal
- 43
- 4
1
vote
1 answer
How do I replicate data from the Common Data Service to SQL Server on Azure?
I have data in Microsoft's Common Data Service (from Microsoft Dynamics for Talent). I can't use the Data Management Framework as the data in question is in entities that are not available through the DMF.
How do I replicate the data in the CDS back…

quant
- 21,507
- 32
- 115
- 211
1
vote
1 answer
CDS Time zone independent Date Time fields not available in Powerapps
I'm creating some PowerApps to extend D365 Talent functionality.
For some reason, none of the Date and Time fields with Behaviour 'Time zone independent' are available in Powerapps...
Here's an example of a custom entity with 2 Date and Time…

Nathan Wardle
- 11
- 3