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 Apps / Load excel files to CDS
Power Apps
Answered

Load excel files to CDS

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

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 Apps

#1
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard