cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JKirby
Frequent Visitor

Need with Date Formatting

Need help with Flow with Dynamics 365

 

My Steps

1. Get DateX from another Column/Table. DateX is 1st of June 2021.

2. Populate the DateX obtained into a Date field Y. Date Y becomes 6th of Jan 2021. It should be 1st of June 2021.

*I have changed the dates to Long just for easy reading. I need dates to be in dd/mm/yyyy and that is 01/06/2021.

 

Please help me with the solution? And help me understand why the date changed? I have been reading for the last 1-2 hours. I understand the date is stored as UTC. Why would it be extracted correctly as 1st of June but when pushed into another Date field Y it comes 6th of Jan?

 

This is used to push the dates in Date field Y - @{outputs('Get_a_row_by_ID')?['body/new_passdateclass1@OData.Community.Display.V1.FormattedValue']}

 

 

 

JKirby_0-1624566222301.png

JKirby_1-1624566335723.png

 

 

 

1 REPLY 1
JKirby
Frequent Visitor

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,457)