cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
csmith67
Level: Power Up

Excel to outlook Calendar

I have an excel spreadsheet which uses VBA to push a new row of data to an outlook calendar. I'd like to use Flow in this manner. A new row would add the data on the row to the calendar. I can do something like this in Zappier. Is it possible using Flow? I can't seem to get started with Excel. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Excel to outlook Calendar

Hi @csmith67,

 

I built a solution and see the below steps:

 

Step 1: Create a table in excel called 'CalendarEvents' and stored under onedrive.

 

c4.png

 

Step 2: See the below Flows required for my build.

 

c1.png

 

c2.png

 

c3.png

 

Step 3: Flow ran successfully

 

c6.png

Step 4: Results in my outlook calendar

 

c5.png

 

Step 5: Excel Sheet after execution of flow. The excel row data is deleted.

 

c7.png

 

That's it. Hopefully this is helpful and any questions please let me know.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

14 REPLIES 14
Super User
Super User

Re: Excel to outlook Calendar

Hi @csmith67,

 

You need to look into Flow Excel Get Rows & Create Event Calendar templates to achieve this. Excel Get Rows can read the content of rows and in next flow step (Create Event Calendar) you can map the excel values.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



csmith67
Level: Power Up

Re: Excel to outlook Calendar

Thank you however those are not showing up for me when I create a new flow. Any thoughts as to why? 

Super User
Super User

Re: Excel to outlook Calendar

Hi @csmith67,

 

Can please show me your flow screenshot?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



csmith67
Level: Power Up

Re: Excel to outlook Calendar

This is what I see when I look for Excel.

 

Flow1.jpg

csmith67
Level: Power Up

Re: Excel to outlook Calendar

This is what I see when I look for Excel.

 

Flow1.jpg

Super User
Super User

Re: Excel to outlook Calendar

Hi @csmith67,

 

For executing flow you need a trigger. In your case trigger can be when an excel sheet is placed under a one drive or your trigger can be recurrence with time intervals. Please see below.

 

(1)  Trigger when excel sheet is placed under one drive

 

e2.png

 

(2) Trigger by recurrence

 

e1.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



csmith67
Level: Power Up

Re: Excel to outlook Calendar

So I'm wanting an appointment to be added to the calendar when a row is updated or added in excel. Regardless of having the excel document already on 365 it needs to be triggered from creating a new excel document? I'm not following. 

csmith67
Level: Power Up

Re: Excel to outlook Calendar

So I'm wanting an appointment to be added to the calendar when a row is updated or added in excel. Regardless of having the excel document already on 365 it needs to be triggered from creating a new excel document? I'm not following. 

Super User
Super User

Re: Excel to outlook Calendar

Hi @csmith67,

 

I built a solution and see the below steps:

 

Step 1: Create a table in excel called 'CalendarEvents' and stored under onedrive.

 

c4.png

 

Step 2: See the below Flows required for my build.

 

c1.png

 

c2.png

 

c3.png

 

Step 3: Flow ran successfully

 

c6.png

Step 4: Results in my outlook calendar

 

c5.png

 

Step 5: Excel Sheet after execution of flow. The excel row data is deleted.

 

c7.png

 

That's it. Hopefully this is helpful and any questions please let me know.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

csmith67
Level: Power Up

Re: Excel to outlook Calendar

This is great. Thank you. I would not delete the row beacuse I'd want to update the event. Does the push to the calendar return a callback ID which can be searched for? Also If I wanted to tarket another user's calendar which is shared with me is that possible? 

 

Thanks. 

Super User
Super User

Re: Excel to outlook Calendar

Hi @csmith67,

 

You probably need to set the Id (Event unique identifier) as part of creating the event. I don't think it returns an Id. There is a flow template called 'Get Calendars' and I thought this might give us the shared calendars. Even if it does we can't set the Create Event template Calendar name dynamically. Currently user need to select this manually. You can post this to the idea forum https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



LucaCap
Level: Power Up

Re: Excel to outlook Calendar

ok thank you for your procedure....but i get an error with format date....in recurrency i've setting up the advanced option for my GMT + 1.00h and in the start hour, i've try to put the format DD-MM-YYYYT HH: MM: SSZ (i've put the space otherwise in this field the system change to some emoij icons) but it show the invalid format date....and i've tried also to change the start hour and end hour in the object "create an event in google calendar" writing the expression

formatDateTime(triggerBody()?['DATE_x0020_START'],1)
formatDateTime(triggerBody()?['DATE_x0020_END'],1)
but it continue to tell me that i've an invalid format date....what's wrong?
Thank you for your help, Best,
Luca
LucaCap
Level: Power Up

Re: Excel to outlook Calendar

Hello,

in my case the specifc issue is:

 

status code 400

 

{
  "error": {
    "errors": [
      {
        "domain""global",
        "reason""invalid",
        "message""Invalid value for: Invalid format: \"01/31/2018 09:00\" is malformed at \"/31/2018 09:00\""
      }
    ],
    "code"400,
    "message""Invalid value for: Invalid format: \"01/31/2018 09:00\" is malformed at \"/31/2018 09:00\""
  }
}

 

GFrewin
Level: Power Up

Re: Excel to outlook Calendar

Hi @abm This solution looks like just the thing I am looking for. However, I am lost at the 'create new recordscope' but in your solution. I can't find this option in Flow... from google I guess it has something to do with Dynamics 365? When I select 'add new record' as a dynamics 365 event, I am asked for organisation details which for the life of me I cannot find... am I even on the right track here? also, is this possible for a sharepoint file, rather than a file on onedrive? Thanks ! 🙂 Gary

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 327 members 6,949 guests
Please welcome our newest community members: