Smartsheet to Outlook Calendar Event Flow

Like (0) Share

Report

Posted on 14 Feb 2020 18:47:27 by Ben77

Trying to solve a problem between new rows in Smartsheet (trigger) and a calendar event with Outlook (Create Event V4 - action). I have used an expression from this forum to generate 'start time' and 'end time' for the event, but cannot figure out how to incorporate a specific date into the expression. Here is what I used:

first(skip(triggerBody()?['cells'],3))?['value']

first(skip(triggerBody()?['cells'],4))?['value']

With 3 being the 'start time', and 4 being the 'end time'. There is a date column available within Smartsheet. (would translate to a 0). Any ideas? Thank you.

I have the same question (0)

All responses (11)

Answers (0)

ssk262 2 on 02 Mar 2022 at 03:39:06

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

Hi, did you figure out how to do this? I'm looking to do something similar between smart sheets and outlook calendar. Thanks

Was this reply helpful? Yes No
Ben77 10 on 20 Feb 2020 at 20:54:18

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

Sorry or the delay, I have inserted the PARSE JSON trigger. However, when I test the flow, it does not succeed or fail. Just a spinning circle. Here is a screenshot of what I added.

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on 15 Feb 2020 at 17:43:13

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

@Ben77 Sure

Was this reply helpful? Yes No
Ben77 10 on 15 Feb 2020 at 17:32:54

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

Can you screenshot the PARSE JSON portion expanded?

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on 15 Feb 2020 at 17:23:07

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

@Ben77 from the json response that I use just add this response to the date of you event.

Was this reply helpful? Yes No
Ben77 10 on 15 Feb 2020 at 17:02:00

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

Forgive me, but not sure how to incorporate that into the CREATE EVENT (V4) - Outlook Calendar event. What you came up with looks like an individual action. I need the date to be apart of the event I have created already.

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on 15 Feb 2020 at 16:30:16

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

@Ben77 I try with an example I don't know if this is what you need.
So I write a row with a date in my SmartSheet and then that date I get to use it where I want.

Hope this can helps you.

Was this reply helpful? Yes No
Ben77 10 on 15 Feb 2020 at 15:33:16

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

I am hoping for the CREATE EVENT V4 action to grab a specific date from Smartsheet. The flow will successfully grab the 'start time' and 'end time' for the Outlook calendar, but will only fill it in with today's date. I need it to be date specific based on data from a column available in Smartsheet.

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on 15 Feb 2020 at 13:27:18

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

@Ben77 hi friend sorry I don't understant what you want, could you paste you compose answer and tell me what is the result you want.

Was this reply helpful? Yes No
Ben77 10 on 14 Feb 2020 at 21:51:24

Like (0)

Report

Re: Smartsheet to Outlook Calendar Event Flow

Was this reply helpful? Yes No