Navigating Time Zones in Power Automate with SharePoint: A Comprehensive Super Change Guide

 

navigating-time-zones-in-power-automate
Power Automate
SharePoint Services

When working with Power Automate and SharePoint, managing time zones can be a complex task. Whether you're scheduling tasks, automating workflows, or simply trying to display the correct time on a SharePoint list, handling time zones correctly is crucial for ensuring your data is accurate and your workflows run smoothly. In this blog, we'll explore common challenges and provide step-by-step solutions to effectively manage time zones in Power Automate.

Understanding the Time Zone Challenge

SharePoint stores date and time values in Coordinated Universal Time (UTC). While this is great for consistency, it can cause issues when users in different time zones access the data. For example, a task due at 5 PM UTC will display differently for users in New York, London, and Tokyo. Power Automate, being a versatile tool, provides sever always to handle these discrepancies.

Step-by-Step Guide to Handling Time Zones in Power Automate

Step 1: Capture the Time Zone

First, it's essential to capture the user's time zone. This can be done in various ways, such as setting Regional Settings from Site Administration in Site Settings.

1. Create a SharePoint Site & List for Time Zones:

  • Create a new Site called "SPDDEMO."
  • Create a new list in SharePoint called "TimeZone."
  • Add columns for "User" (Person or Group) , "SatartDateAndTime" (Date Picker), "EndDateAndTime" (Date Picker).

2. Set the TimeZone:

  • Settings > Site Information > View all site settings > Site Administration > Regional Settings
  • Set the Time zone & Region accordingly you want.

Step 2: Retrieve the Time Zone in Power Automate

Use Power Automate to retrieve the user's time zone when the workflow runs.

1. Get List Item:

  • Add a "Get items" action to retrieve the user's time zone from the "TimeZone" list.
Get-TimeZone
  • Add a "Send Http request to SharePoint" action to retrieve the regional time zone from the " SPDDEMO " site.
  • Add method GET and Uri as _api/web/regionalSettings/Timezone

2. Get Time Zone:

Get Time Zone

3. Simplify the output using Parse JSON

  • Pass the above output Body through Parse JSON to get simplify output.
Time Setting

4. Change the sign of Bias:

  • Use one compose and called “Compose SPDDEMOBias”.
  • To Change the Bias received from the Parse JSON multiply it with -1(Minus one)
  • Use function: mul(body('Parse_JSON_SPDDEMO_Regional_Time_Setting')?['d']?['Information']?['Bias'],-1)
Compose SPDDEMO Bias

Step 3: Convert UTC to the User's Time Zone

Convert the UTC time to the user's time zone in Power Automate using simple add Minutes function and Bias.

1. Add a Compose Action:

  • Add addMinutes function and the Bias as to be added minutes and then format ‘M/dd/yyyy h:mm tt’ to the get list items in “TimeZone” list like “StartDateAndTime” , “EndDateAndTime”,” Created”, “Modified” etc.
  • Use function: addMinutes(outputs('Get_item_SPDDEMO')?['body/Created'],outputs('Compose_SPDDEMO_Bias'),'M/dd/yyyy h:mm tt')

Comments

Post a Comment

Popular posts from this blog

From Inbox to Intranet: Automate SharePoint News Posts in Real-Time

Image
  Power Automate SharePoint Services In today’s fast-paced work environment, keeping everyone updated with the latest news and announcements is crucial. With Power Automate, you can streamline the process of creating news posts in SharePoint directly from Outlook emails. This automation saves time and ensures that important information is shared quickly and efficiently. This blog walks you through the steps to set up this efficient integration. What You’ll Need Power Automate:  Included with most Microsoft 365 plans for creating automated workflows. SharePoint Site:  The destination site where your news articles will be published. Outlook Account : A Microsoft 365 Outlook account to receive emails. Step-by-Step Guide to Create Your Flow Step 1: Set Up the Trigger Begin by signing in to Power Automate and creating a new flow using the  "When a new email arrives"  trigger from Outlook. You can set specific conditions to filter the emails that will initiate the flo...
Read more

How to use flexible sections in SharePoint pages: A Simple Guide

Image
  SharePoint Services Introduction SharePoint introduced  flexible layout section , within the flexible section we can move the webpart anywhere on the  two-dimensional grid , resizing, over lapping and grouping the webparts, this guide covers how to use flexible sections in SharePoint, from adding web parts to customizing layouts for mobile views. How to add flexible section in SharePoint Page Just like adding other sections, click the  Section button . This will open the Section toolbox. In the toolbox, you will see the Flexible Section listed first. Click on  Flexible  to add a Flexible Section to your page. How to add web parts inflexible sections After adding a Flexible Section to your page, web parts cannot be added directly. Instead, you need to drag them from one of the Column Layouts into the Flexible Section, duplicate an existing web part, or use the  Toolbox pane . The Toolbox pane, located on the right side, allows you to easily add web pa...
Read more

How to Set Up Automated Reminders and Alerts in SharePoint (Step-by-Step Guide 2026)

Image
  SharePoint Services Ever missed a task because you forgot to follow up? SharePoint reminders and alerts make sure that never happens again. Whether you’re tracking project deadlines or document approvals, you can automate it all no coding required! Need help setting up your SharePoint automation? Get a free consultation today If you use  SharePoint  to manage your projects, documents, or tasks, you’ve probably faced this problem. you forget to follow up on something important until someone reminds you after it’s already late. That’s where  automated reminders and alerts  come in handy. They do the remembering for you so you can focus on your real work. In this blog, I’ll show you  two simple ways  to set up alerts and reminders in SharePoint: 1. Using the  built-in “Alert Me”  option. 2. Creating  smart reminders with Power Automate (Flow). And yes, everything here works with  SharePoint Online  (Microsoft 365). Let’s get sta...
Read more