Skip to main content

Notifications

Power Automate - Building Flows
Answered

Where to get row connectors from List present rows at table?

(1) ShareShare
ReportReport
Posted on by 12

Hello,

 

I am struggling to create a flow which will copy rows from one excel table and will add them to another excel table. 

File name will be different each time. Table names will be the same but flow is triggered when file is uploaded to Sharepoint.

 

So far I came up with something like this (see below) but I am unable to add rows to tabe (row is added but is empty) not matter I do. 

bartoszdmochow_0-1664346663538.pngbartoszdmochow_1-1664346723210.png

 

 

  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Where to get row connectors from List present rows at table?

    Hi @bartoszdmochow 

     

    You can try this:

    formatDateTime(items('Apply_to_each_2')?['Column1']),'yyyy-MM-dd')

     

    Best Regards,

    Levi

  • bartoszdmochow Profile Picture
    bartoszdmochow 12 on at
    Re: Where to get row connectors from List present rows at table?

    Hello @v-liwei-msft 

     

    Thank you for prompt feedback. This do solve my problem. 

     

    Can you advise how change date fromat? 

    In second table I got date like this: 2022-09-26T00:00:00.000Z

    and I would like to have this without time mark (only date)

  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Where to get row connectors from List present rows at table?

    Hi @bartoszdmochow 

     

    First, make sure that each file uploaded to SharePoint has the same data structure (equal column names). 

    Add an apply to each under List rows present in a table to traverse the value returned by List rows present in a table. 

    In this apply to each add Add a row into a table, use expressions in the fields that need to be filled (eg items('Apply_to_each_2')?['Column1']) 

    I did a test for your reference:

    vliweimsft_0-1664356086222.jpeg

    vliweimsft_1-1664356096238.jpeg

    vliweimsft_2-1664356108041.png

     

    Best Regards,

    Levi

     

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,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard