Answered

Excel to outlook Calendar

Like (0) Share

Report

Posted on 22 Nov 2016 14:36:21 by csmith67

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.

All responses (14)

Answers (1)

Community Power Pla... on 07 Dec 2018 at 10:06:32

Like (0)

Report

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
LucaCap 4 on 31 Jan 2018 at 15:56:33

Like (0)

Report

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\""
  }
}
LucaCap 4 on 31 Jan 2018 at 07:08:48

Like (0)

Report

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
abm abm 32,464 Most Valuable Professional on 23 Nov 2016 at 15:22:51

Like (0)

Report

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
csmith67 15 on 23 Nov 2016 at 14:48:47

Like (0)

Report

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.
Verified answer

abm abm 32,464 Most Valuable Professional on 22 Nov 2016 at 22:22:30

Like (3)

Report

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.

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

Step 3: Flow ran successfully

Step 4: Results in my outlook calendar

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

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

Thanks
csmith67 15 on 22 Nov 2016 at 18:51:51

Like (0)

Report

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 15 on 22 Nov 2016 at 18:51:39

Like (0)

Report

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.
abm abm 32,464 Most Valuable Professional on 22 Nov 2016 at 18:45:04

Like (0)

Report

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

(2) Trigger by recurrence
csmith67 15 on 22 Nov 2016 at 18:25:48

Like (0)

Report

Re: Excel to outlook Calendar

This is what I see when I look for Excel.