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 / Create record from Exc...
Power Automate
Unanswered

Create record from Excel file which is stored in Notes as attachment or file type field in CDS

(0) ShareShare
ReportReport
Posted on by 5

Hi All,

I have requirement where i want to create records from the data present in Excel file which is stored as attachment in notes or file type field of entity .

right now when I am trying to get data using Download file or image content connector it is fetching the data in binary content like below:

Sjain710_0-1625647195228.png

Now i want to convert or data in json array or object so that i can create a loop call for creating records based on the data which is present in the Excel file .

I also tried to achieve this through JavaScript but there also i get data in base64 , no idea how to convert that into json array(code-https://debajmecrm.com/retrieve-contents-of-file-data-type-field-in-dynamics-365-cds-using-javascript-client-code/)

 

Can anyone help me to convert or better approach for creating records from the attached file in CDS....?

Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard