Skip to main content

Hi, all! We’re using Airtable to intake scheduling for content, and have an automation that builds a secondary record for later content updates based on information provided in the intake form.

As a second step in that automation, I’m trying to send a note to a Teams channel to confirm the automation has run and alert our team that there’s a new task scheduled on the update date .. but every time I test the automation, the update date generates blank in the preview and comes through blank in the Teams message as well, even though the field itself is populated in the original record (that’s one of the conditions).

Is there anything I could be doing wrong, or is this just a quirk that will be worked out at some point?

@marissa_1908 

Are you re-testing the entire automation, or are you just re-testing the Microsoft Teams action?

If you’re just testing the Teams action, you will need to re-test the trigger first -- and then you can re-test the action.

And when you re-test the trigger, be sure to choose a record that has a date in it.

p.s. If you ever need more advanced Microsoft Teams integrations, you can get those by using Make’s Microsoft Teams integrations along with Make’s Airtable integrations.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Hm, does it work when you actually trigger the automation?  If it does, then your initial testing data doesn’t have that field populated and you can check that by clicking the trigger and checking the selected record’s data (screenshot below), and you can refresh the data by hitting ‘Choose record’ and selecting a new record that meets the conditions



---

If it doesn’t work even when you actually trigger the automation, could you provide some screenshots of your automation set up? 

You mentioned that it builds a secondary record and I’m wondering if the Update Date that you need relies on data from that secondary record via a lookup something, in which case you’d want to add a ‘Find record’ step to get the new data and use that ‘Find record’ step’s output in your Teams message