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

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard