web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Inserting data to the ...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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?

Categories:
  • Verified answer
    Rapothin Profile Picture
    33 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard