Unable to select list records action in Common Data Service.

[Pradeepsvs]

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.

[abm]

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

[Pradeepsvs]

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? 

[abm]

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-micr...

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

[Pradeepsvs]

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?

[abm]

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

[Pradeepsvs]

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.

[abm]

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

[Pradeepsvs]

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