Unanswered

Unable to select list records action in Common Data Service.

(0) Share

Report

Posted on by Pradeepsvs Microsoft Employee

Hi,

I created a flow with Manual trigger. I am trying to list all records available in an entity and copy the records to SQL Database\Azure Blob Storage. I am unable to select "List Records" action. Any help is highly appreciated.

Regards,

Pradeep.

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Sort by

abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I created a solution. Then I placed a manual trigger button. Next step I search for "Common" . Here I can see both connectors of CDS. I can select List Records action from either of the connectors. Could you please post a screenshot?

Thanks

Was this reply helpful? Yes No
Pradeepsvs Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the answer. I did not create solution before. I just clicked on Flows from left Navigation pane and created a new flow.
Now, I created a solution, a new flow and chose a entity to I need to copy.

Another question is, can I copy the records from a entity to Azure SQL Database or Azure Blob Storage?

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pradeepsvs

Thanks for your reply.

To store in Azure blob storage please see this post

https://www.c-sharpcorner.com/article/copy-files-from-sharepoint-to-an-azure-blob-storage-using-microsoft-flow/

For SQL server you need to use SQL connector enter your credentials for Insert Row action step.

Was this reply helpful? Yes No
Pradeepsvs Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Is this applicable to Azure SQL Database as well? or just SQL Server On-Prem? Ideally, I will add a row to a staging table and execute a SP to merge data based on an entity id.
Can insert row action insert more than one row or is there other method?

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pradeepsvs

It's the same connector and if you have on-prem then you need to check the box.

So once you retrieved your records then add a foreach loop, then add the insert row inside the loop so that for each iteration it will insert the record.

Thanks

Was this reply helpful? Yes No
Pradeepsvs Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you,

I tried following based on your feedback. I choose insert row action and provided sql server credentials. I chose a database and table to which data should be copied to. On clicking on each column on UI, i see column list from "List Records" action. I mapped each column and saved the flow. Please let me know if this is a right way to map column data between CDS entity and SQL Server database table.

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pradeepsvs

Yes that looks good. I can see you are mapping a modified on field to Year. Is that correct? Hope that's a datetime field. The best way to do is runt the flow and test it.

Thanks

Was this reply helpful? Yes No
Pradeepsvs Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Cool, Thanks for your help! the mapping is not final yet. I just tried how to map fields and check if that's the right way.
Appreciate your help 🙂 Thanks @abm

Was this reply helpful? Yes No