cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marika21
Frequent Visitor

Rrchiving excel row based on date

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!

3 REPLIES 3
abm
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Marika21
Frequent Visitor

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. Capture.JPG the 

Hi @Marika21 

 

Check the run history and see the first compose value?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,295)