Unanswered

When getting the date from Dynamics, the date is 1 day behind

(0) Share

Report

Posted on by logixcrm

Good Day Community,

I have created a Flow that has a DELAY UNTIL step which is supposed to delay until a specific date which is displayed within the Dynamics 365 form - the issue is that when I add the date dynamically to the DELAY UNTIL step, the date is 1 day behind the date in Dynamics 365. (😕)

This is what the field looks like in Dynamics 365

Flow response 1.JPG

As you can see below, the date I am receiving back is 1 day behind.

Flow Response.JPG

I need to know what expression I can enter to force this date to the right date, in fact I need the date to be 2020-01-06T23:5900Z so that this date can essentially be used as an expiry time.

Below is what is currently in the Delay Until field.

Flow response 2.JPG

You help will be greatly appreciated..

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @logixcrm

Try using action Convert Time Zone. Set the right destination time.

Was this reply helpful? Yes No
logixcrm 71 on at

Like (1)

Report

Thank you for the feedback, however, the output returns the same value as the input even if I set the output to +3 or +4

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @logixcrm

Thanks for your quick reply.

Please follow the below steps:

The expression I used is as follows:

formatDateTime(variables('CRMDate'),'yyyy-MM-ddT23:59:00Z')

Here is my test result

If you need any further help please let me know.

Thanks

Was this reply helpful? Yes No
logixcrm 71 on at

Like (1)

Report

Finally I got it!

Thank you @abm your advice provided part of the solution.

Here is the final solution...

Firstly, map the date field from Dynamics 365 into the compose action

Next, use the convert time zone action to get the date into the correct format, make sure to set the base time as the output from the compose step.

Finally, you now need to compose an expression to add 1 day. here is the expression i used.
addDays(body('Convert_time_zone'), 1, 'yyyy-MM-dd')

The only issue here is that you have essentially undone the time formatting, however, this is an easy fix. After entering the expression, click on OK, then next to expression, add a time, in my case i need to time to be 5pm so I added T17:00Z

That's it, save and test the flow and you should get the following result;

Date value retrieved from Dynamics 365

The result of the time conversion

Finally the result of the delay until action, you will see 1 day has been added and the time set to 5pm

Was this reply helpful? Yes No