Help trying to copy rows from one sheet to another

[mowgli512]

Hi,

I have a sheet with the columns #, Date, Channel, Category, Title.

I am trying to copy rows which have the 'Date' column greater than a deadline date into another new sheet. 

I have created a flow which runs successfully but doesnt update anything.

Perhaps the condition I am using may be incorrect. Can someone please help with this? 

Flow image below - 

[v-yamao-msft · Accepted solution]

Hi @mowgli512,

You said that the flow runs successfully but doesn’t update anything, please make sure there are items that matched the condition.

I have made the following test.

Before creating the flow, I have created an Excel table with the columns you mentioned, and I formatted the Date column as type of Text.

Then configured the flow likes below. Input the following code in the Condition in Advanced mode:

@greater(formatDateTime(items('Apply_to_each')?['Date'],'yyyy-MM-dd'), triggerBody()['date'])

When the button is clicked, all the items that matched the condition will be saved from Table2 to Table1.

Please try again with it on your side. 

Best regards,

Mabel

[mowgli512 · Accepted solution]

This worked with the below condition - 

@greaterOrEquals(formatDateTime(items('Apply_to_each')?['Date'], 'yyyy-MM-dd'), formatDateTime(triggerBody()['date'], 'yyyy-MM-dd'))