I would like to create an all day event in Google calendar when an all day event is created in Outlook. Currently if an all day event is created in Outlook, it becomes a 2 day event with start and end times in Google calendar. This is using the Sync events from Office 365 Outlook Calendar to Google Calendar template.
Unfortunately, I can't export my flow due to the visibility of my work email address, but I'll try to lay out all of the steps I followed here. I also figured out a slightly easier way to do it that saves a few steps.
I've included another screenshot of what my flow looked like after editing (showing everything after the "Check if it is a google calendar" condition). Just to note, I did set custom names for my "Html to text" and "Create an event" actions, so the action names won't match yours exactly, but everything else should look essentially the same.
I hope this helps!
I also have screenshots for most of those individual steps if any are needed; I just didn't want to include them all right away and fill up the page 🙂
It worked!!! It's a miracle. CANNOT THANK YOU ENOUGH! seriously I didn't think I was going to figure it out. Thank you so much for taking the time to walk me through this!
@yseleah thanks so much for putting the time into the step-by-step explanation. Very easy to follow. My only problem (and it's the keystone here) is there's no field in my Google Cal actions that lets me choose all-day status. It almost seems like once the condition is based on the all-day status from Outlook, this field automagically appears in the Google one. I'm not seeing that. And unfortunately, I'm trying to get this step working in a different context: a Flow that takes each line from an Excel spreadsheet and creates an all day event in Google Cal. So if it requires input from Outlook, I won't be able to offer it (unless I do some roundabout solution building, I guess). Below is what I see. You can see I don't have that option in either the exhisting Google Cal action that we drag-and-dropped nor the new one that was added in the No condition. Any ideas?
What flow are you using? there are a few that are very similar in names, but different flows. The one we are using is "
Sync events from Office 365 Calendar to Google Calendar"
@thatmattwade, How long ago did you start using this Flow? I wonder if the field for the "Is all-day" was added to the "Create an event" Google Cal action more recently, and perhaps you are seeing an older version of that action (I don't know how MS Flow manages those types of updates, so this is just a guess).
I don't believe it's contingent upon the condition check, though—I just tested by building a new Flow from scratch, starting with a simple "Manually trigger a flow" trigger, and the "Create an event" action that I added after that did have the "Is all-day" field visible under the "Location" field.
I followed the steps in this example and created a new Flow from the referenced template late last week. Probably on Friday. Weird that you get options that I don't.
We must be soooo close to solving this 🙂
I have the same problem, not getting the "Is all-day" field in the "Create an event" action. When I import the calendar posted earlier in this thread ( by amsw, message 20 ) I have to move the "Check if all day event" around a bit. ( with the current import, two events are created ). When I do, a field appears in the "Create an all-day event" action called "isAllDay", and with no drop down.
If I delete this event, and replace it with a new "Create an event", that field is gone.
I can also not find the "Is all-day" back in the list of actions for the "Create an event" description ( https://docs.microsoft.com/en-us/connectors/googlecalendar/#actions ).
What am I missing ?
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!