Unanswered

Delete item with specific word from last year

(0) Share

Report

Posted on by AnG96

Hi,
I really enjoy finding and using solutions here, but unfortunately not every answer fits.

Now i have created the following flow through a previous solution, there it was still about deleting a calendar, which also worked great.

Now i have a List and it is possible to delete only the entry "Avocado" from the year 2022 with the same flow?

What if I have more than one list?

I only found and try the "switch" function, which I think is very unflexible.

Thanks for your help! ✌️

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report

Hi @AnG96 ,

For this answer, I used list structure very similar to yours:

In Power Automate, you use 'Get Items' action (as you already did) to return the records form a SharePoint List. In the filter query, you may specify what do you want to return from the list, which in our case is the records with 'Avocado' in title and with 'Date' column from 2022 (it means, lower or equal to December 31st 2022 AND greater or equal to January 1st 2022). Make sure to add the 'and' operator (highlighted in green) to apply all filter expressions (highlighted in yellow) to your action:

Then you just need to add an 'Apply to each' loop and insert your delete action inside the loop block:

Output:
After run the flow, the 'Get items' will return only one item (title Avocado, with date from 2022) and delete it from the List:

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Was this reply helpful? Yes No
AnG96 26 on at

Like (1)

Report

Hi @rzaneti
the solution works great!
I also read out the last year and now I don't have to adjust the time every year.

formatDateTime(utcNow(),'yyyy')
sub(int(variables('varYear')),1)

I'm sure the solution is also simple, but it's ok for me to learn if it works. 😀
Thanks a lot!

Was this reply helpful? Yes No