Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Flow is generating its own date!!

(0) ShareShare
ReportReport
Posted on by 19

Hi,

I am using MS Flow to create some flows that send emails and copy data from two lists into a third list.

In these lists I have date-time columns that are only using the date, not the time part.

The thing is this:

The list A is receiving abscence notifications which include the abscence's date and a flow send a email notification with the date among other information. The email shows the date in the correct format.

Then, I have another list (B) that receive notifications of when the abscence's period ends and once again, a flow send a notification email with the right date.

 

There is a third list (C) which is used to get track of all abscences and count the amount of days from the date that appears in the A list and the date in the B list. The problem is that the flow that runs to get the data from A and B, and then send it to C, is giving me the wrong abscence's date. Here are some images:

This is the C flow:

 

1.png

 

The trigger is when an item is created in the list B, the floaw get information from the list A - here I am interested in the Date from the list A.

Once I get that data I create a new object in the list C, I am using the date from the A list (Sjukanmälandatum). The result is this:

 

2.png

 

As you see the date I am receiving from the list A is 2017-09-18, but in the list A is:

 

3.png

 

And the confirmation email looks like this:

 

4.png

 

As you see, the email get thte right date!

Why is Flow changing the date? Other thing is that It doesn't matter what day I use in the list A, it is allways 2017-09-18 and that column doesn't have any standard date in its settings.

 

Best regards

Americo

  • Americo2018 Profile Picture
    19 on at
    Re: Flow is generating its own date!!

    Thanks,

    I will give it a try.

     

    Thanks!!

     

    Regards,

    Americo

  • Verified answer
    SandyU Profile Picture
    225 on at
    Re: Flow is generating its own date!!

    I'm happy to hear you solved the issue, @Americo2018! I think that probably without using the ID for a single item, the Flow was getting the first date value it came to when you were using the Get Items action.

     

    Regarding a "number of workdays" calculation, I just ran across this article today: https://blogs.msdn.microsoft.com/carlosfigueira/2017/09/23/excluding-weekends-and-holidays-in-date-differences-in-powerapps/

    The article explains a formula to do this in PowerApps, but I imagine you could do something similar with an expression in Flow (though I haven't tried it myself).

    - Sandy

  • Americo2018 Profile Picture
    19 on at
    Re: Flow is generating its own date!!

    Finally I solved it!

     

    But I don't know how Smiley Happy

     

    The only I did was change Get Items to Get Item and use the object ID in there.

    The rest of the flow was the same.

     

    I was looking a way to count the amount of workdays between the two dates but I only found a formula that works inside of a calculate column, do you now if that can be done with flow?

     

    Best Regards,

    Americo

  • SandyU Profile Picture
    225 on at
    Re: Flow is generating its own date!!

    Great - I'll be interested to hear if you are able to get it resolved!

     

    - Sandy

  • Verified answer
    Americo2018 Profile Picture
    19 on at
    Re: Flow is generating its own date!!

    I will need to check that before I can give you a correct answer.

    What I can say is that in the Get there is no filter at all.

    I have change the "Get Items" to "Get Item", you are right, I only need one item from the list. And for the Id I am using the "ElevID" .

     

    "I wonder if somehow it is always Getting the *first* item in List A, which does have a date of 2017-09-18...?"

    Once again, it seems you are right, I haven't noted. It seems like it is getting the date of the first object. During the day I have tested different combinations and I saw that the data was repeated but I didn't noted that maybe the flow is taking the date of the first row.

     

    I am gona take look to that tomorrow and I will take some printscreen.

     

    Thanks for the help,

    I will postback how I am doing tomorrow!!

     

    Best regards,

    Americo

     

  • SandyU Profile Picture
    225 on at
    Re: Flow is generating its own date!!

    Hi, @Americo2018!

     

    In the Get Items action, how is the Flow selecting which item from List A to get? Is there a filter by the name that's coming from the new List B item? I wonder if somehow it is always Getting the *first* item in List A, which does have a date of 2017-09-18...?

     

    Also, do you not really only want a single item from List A? That is, "Get Item" rather than "Get Items"?

     

    - Sandy

  • Leo09 Profile Picture
    212 on at
    Re: Flow is generating its own date!!

    Flow use and convert all the time to UTC time automantically. Do you know that?

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1