Unanswered

Send Outlook Email One Hour prior to SharePoint Calendar Event

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I'm trying to set up a Microsoft Flow that basically grabs all the 'SharePoint Calendar List' events and emails the specified user when the event is set to 'Start Time' one hour before the event.

This is the error that I am currently stuck on when Testing

InvalidTemplate. Unable to process template language expressions for action 'Apply_to_each' at line '1' and column '2580': 'The template language function 'utcNow' expects its parameter to be of type string. The provided value is of type 'Integer'. Please see https://aka.ms/logicexpressions#utcnow for usage details.'.

Here is what my current setup currently looks like, please make any adjustments that you deem might be necessary.

Please let me know if this is not the correct formating.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

PieterVeenstra 33 on at

Like (0)

Report
Copy link

Link copied!

I think that your condition should look like this:

@equals(triggerBody()['key-button-date'], addHours(utcNow(), 1))

where triggerBody()['key-button-date'] is the date that you are comparing against.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I've tried this, but sadly it hasn't worked so far - Just tosses the 'This isn't a condition' error.

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Could you please share more details about the SharePoint Calendar List?

Why are you use the trigger "when a file is created" instead of the "When an item is created"?

Could you please share more details about the expression in the Input field of the Apply to each?

Could you please share a screenshot of the run history when the flow run failed with error that you mentioned?

Please share more details so we could try to provide a proper workaround for you.

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-yuazh-msft,

Sorry! Here are the updated pictures where I'm still having the problems sadly. It's erroring out on the get event action.

Was this reply helpful? Yes No