Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Convert to UTC with dynamic source time zone?

Posted on 28 Nov 2024 10:52:15 by
I am using a Power Automate flow to create an MS Planner task when an MS Form is submitted.  When we bring across the Start and Due dates, it brings them across in the local timezone format, but when somebody in a different timezone opens the Planner task then it can display a different date!  For example, user in GMT enters date for 1st Dec, but user in PST then sees the data as 30th Nov.
 
I know I can use the Convert Time Zone function in PA, but that needs me to specifically selects which timezone I'm converting from, but users from all over the world will submit this form so I don't know what local timezone they will be in.
 
Is there a way to dynamically check the local timezone of the user submitting the form, and use that timezone to then convert to UTC for entering the date in the MS Planner task?
  • VictorIvanidze Profile Picture
    VictorIvanidze 11,817 on 28 Nov 2024 at 13:39:13
    Convert to UTC with dynamic source time zone?
  • Srini007 Profile Picture
    Srini007 2,745 on 28 Nov 2024 at 11:42:52
    Convert to UTC with dynamic source time zone?
     
    I believe there is no direct way to automatically detect the exact timezone of a form submitter using power automate, but as a work around you can add a dropdown or choice field where the user can select the timezone(eg., PST, GMT, UTC etc.,) based upon that information you can convert to UTC
     
    If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.
     
    Regards,
    Srini
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard