Unanswered

How to export data from Common Data Service Entities (Powerapps) to on Premise SQL Server

(0) Share

Report

Posted on by ARTECH

Hi,

I have a question about the Exporting Common Data Service entity to local or on-prem SQL Server. I'm trying to export CDS entity data to SQL database using MS flows.

I have created a flow and it executed successfully. But data in not getting loaded into the table. I have attached the picture of flow for your reference. Please check once and let me know if I'm doing anything wrong here.

Thanks in advance.

Regards,

Categories:

Microsoft Dataverse with Power Apps

Export CDS to SQL...

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xida-msft on at

Like (0)

Report

Hi @AR19 ,

How do you set up your flow? Using Flow Template?

Do you want to sync data from your CDS Entity to your SQL Table?

Based on the screenshot that you mentioned, I assume that you set up your flow based on Flow Template, is it true? I could not find any configuration issue with your flow.

I have made a test on my side, and don't have the issue that you mentioned. The flow's configuration as below:

On your side, please consider set up a new flow from scratch, then configure it as above screenshot I provided, then try the flow again, check if the issue is solved.

Also please make sure there are records existed in your CDS Entity (Accounts) already. In addition, you could also consider check the run history of your flow as below:

check if the "Insert row (V2)" action could insert data from your CDS Entity into your SQL Table successfully.

Best regards,

Was this reply helpful? Yes No
Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report

Hi @AR19

It looks like there is an issue with the Flow config. In the Get Record step you are using the Account Name in the Item Identifier field. That is not going to return a record. You need to be using Account in the Item Identifier field, which is the GUID of the Account record.

However, as the previous post suggests you don’t need the Get Record action as you should already have the Account details from the List Items step

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @AR19 ,

Have you take a try to re-create your flow from scratch based on the flow's configuration I provided above?

Based on the issue that you mentioned, it seems that there is something wrong with your flow's configuration. Please consider take a try to re-create your flow from scratch based on the flow's configuration I provided above, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No