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

list item time export in current time zone

We have multiple lists with date/time fields and the data entered is the current time zone time.

However, when we run Flows to export list items to CSV files the date/time exported is in Zulu/GMT/GMT-0 instead of current time zone.

Our flow export is triggered daily at the same time as opposed to list item event.

 

Any known resolution to this?

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: list item time export in current time zone

Hi @ jp_safeauto,

 

Could you please share a screenshot of the configuration of your flow?

 

All data time in Microsoft flow is in UTC format, so Microsoft flow would always treat the data time in sharepoint as a UTC time when export list items to CSV files.

 

Please explain more details about your needs so we could try to provide a proper workaround for you.

 

 

Regards,
Alice Zhang

jp_safeauto
Level: Powered On

Re: list item time export in current time zone

Thanks for the reply, Alice!

We want to export the time which is in ET in our lists in the same time zone.

What you state in your reply about the time in UTC-0 is what we see in all of our date/time fields exported from lists.

But, this is not what we desire, we want the list time zone to be preserved when exported to CSV file using Flow.

 

 

CCC Flow snapshot.png

jp_safeauto
Level: Powered On

Re: list item time export in current time zone

Alice, were you or someone else going to confirm we can NOT configure Flow export process to export date/time in desired time zone, same as our portal's regional settings?

Thanks!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,567)