Skip to main content

Notifications

Power Automate - General Discussion
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? 

  • Re: Add row to several excel files from sharepoint list

    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

  • marcomizz Profile Picture
    marcomizz 25 on at
    Re: Add row to several excel files from sharepoint list

    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

  • Re: Add row to several excel files from sharepoint list

    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

     

     

  • Andrew_J Profile Picture
    Andrew_J 1,962 on at
    Re: Add row to several excel files from sharepoint list

    @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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard