Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

how to make cds from excel

(0) ShareShare
ReportReport
Posted on by

I want to make flow about these steps flow

 

1. put excel file on One drive (this is trigger)

2. get table data in that excel

3. insert to cds

 

if you know please teach me...

question.png

  • Verified answer
    v-yamao-msft Profile Picture
    on at
    Re: how to make cds from excel

    Hi @Anonymous ,

     

    Do you want to get rows from the Excel table then save them into the CDS entity?

    Please take the following screenshot for a reference.

    After Get rows action, add an Apply to each, select output Value from the action Get rows.

    Within the apply to each, add Create a new record, in the Name field, input the following code:

    Item()?[‘name’]

    Note: make sure you do have a column named as “name” in the Excel table.

    1.PNG

     

    Best regards,

    Mabel

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow