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 Automate / Add row to several exc...
Power Automate
Unanswered

Add row to several excel files from sharepoint list

(0) ShareShare
ReportReport
Posted on by 25

Hello 

I need to populate several excel template files using the same sharepoint list, so when a new row is createad in my SPlist, the data should be copied in different excel files. Someone can help me to reach the target using powerautomate flow? 

Categories:
I have the same question (0)
  • Andrew_J Profile Picture
    1,962 Moderator on at

    @marcomizz 

     

    Okay, I will endeavor to assist but have a look at the following from@DamoBird365 first:

     

    https://www.youtube.com/watch?v=RB_ySjhm9Sg

     

    It might give you some pointers as the way to handle this issue.

     

    Regards,

     

    Andrew

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @marcomizz,

    Do you want to copy item to different excel files at the same time?

     

    If so, I think you need to list different tables at the same time, here is a simple demo for your difference:

    vqiaqimsft_0-1710739661101.png

    I use the trigger when an item is created or modified, if you just create new items, you could use the when an item is created instead.

     

    For the condition, just to check if the common column in your Excel table has existing value, in my scenario, Title is the common column between SP list and Excel table, if the new created Title equals to any Title in excel file, just update the existing row in Excel, otherwise, created a new row.

    vqiaqimsft_1-1710739858431.png

     

     

  • marcomizz Profile Picture
    25 on at

    Hi @v-qiaqi-msft 

    thanks for your suggestion.

    in my scenario I have to copy in several excel files not the same items of my sharepoint list, suppose I have a share point list with 10 columns like below:

    ItemData1Data2Data3Data4Data5Data6Data7Data8Data9
    110203015210458
    270110151486995

     

    then suppose I have to copy in two different exel files (in table format), for each item in the SP list the following data:

    excel file 1: the Data1/Data3/Data4

    excel file 2: the Data2/Data5/Data6/Data7/Data8/Data9

    so I need choose in powerautomate flow, which column I need to copy from my share point list and in which excel file I need to copy those fields. 

    Best Regards

    marco

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @marcomizz,

    I am afraid that you could not choose which column to copy from your SP list, which should be sepcifed not dynamically selected

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 573

#2
Valantis Profile Picture

Valantis 407

#3
11manish Profile Picture

11manish 387

Last 30 days Overall leaderboard