Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Add SharePoint list items to a dynamicallly created Excel file

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

 

I have Sharepoint list entries which should be imported to an new created Excel file, within the same flow.

 

If the Excel file would be a static, already existing file, I could use the "add row in the table" action but I want to fill in a template, which will be used by different users.

 

Has anybody an idea?

  • Verified answer
    v-alzhan-msft Profile Picture
    on at
    Re: Add SharePoint list items to a dynamicallly created Excel file

    Hi @Anonymous ,

     

    You should fill I the Body column with type below:

     

    {

    "Column1":"the value1",

    "Column2":"The value2",

    "Column3":"The value3"

    }

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Community Power Platform Member Profile Picture
    on at
    Re: Add SharePoint list items to a dynamicallly created Excel file

    Hi @v-alzhan-msft

    thanks for your feedback.

     


    @v-alzhan-msft wrote:

     

    If you want to add a row to the new created excel file, you need to create table to the excel file in the same flow after the file is created.

     


    But can I then also use "Add a row into a table" within the same flow for the created file and table?

     

    YoYo1982_1-1596033660009.png

     

    If I tried it I got an error. I guess it is because the Body part is not correct:

     
     
     
     

    YoYo1982_0-1596033870460.png

     

     

     

     

     

     

     


  • v-alzhan-msft Profile Picture
    on at
    Re: Add SharePoint list items to a dynamicallly created Excel file

    Hi @Anonymous ,

     

    Would you please share the example of the requirement?

    If you want to add a row to the new created excel file, you need to create table to the excel file in the same flow after the file is created.

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1