Hi All,
Using the Create Event(V4) entry I can create calendar events. I'm having an issue to create the event in such a way to show all days i.e. the event should be between (all day) 11/07/2022 - 15/07/2022 however the calendar will only show the event on 4 out of the 5 days 11/07/2022 - 14/07/2022 Mon-Thurs and not Mon-Fri.
What am I doing wrong?
Any help would be much appreciated!
I'm glad to hear that you've got it working!
sorry no, thats not happened to me.
Scratch that, I think I finally cracked the code! I basically added 2 seconds to the end date which doesn't change the day on the calendar so it only shows a single day of vacation.
Thank you for your help 😁
Thank you for your response, although I didn't follow your suggestion, I did manage to find a solution! Your response made me realize I had done something silly. Instead of having the 'Get Item' function, I had the 'Get Items', which for my purpose was useless since I only want the last item to be added to the calendar. What I ended up doing is adding a compose function for Start and End times and in the Create Event function I added this "
So having read through what you've written I'm guessing you've gotten it to detect the holiday type correctly and it is just getting it to add an event to the calendar that is the issue.
So on mine - I used the Start Date captured upon form submission, are you able to use the start/create date that's associated with the item on the SP list? Then use only the calculation for the end time.
Also I noticed that your expressions are using minus numbers addHours(formatDateTime(triggeroutputs()?['body/End'],'yyyy-MM-ddTHH:mm:ss'),-8) try removing the minus sign addHours(formatDateTime(triggeroutputs()?['body/End'],'yyyy-MM-ddTHH:mm:ss'),8)
Are you getting an event created in the calendar even if it is the wrong date?
I can definitely do that, and thanks again for any help you might be able to provide!
So I have created a Sharepoint list where people add their dates and type of leave so we can have an "out of office" tracker
Now, I wanted to make the next logical step, given that we have a shared vacation calendar in Outlook, and so when someone puts in a new entry the flow would detect if it's vacation and if it is then it would create an event showing their vacation time on our outlook calendar.
The expression for Start & End times are:
I have also tried selecting the Start Time and End time straight from the SHarepoint list but for some reason it puts the create event under an "apply for each" loop so it does prints out all previous things on the list apart from the new entry.
In the Create Event, I have selected "Yes" to the All day event question
Ha yeah, I felt the same way when I tried doing this!
Can you take a screenshot or gif of your flow so I can see what you're doing?
Hey! Thanks for your response. Sorry it took me sometime to get back to you. What I thought it would have been a simple flow, has become a nightmare for me!
To begin with, when I add a compose action in my flow, it instantly becomes an "Apply for each" function. To add to that, when I put the Start Date to my Create Event, it also becomes an "Apply for each" function, which for the one time that my flow worked whenever a new entry was added, it would re-print all previous entries!
To be honest, I'm a little bit lost with this one. If there is any suggestions that you might have to offer, I will take them! 🙂
Thanks again for your time!
Hi TrafficCounter
Here are the screenshots of the flow - hopefully they are useful!
You can't see it here but my calendar event config is set to be an all day event.
I'd take a screenshot of more of the flow but currently working on a tiny screen 😅 but i think this is the important bit! Let me know how you get on 🙂
Hello webbj,
I'm experiencing a similar issue. I was wondering if you could share a snapshot of your flow so I can see what is different from mine.
I tried using that similar expression you mentioned, as someone else suggested to me, but I'm still having an issue.
stampcoin
55
Michael E. Gernaey
39
Super User 2025 Season 1
VictorIvanidze
26