Unanswered

Send Outlook Email One Hour prior to SharePoint Calendar Event

(0) Share

Report

Posted on by Community Power Pla...

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.

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Send Outlook Email One Hour prior to SharePoint Calendar Event

@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.
v-yuazh-msft on at

Like (0)

Report

Re: Send Outlook Email One Hour prior to SharePoint Calendar Event

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
Community Power Pla... on at

Like (0)

Report

Re: Send Outlook Email One Hour prior to SharePoint Calendar Event

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

Like (0)

Report

Re: Send Outlook Email One Hour prior to SharePoint Calendar Event

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.