Step-by-Step Guide to Deleting All Items in Groups Ending with '2022' on Make.com Integrated with Monday.com

Hey there, Make.com users! Today, we're going to tackle a common problem that some of you might have encountered: deleting all items in a group where the group title ends with "2022" in an integration with Monday.com. This can be a bit tricky, but don't worry, we've got a step-by-step solution for you.

Problem

So, you've got Monday.com integrated with Make.com and you're looking for a way to set a scenario that reads all the group names on a board. If that group name ends with "2022", you want to delete the items and the group. You can get a list of all items in a group and a list of all groups, and you can set the filter as "ends with 2022", but you can't get it to delete everything in all the groups. You're hoping to automate it so you can just say, "delete everything that is in a group which says 2022 at the end".

Solution

Here's a step-by-step guide to solve this problem:

  1. Use the List Boards Group’s module to get all the groups on the board.
  2. Use the Graph QL module with the appropriate API request.
  3. Add a filter between the 2 modules “if Title contains 2022”.

And voila! You've successfully automated the deletion of all items in groups ending with "2022".

Troubleshooting Tips

If you're setting up a schedule to archive any groups that are older than 3 months, you might run into some issues. For example, you might set up the query as:

formatDate(addMonths(now; -3); "MM-YYYY")

And expect that on the 1st of each month, it will run and anything that is 06-2023 will be removed. However, when you try to check it by running:

formatDate(addMonths(now; -4); "MM-YYYY")

It might remove 06-2023 instead of 05-2023. If this happens, make sure you had -4 and not -3 when it deleted 06-2023. If you're still having trouble, don't hesitate to ask for help and share screenshots of your setup.

Summary

Automating tasks on Make.com can save you a lot of time and effort, but it can also be a bit tricky. Hopefully, this guide has helped you understand how to delete all items in groups ending with "2022" in an integration with Monday.com. Remember, if you're having trouble, don't hesitate to ask for help. Happy making!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.