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!
Solved! Go to 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
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
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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
87 | |
52 | |
37 | |
33 | |
27 |
User | Count |
---|---|
75 | |
66 | |
50 | |
47 | |
42 |