Adddays expression

(0) Share

Report

Posted on by Michael_Larsen

Hi all,

I am trying to create a flow that will send out a notification based on a dateTime column in SharePoint.

It does already work, sort of, but the thing is that the datetime field in SharePoint seems to be causing some issues.

This is my expression:

addDays(utcNow(),4,'dd-MM-yyyy') and this is my filterquery "ccStartdate eq addDays(utcNow(),4,'dd-MM-yyyy')"

That part work fine.

I have 3 items in SharePoint, all have the same date set in the column ccStartdate, but Power Automate insists on only recognizing the items if they have the Time set to 12AM. The moment they are set to e.g. 10AM, then nothing will happen.

So the question is, how do I work around this?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@Michael_Larsen ,
One part of your query returns a time element but the other side returns a date.

Try
formatDateTime(ccStartdate,'yyyy-mm-dd') eq addDays(utcNow(),4,'yyyy-mm-dd')

Was this reply helpful? Yes No
Michael_Larsen 29 on at

Like (0)

Report

Hi @SudeepGhatakNZ ,

Tried your suggestion, but the expression is not valid.
Did you mean to use the entire string: formatDateTime(ccStartdate,'yyyy-mm-dd') eq addDays(utcNow(),4,'yyyy-mm-dd') ?

Was this reply helpful? Yes No
Ajinder31 530 on at

Like (1)

Report

Hi @Michael_Larsen , We can use somethimg like below filter query to retrieve items for particular day irrespective of time. I think this should work but let us know if it doesn't.

ccStartdate ge 'startOfDay(utcNow())' and ccStartdate lt 'startOfDay(addDays(utcNow(), 1))'

Incase we're looking to filter on future days, we can use something like
ccStartdate ge 'startOfDay(addDays(utcNow(),4))' and ccStartdate lt 'startOfDay(addDays(utcNow(),5))'

Was this reply helpful? Yes No
Michael_Larsen 29 on at

Like (1)

Report

Hi @Ajinder31 ,
Thank you for that input.
But I actually found out something far more simple.

As I suspected, the issue had to do with the fact that the DateTime column in SharePoint was set to "Include time", which Power Automate just did not like at all, and the result was that only items where time was set to 12AM or 00.00 would work with the flow.
But changing the DateTime column to not include time fixed it right up.

Was this reply helpful? Yes No