cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andiart
Resolver I
Resolver I

Deleting rows in Sharepoint list which are elder than a year

Hi,

 

I have a list in sharepoint from which I want to delete old items, when adding a new item. My flow triggers right but has an error in completing.

 

My flow gets triggered and then does an "Getitems"-step Where I wrote a odata filter like the following:

 
   less(item()?['Prüfdatum'], addDays(utcNow(), -365))
 

When executing I get an error that says that the function less needs two parameters with of the same type but gets types "null" and "string".

 

My column "Prüfdatum" is only Date and my addDays-Statement I think is Date+Time.

 

Can you help?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @andiart 

 

Please have a look at my video tutorials

 

PowerAutomate - How To Filter SharePoint List Records by Todays Date - YouTube

 

Power Automate - How To Filter SharePoint DateTime Column - YouTube

 

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

View solution in original post

1 REPLY 1
abm
Super User
Super User

Hi @andiart 

 

Please have a look at my video tutorials

 

PowerAutomate - How To Filter SharePoint List Records by Todays Date - YouTube

 

Power Automate - How To Filter SharePoint DateTime Column - YouTube

 

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 (1,496)