Rrchiving excel row based on date

[Marika21]

Hi, 

I'm trying to build a Recurrence flow using excel that will archive rows to another table in the same excel based on date, that is 30 days after the date added.

I was trying to use variable and Filter Query with the following expression: addDays(utcNow(), -30, 'dd-MM-yyyy') but is giving me syntax error and I guess is something to do with data format in excel. Any ideas? 

Thank you!

[abm]

Hi @Marika21 

See my tutorial about Excel Dates.

https://www.youtube.com/watch?v=uFZxXMuLj-E

https://www.youtube.com/watch?v=r1LhHU5lXkM&t=32s

Recently there is another feature published that if you set the Excel Get Table list rows (Advanced options > Set the Format as ISO 8601) it should display in the right format.

Thanks

[Marika21]

hi @abm 

Thank you for your answer. 

I tried to use your solution with the compose but is giving me the following error:

Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '11088': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Any idea what I´m doing wrong?

not sure also where to add the part that the flow will check for dates that are 30 days older than added date.  the 

[abm]

Hi @Marika21 

Check the run history and see the first compose value?

Thanks