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.
You can try this:
formatDateTime(items('Apply_to_each_2')?['Column1']),'yyyy-MM-dd')
Best Regards,
Levi
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)
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:
Best Regards,
Levi