cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beanybone
Helper I
Helper I

Delete a row if its more than 30 days old

Hi, i'm looking to delete row in a spreadsheet if it more than 30 days old. This is what I have so far. 

 

flow1.png

Compose 2 is addDays('1899-12-30',int(outputs('Compose')),'dd-MM-yyyy')

Condition is output of compose 2 'equal to' addDays(utcNow(),-30)

 

even though I have rows that would qualify the condition result is False.

 

Grateful for help. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
beanybone
Helper I
Helper I

Solved myself, just changed Is 'equal to' to is 'less than or equal to'. 

View solution in original post

2 REPLIES 2
beanybone
Helper I
Helper I

Solved myself, just changed Is 'equal to' to is 'less than or equal to'. 

Hi beanybone

 

Thanks for sharing the solution.

 

Regards,

JAvier

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,797)