Power Platform Community Forum Thread Details

Below code is not working. returned date is allways lessthan oneday. I am calling this code in powerautomate flow

DateTime AdjustDate(DateTime date)
{
if (date.DayOfWeek == DayOfWeek.Sunday)
return date.AddDays(1); // Move to Monday
else if (date.DayOfWeek == DayOfWeek.Saturday)
return date.AddDays(-1); // Move to Friday
else
return date; // No change
}

Categories:

Connector development

Hi @CU10022245-0

Code is working fine , I have checked it. But when using in Power Automate cloud flow - Date formats returned by data sources like sharepoint, excel etc would be in UTC format, also datetime returned by power automate expressions unless you are converting the UTC to your local timezone. So for example - you are using utcNow() to get current date and time , but it returns current date and time in UTC format which may be different from your timezone (may be some hours backwards which causes date to appear previous day) which would cause calculation wrong.

So to resolve that - use convertFromUtc function which helps to convert the time from UTC to other timezone such as your local timezone- before you pass the datetime value to custom code connector.

https://www.samurai-emblem.com/2023/10/09/power-automate-function-convertfromutc/

Hope it helps !

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!