Calendar Event to Specific Date based on Form

[tiny_24]

Good afternoon.  I have a created this Flow. It works great as far as sending the responses for approvals, creating a calendar event, and emailing those that need to be emailed of the approval.  The problem I am having is the calendar event is always added to the date on which the form is submitted.  How do I get it to go to the date on which the request is for? 

Your help would be greatly appreciated. 

[DamoBird365]

Hi @tiny_24 

You just need to use the Date of Requested Absence field which you use in your approval step?  Stick that into your Create Event Start Time?  If the format is wrong, use the expression formatdatetime().

Damien

[tiny_24]

I am not seeing a Create Event Start Time? 

If you are referring to this, I have tried to change that "Start time for" to "Date of Request" and it doesn't work. 

I must be doing something wrong. 

[DamoBird365]

Hi @tiny_24 

When I insert an event for 05/03/2021 which in the case of the event step is 2021-03-05 it gets added to my calendar as expected.  I suspect the date you are providing is not in the right format?

Try inserting a compose (temporarily) with the field you believe is the start date for your event and see what it outputs.  Then if it is in the wrong format use the expression formatdatetime(YOURVARIABLE,'yyyy-MM-dd')

Damien

[tiny_24]

@DamoBird365 I am really thinking it is grabbing the wrong date location.

It is grabbing the date in which the leave request is submitted (Today's Date) and not the (Date of Requested Absence) when it puts it on the calendar.   

I just don't know how to "Point" the create calendar event to select the Date of Requested absence since there is no "date" option in that step. It just has start time & End Time

[DamoBird365]

Is it not the start time field you want to populate? Or have I misunderstood your problem? You need to stick Date of Requested Absence into the start time of the create event step. Start time is the date and time from my test and screen shot.

[tiny_24]

Like this? 

When I do this the flow checks out. 

I get the approval notification/email.  I can approve it. BUT then I don't get the email notification of approval and it also doesn't hit the calendar at all.  I have to be doing something wrong. 

[DamoBird365]

Yeah, the format must be wrong. Can you stick both of those into separate compose steps and then check the history? Most likely it will need to be formatted and this is the easiest way to see what your playing with.

[tiny_24]

I think I found the history you were referring too.  

Is this what you meant? I'm really sorry but as you can tell I am very green with this and am just trying a flow for the first time.  We have had the option for a while but it is so very intimidating.  So I really appreciate your patience. 

[DamoBird365]

@tiny_24 No problems, we all start somewhere 🙂 just keep learning and I am happy to keep going if you think I’m helping you too.

So, you can see that your start time is missing a date. We really need to find that date somewhere and then we’ve cracked your problem. 

The compose action is great for troubleshooting. Drop your fields into it and re run the flow. If you check the history for each run, you’ll eventually find the date time you are looking for.

Final piece after that will be making sure the date is in the right format.  Now let’s see if you can find that date 🙂