Inserting data to the custom Entity in Common Data Service using flow

[Anonymous]

Hi All,

Is it possible to read the  CSV  file data, from One Drive and insert the data to the custom Entity in Common Data Service using flow?

[Rapothin · Accepted solution]

Hi,

It seems not possible for now to directly get the rows of a CSV file (https://powerusers.microsoft.com/t5/Flow-Ideas/Text-CSV-file-get-rows/idi-p/19494).

For me, you have 2 solutions:

• If you can save your CSV file to Excel format (xlsx), you will be able to get the rows (with the get rows action of the excel connector) and for each one of them create a record in your custom entity in the common data service
• If you can't save your CSV file to Excel format (xlsx), you can try to split its content (with the split function). First, you separate each line, then for each line you separate each data. And for each line you get, you create a record in your custom entity in the common data service with the data you got

I hope this solution will help you.

Regards,
Raphael