Unanswered

Excel to outlook Calendar

(0) Share

Report

Posted on 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.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
csmith67 15 on at

Like (0)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @csmith67,

Can please show me your flow screenshot?

Thanks

Was this reply helpful? Yes No
csmith67 15 on at

Like (0)

Report

This is what I see when I look for Excel.

Was this reply helpful? Yes No
csmith67 15 on at

Like (0)

Report

This is what I see when I look for Excel.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
csmith67 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
csmith67 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (3)

Report

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

Was this reply helpful? Yes No
csmith67 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No