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:
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:
As you see the date I am receiving from the list A is 2017-09-18, but in the list A is:
And the confirmation email looks like this:
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