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
Solved! Go to Solution.
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
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-d...
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
Proud to be a Flownaut!
Flow use and convert all the time to UTC time automantically. Do you know that?
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
Proud to be a Flownaut!
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
Great - I'll be interested to hear if you are able to get it resolved!
- Sandy
Proud to be a Flownaut!
Finally I solved it!
But I don't know how
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
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-d...
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
Proud to be a Flownaut!
Thanks,
I will give it a try.
Thanks!!
Regards,
Americo
User | Count |
---|---|
71 | |
50 | |
47 | |
28 | |
18 |
User | Count |
---|---|
27 | |
26 | |
24 | |
20 | |
19 |