web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create a date with get...
Power Automate
Answered

Create a date with get item() and a specific time.

(0) ShareShare
ReportReport
Posted on by 413

Hi there.

I need to create a specific datetime to put in a sharepoint datetime field. 

 

I have 2 datetime fields: one is with datetime, one is empty. I start from this situation, format is dd/MM/yyyy hh:mm :

Calcioscacchi_1-1675689231490.png

I set a get item() function to take this specific element from my list.

 

I create a variable to set the time:

Calcioscacchi_2-1675689307734.png

 

Then, I need to extract the date from the first field and concatenate it with the variable contains the time, and I use a compose:

 

the expression used to extract the date is 

 

formatDateTime(items('Applica_a_ogni')?['Inizio'], 'dd/MM/yyyy')

 

Calcioscacchi_3-1675689359549.png

 

The output seems correct:

 

Calcioscacchi_0-1675689187809.png

 

then why in my list appear this?

 

Calcioscacchi_4-1675689458531.png

 

some hints? 

Thanks.

 

 

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Calcioscacchi ,

     

    The point is time zone, the datetime value is UTC in flow and when you update it to your site , it will be converted to the site's time zone by default.

     

    Please check the SharePoint site's time zone and try:

    vbofengmsft_0-1675738373333.png

    Convert the time to the specific time zone.

    vbofengmsft_2-1675738560480.png

     

     

    Best Regards,

    Bof

     

  • Calcioscacchi Profile Picture
    413 on at

    This is my regional setting:

    Calcioscacchi_0-1675757593813.png

     

     

    I tried to set the desidered time (23:59:59) this way at the begin of my flow:

    Calcioscacchi_1-1675757674520.png

     

      then I do what you suggested and the output seems still different:

     

    Calcioscacchi_4-1675757968929.png

     

     

     

    Calcioscacchi_5-1675757981815.png

     

     

     

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Calcioscacchi ,

     

    Please covert UTC to W. Europe Standard Time

     

    vbofengmsft_0-1675758153505.png

     

    Best Regards,

    Bof

     

  • Calcioscacchi Profile Picture
    413 on at

    This way?

    Calcioscacchi_1-1675758434315.png

     

    Well, it seems working on the flow:

     

    Calcioscacchi_0-1675758411149.png

     

    but when the data is published, I saw this: 

    Calcioscacchi_2-1675758476511.png

    Seems legit if sharepoint think to publish my output +1 hour, but it's not what I want XD

     

    EDIT: I found the solution while I write this reply... 

    Calcioscacchi_3-1675758728555.png

     

    If sharepoint publish my datetime +1 hour, then I just give him an UTC format. This works fine:

     

    Calcioscacchi_4-1675758769357.png

     

    Is this that you suggested?

     

     

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Calcioscacchi ,

     

    Please copy exactly the content in the red box and try again.

     

    vbofengmsft_1-1675759898716.png

     

    Best Regards,
    Bof

     

     

     

  • Calcioscacchi Profile Picture
    413 on at

    Ok, there it is: 

     

    Calcioscacchi_1-1675762050783.png

     

     

     

    Calcioscacchi_0-1675762018292.png

     

    Calcioscacchi_2-1675762085623.png

    Is my solution not a good one?

  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Calcioscacchi ,

     

    Sorry , it's my fault. Please change these two value and try again.

    vbofengmsft_0-1675762354168.png

     

    Best Regards,

    Bof

     

  • Calcioscacchi Profile Picture
    413 on at

    Ok, that's precisely my solution and it works fine 😉

    Thanks for your help!

     

    Stay tuned for more questions about this flow! XD

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard