I am trying to set up a connection between Outlook and Asana to automatically add meetings to my task lists.
I have set up a rule on PowerAutomate to create tasks for any calendar event in my diary for the next 10080 minutes (5 days), and this has mostly worked (although for some reason it isn’t managing to carry over the due date correctly, so I have to manually reset the dates on the Asana tasks). These go into a project called Meetings, and appear in my task list in a specific section.
However, I specifically want to be able to automatically tag any meeting happening in the next 24 hours with a custom field. To do this, I set up a rule for ‘When task is due today…’ to apply that tag. The problem is that, because the due date triggers only fire once a day, it doesn’t tag any meetings that are added to my diary during the course of the day.
Ideally, this would be replaced by a rule which covers ‘When task is added to this project…Check if date is today…Set [task field] to [Today’s Meetings].’
Unfortunately I can’t do that, because Asana inexplicably still doesn’t allow for relative date checking even though that is literally the most obvious thing you would want to set a rule up to do.
Does anyone have any workarounds to allow for checking if the due date is today?
I guess the other option is to build a separate project for PowerAutomate to feed today’s meetings into, but frankly that seems like it would end up with a lot of duplicate entries. It would be super useful if Asana actually integrated with Outlook Calendars in both directions, but as far as I can see it can only feed into Outlook, not out of it?