cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
csmith67
New Member

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
abm
Super User III
Super User III

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!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

14 REPLIES 14
abm
Super User III
Super User III

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!

Learn more from my blogPower Automate Video Tutorials

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

abm
Super User III
Super User III

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!

Learn more from my blogPower Automate Video Tutorials

This is what I see when I look for Excel.

 

Flow1.jpg

This is what I see when I look for Excel.

 

Flow1.jpg

abm
Super User III
Super User III

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!

Learn more from my blogPower Automate Video Tutorials

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. 

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
Super User III
Super User III

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!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

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. 

abm
Super User III
Super User III

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!

Learn more from my blogPower Automate Video Tutorials
LucaCap
New Member

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

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
Regular Visitor

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (79,318)