Unanswered

Last One Month

(0) Share

Report

Posted on by nniphadk

I am pulling from a SharePoint Online List and filtering the date column to include entries from the last month

Flow FlowDate Column

And the error message that I get is
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@greater(item()?['INITIAL_x0020_APPT_x0020_DATE'], '3/01/2023')' failed: 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@nniphadk

SharePoint stores all dates internally in the yyyy-MM-dd format regardless of how they are displayed on a site. So, you need to use 2023-03-01

That said, you are better off in this case using a filter query in the Get items action

Your filter query should look something like this:

INITIAL_x0020_APPT_x0020_DATE gt '2023-03-01'

The single quotes around the date are required.

INITIAL_x0020_APPT_x0020_DATE is the internal name of your SharePoint list.

Was this reply helpful? Yes No
nniphadk 10 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer I learnt something new thanks to you.
How do I program it for each month to account for data for last month

Was this reply helpful? Yes No