Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

Sharepoint Time show 12 hours earlier then my timezone

(0) ShareShare
ReportReport
Posted on by 106

Hi folks. I am having problems after submitting sharepoint list item from power apps. The date and time  which i have added is 26-01-2021 10:00AM BUT WHEN I SEE RESULT In sharepoint it shows as 10:00 PM. I tied tips from blogs and forums now all times like created , modified etc showing yesterday date and time even i create now. The date default value i set today so when i create new list item to check the default date shows as yesterday please help.

  • AJ_2030 Profile Picture
    AJ_2030 4 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    Facing the same issue. Not sure if this issue was resolved

  • chandra1 Profile Picture
    chandra1 106 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    Yah so as you said I changed Date time Zone in power apps to UTC and submitted form and I have modified Flow as  when item is created ->  convert time zone -> and then added that value to update item invite  date and here is the result 

    chandra1_0-1611665804355.png


    After Approval and updated Time From convert time zone its 7:15 AM I don't understand anything at all why its happening.

    chandra1_1-1611665835515.png

     

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    @chandra1 

    In your flow you are converting from UTC so my last suggestion for you is on the powerapps you change the field to UTC  and then you convert it the same way you currently do in powerautomate

    Mira_Ghaly_1-1611649638966.png

     

     

  • chandra1 Profile Picture
    chandra1 106 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    The Value Is Local Only I have set.

     

    chandra1_0-1611648883929.png

     

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    @chandra1 

    I think the issue not on the Power Automate side ; the issue happening on the powerapp where you initially save the sharepoint list item , you need to save the correct in a correct way from the powerapps.

    So in your powerapps on the datetime picker which value you are using in the below property

    Mira_Ghaly_0-1611648672584.png

     

     

  • chandra1 Profile Picture
    chandra1 106 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    No After the approval I did not create item. 
    below I share steps please follow.

    (When an form is submitted on power apps -> Create SharePoint List item)
    then flow runs as below
    when item is Created -> Send For Approval -> If Approve send email as approved if rejected send email as rejected. but in the form I have list column as Invite Date so its for visiting purpose if its approved then the meeting will be scheduled. so in flow I used converter to send proper time in Approval and Rejected Email. so only problem is in SharePoint list item date column.

    Note :- even when in approval side before sending email I added update item action and added converted date but its giving entire some other time not related to anything.

    Thanks

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    @chandra1 

    so after your approval you save the item in sharepoint ; is this correct ?

     

    Please share the step where you save to the sharepoint list..

  • chandra1 Profile Picture
    chandra1 106 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    Yes I just created item directly from SharePoint list and its coming fine as I set. Date and Time.

    chandra1_0-1611644149149.png

     

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    @chandra1

    Your setup looks good to me, if you create item directly in sharepoint, how does the date time look like.

     

  • chandra1 Profile Picture
    chandra1 106 on at
    Re: Sharepoint Time show 12 hours earlier then my timezone

    So after i approved request with your name i added action that will updated list with id and i added date as converted expression but still its the same PM 

    chandra1_1-1611641380607.png

     

    you can see its approved and i have updated with new converted date but its still same 

    chandra1_2-1611641396348.png

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics

Restore a deleted flow