I am trying to sync a List calendar with an Outlook calendar and created a condition that creates an event in the Outlook calendar when the Approval status is equal to Approved. However, I keep getting an invalid expression(s) in my condition when trying to save my flow.
If anyone can help, please let me know. Thank you!
Best,
Michael S.
InvalidTemplate. Unable to process template language expressions in action 'Create_event_(V4)* inputs at line 'O' and column '0: 'The template language function formatDateTime' expects its first parameter to be of type string. The provided value is of type "Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.
One or more Fields Provided is of type 'Null', a different type is expected.
Thank you again for all your help!
what's the error message?
It works but now I am a flow run failed error,
the start date parameter of Create Event action expects it's value to be of DateTime type can you please use this experession as a value for that property and see how it plays out
formatDateTime(triggerOutputs()?['body/StartDate'], 'yyyy-MM-ddT08:00')
Update the time value as per your requirements
--------------------------------------------------------------------------------------------------------------------
Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up 😉
Hey, so switching to the old designer helped with the condition error; however, now I am receiving an error for the start time. I used the dynamic content start date, but I received an error. I tried writing the function 'String/date-no-tz': '@triggerBody()?['StartDate']', but it says the expression is invalid
Hey, so switching to the old designer helped with the condition error; however, now I am receiving an error for the start time. I used the dynamic content start date, but I received an error. I tried writing the function 'String/date-no-tz': '@triggerBody()?['StartDate']' but it says the expression is invalid
sure let me know how you get on with it
--------------------------------------------------------------------------------------------------------------------
Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up 😉
Yeah, I used the correct dynamic content. I will try using the old designer and see if that helps. Thanks!
Hi @Mikesal1724
Can you please tell me what is the type of your Approval status column in sharepoint? if it is Choice then please make sure you selected the correct dynamic content i.e. Approval Status Value otherwise it won't be able to refer the value of your column
if you selected the correct dynamic content, please open your flow in the old designer and remove the dynamic content add it again and then try to save it, New Designer can be unexpected some times 😅
--------------------------------------------------------------------------------------------------------------------
Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up 😉
LinkedIn- https://www.linkedin.com/in/akshansharma/