web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Last One Month

(0) ShareShare
ReportReport
Posted on by 10

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

 

FlowFlowDate ColumnDate 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:
I have the same question (0)
  • ScottShearer Profile Picture
    25,278 Most Valuable Professional on at

    @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.

     

     

  • nniphadk Profile Picture
    10 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard