cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pre
Community Support
Community Support

Error on Convert_time_zone

Hello, I am trying to achieve the below requirement through Flow but getting error. Let me know what I am missing here::

 

Trying to submit a Form through which an event to be generated in my outlook calendar:: getting error as :: InvalidTemplate. Unable to process template language expressions for action 'Convert_time_zone' at line '1' and column '2835': 'In the template language function 'converttimezone', the value provided for the time zone id '10/23/2020 10:29:19 AM' was not valid. '.

 

Error detail:: Unable to process template language expressions for action 'Convert_time_zone' at line '1' and column '2835': 'In the template language function 'converttimezone', the value provided for the time zone id '10/23/2020 10:29:19 AM' was not valid. Please note that I tried to enter the Date time format as  "yyyy-MM-ddThh:mm:ss"

 

Thanks

11 REPLIES 11
abm
Super User
Super User

Hi @pre 

 

Could you please show a screenshot of your mappings?

 

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 blog
Power Automate Video Tutorials
pre
Community Support
Community Support

Hello @abm ,


I am not able to upload the screeshots but used the below template in Flow. The requirement is once the MS forms are filled by the employees it should trigger an email from resource mailbox , which in return should create a calendar event in outlook of all employees and they should have an option to reject or accept the event in calendar. Help me to achieve this requirement.

 

https://preview.flow.microsoft.com/en-us/galleries/public/templates/9718c800748b4224b595f7ac29e04740...

 

Thanks

Hi @pre 

 

You mentioned create a calendar event in outlook of all employees and they should have an option to reject or accept the event in calendar.  

 

The "Invite people into event" action is not supported in Office 365 outlook connector of Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

 

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Please see below post which describes an alternative method.

 

https://powerusers.microsoft.com/t5/General-Power-Automate/Send-Calendar-Invite/td-p/84712

 

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 blog
Power Automate Video Tutorials
pre
Community Support
Community Support

Hello @abm 

Thank you. But may I know what is the format to input for start time and end time. Moreover I am not able to bring up the Attendees in the Apply to each section of " select an output from previous steps". Help me on how to bring up this as well .

 

Thanks

pre
Community Support
Community Support

time convertion.JPG

Hi @pre 

 

I did tested this

 

image.png

 

The expression for the start date I used above is as follows:

 

formatDateTime(utcNow(), 'yyyy-MM-ddTHH:mm:ss')


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 blog
Power Automate Video Tutorials
pre
Community Support
Community Support

Hello @abm ,

 

I am not able complete the flow run, getting error as below. May I know what is the blocker here or what am I missing ::

 

Failed flow.jpg

 

 

Thanks

abm
Super User
Super User

Hi @pre 

 

Are you getting this error when you save the flow? 



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 blog
Power Automate Video Tutorials
pre
Community Support
Community Support

Hello @abm 

 

Yes I am getting the error when saving the Flow.

 

 

Hi @pre 

 

Do you have any specific trigger conditions under the trigger?

 

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 blog
Power Automate Video Tutorials
pre
Community Support
Community Support

Hello @abm 

I dont have any specific conditions under the Trigger .Am I missing anything here . I am just trying to implement a simple flow as you have suggested . Let me know what I am missing.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,401)