cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrtnM
Level: Powered On

Converted time zone not available in "Select"

Hi,

In one of my Flows, I want to insert the "Created" date in an html table, and then send an email.

I use Convert Time zone and Select to achieve this.

 

However, the Flow automatically creates an "Apply to each", and this seems to make it impossible to actually use the converted time in "Select"; only the "Created" from "Get items" is available.

 

Flow trigger is "Recurrence", then there is "Get items", and then "Convert time zone":

Namnlös3.png

 

In the email withe the thml table, this results in the ugly date/time that I want to avoid:

 

Namnlös2.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Converted time zone not available in "Select"

 

Hi @MrtnM ,

 

You can use the convertTimeZone() function directly to handle Created.

63.PNG

Expression reference:

convertTimeZone(item()['Created'],'UTC','W. Europe Standard Time','dd/MM/yyyy')

When configuring, if you don't know how to choose the time zone, you can first configure the Convert time zone, select the corresponding time zone, and then view the code through peek code.

62.PNG

64.PNG

 

Finally, these values are configured in the corresponding parameters of the function.

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Converted time zone not available in "Select"

Hi @MrtnM 

 

You need to format the date.

 

The formula is, for example:

 

formatDate(dateField,'yyyy-MM-dd')

 

Here's a handy reference:

https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

MrtnM
Level: Powered On

Re: Converted time zone not available in "Select"

Hi @manuelstgomes ,

and thanks,

but I do not quite understand how that should make any difference? The issue is that I cannot use the Converted time in the Select, it simply does not appear among the dynamic content.

I have double checked using both the formula you provided and the built-in date/time formats, the result is always the same.

Namnlös.png

 

The option to use the converted time, s in the link you provided, does not exist.

Namnlöws.png

Community Support Team
Community Support Team

Re: Converted time zone not available in "Select"

 

Hi @MrtnM ,

 

You can use the convertTimeZone() function directly to handle Created.

63.PNG

Expression reference:

convertTimeZone(item()['Created'],'UTC','W. Europe Standard Time','dd/MM/yyyy')

When configuring, if you don't know how to choose the time zone, you can first configure the Convert time zone, select the corresponding time zone, and then view the code through peek code.

62.PNG

64.PNG

 

Finally, these values are configured in the corresponding parameters of the function.

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Super User
Super User

Re: Converted time zone not available in "Select"

HI @MrtnM 

 

Dealing with dates is tricky I know, but were you able to solve this issue. Did you try @v-bacao-msft solution?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

MrtnM
Level: Powered On

Re: Converted time zone not available in "Select"

Hi @manuelstgomes ,

sorry for the delay, but yes, the solution from @v-bacao-msft worked. Thanks to the both of you 🙂

Super User
Super User

Re: Converted time zone not available in "Select"

Hi @MrtnM 

 

Awesome! Glad that all worked out :).

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (5,283)