Add Member to Mailchimp Varying Delay

[mdjanz]

I have this flow setup (thanks to help from these fourms!) to add an email to my mailchimp list off required attendees of a created calendar event.

I want to have the addition to that list be delayed until 24 hours before the event is scheduled to occur (using the "Start Time" dynamic content from outlook calendar). Obviously the times between when the event is put on the books and when it will occur will vary. 

Thanks!

[douglasromao]

Hi @mdjanz,

You can use the "Delay until" action, you just need to calculate adding the 24 hours based on the event scheduled date on this action and the workflow will be stopped until this time.

I think this might help you.

Regards,

Douglas

[v-xida-msft · Accepted solution]

Hi @mdjanz,

Could you please share a bit more about your flow's configuration?

Do you want your flow to be delayed until 24 hours to add member to your Mailchimp list?

I agree with @douglasromao's thought almost, if you want your flow to be delayed until 24 hours to add member to your Mailchimp list, I think the "Delay Until" action could achieve your needs.

If you want your flow to be delayed until 24 hours based on the "Start Time" of the created Outlook event, I have made a test on my side, please take a try with the following workaround:

Within "Delay Until" action, the Timestamp field set to following formulas:

formatDateTime(addHours(triggerBody()?['Start'],24),'yyyy-MM-ddTHH:mm:ssZ')

or 

formatDateTime(addDays(triggerBody()?['Start'],1),'yyyy-MM-ddTHH:mm:ssZ')

The flow works successfully as below:

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

Best regards,

Kris