Answered

AddDays help - was working until 2022

(0) Share

Report

Posted on by BrianQW

I have an automated workflow that runs every morning (tried to attach a pic of the flow as a cover photo). The workflow looks at 2 folder locations on sharepoint, pulls in Get files (properties only) and then filters this data to ultimately send an email with 2 tables of all the files created/added the previous day.

This worked great until we hit 2022. Now when the workflow runs it is generating a massive list of files created/added since the previous day. I feel like it's ignoring the year and just pulling together a list of everything created since Jan 2 without checking the year?

Filter array is doing this:

formatDateTime(item()?['Created'], 'MM/dd/yyyy')

is greater than or equal to

AddDays(utcnow(), -1, 'MM/dd/yyyy')

advanced mode if you prefer: @greaterOrEquals(formatDateTime(item()?['Created'], 'MM/dd/yyyy'), AddDays(utcnow(), -1, 'MM/dd/yyyy'))

Can anyone help?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

BrianQW 28 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

Jronash 827 on at

Like (0)

Report
Copy link

Link copied!
This actually makes some sense, because your greaterThanOrEquals expression is comparing the dates as numbers, not dates.

As numbers, 12/31/2021 is greater than 01/01/2022.

So you need to reformat your dates so that it results in a number where the higher the date, the higher the number. Try it in Year/Month/Day format :
formatDateTime(item()?['Created'], 'yyyyMMdd')
AddDays(utcnow(), -1, 'yyyyMMdd')

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @BrianQW ，

Using FormatDateTime will convert date time values to string(dd-MM-yyyy or dd/MM/yyyy), which could not be compared properly because of the minus or slash(division) sign.

Please use the Created column value and compare it with AddDays(utcnow(), -1) without formatting text:

@greaterOrEquals(item()?['Created'], AddDays(utcnow(), -1))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
BrianQW 28 on at

Like (0)

Report
Copy link

Link copied!

Thank you both!!!! This isn't easy for a finance guy 🙂

Was this reply helpful? Yes No