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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Load excel files to CDS
Power Apps
Answered

Load excel files to CDS

(0) ShareShare
ReportReport
Posted on by

Hi ,

I have few excel files in a folder on share point and want to load all of them as custom entities with the same file name as the excel files into CDS. Is there a way to load all of them in one dataflow? This step might be repetitive so I want to automate every time the excel files changes. 

For example. I have employee.xlsx, department.xlsx, sales.xlsx on a shared folder on share point. I want to lead each of these excel files to CDS as employee, department and sales entities.

Any help is appreciated.

Thank you in advance.  

I have the same question (0)
  • Verified answer
    EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @Anonymous, since the data needs to be imported into 3 entities, you'll have to create a Dataflow for each. Cheers

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 Apps

#1
Kalathiya Profile Picture

Kalathiya 402

#2
WarrenBelz Profile Picture

WarrenBelz 380 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 293 Super User 2025 Season 2

Last 30 days Overall leaderboard