Answered

Filter array for dates

(0) Share

Report

Posted on by Islam209

I am trying to create a flow for getting notification when uploaded documents in SharePoint online get expired and i put an expression in filter array is less than "adddays(utcnow(yyyy-MM-dd),0) ,but when i tested it ,error was come

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@less(item()?['Expirationdate'], 'adddays(utcnow(yyyy-MM-dd),1)')' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Islam209,

It looks like one of the items in your list does not have an expiration date. You can include an empty check in your expression to handle these kind of null values.

Can you try the expression below:

@less(if(empty(item()?['Expirationdate']), 'No expiration date', item()?['Expirationdate']), adddays(utcnow('yyyy-MM-dd'), 1))

Was this reply helpful? Yes No
David- 1,254 on at

Like (1)

Report
Copy link

Link copied!
I do this a bit differently. I create a scheduled flow with it scheduled to run once per day. I initialize a filter date and then set it to the current date with the expression:
formatDateTime(utcNow(),'yyyy-MM-dd')
In the get items action I use the filter date on the expiration date (Notice Date in my example below) to get the items where the expiration date is equal to today:

Was this reply helpful? Yes No
Islam209 8 on at

Like (1)

Report
Copy link

Link copied!

Thanks @Expiscornovus , this was helpful for me

Was this reply helpful? Yes No