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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dataverse List Rows Fi...
Power Automate
Unanswered

Dataverse List Rows Filter Query Error

(0) ShareShare
ReportReport
Posted on by 40

I am attempting to filter my list rows function for dataverse on the month and year of the current month. To do this, I format the date column to be just 'MM-yyyy', utilizing a coalesce due to the presence of nulls, and compare it to the current 'MM-yyyy'. My function are as follow:

 

formatDateTime(coalesce(item()?['crf1c_scan_date'], addDays(utcNow(), -366)), 'MM-yyyy') eq 

formatDateTime(utcNow(),'MM-yyyy')
 
I have included a screenshot also. The error I am getting is: 
 
"message": "The left side of the 'Equal' operator must be a property of the entity."
Screenshot 2024-05-04 at 9.24.19 AM.png
Screenshot 2024-05-04 at 9.24.04 AM.png
Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @powerappspro1 

     

    The way you have written filter query is wrong, it should be in this format

     

    column internal name operator value

     

    So in your case, it should be 

     

    crf1c_scan_date eq 'formatDateTime(utcNow(),'MM-yyyy')'

     

    Also please check how crf1c_scan_date value looks like when viewing the output of List rows action, may be without providing any filter query, and then adjust the format in formatDateTime function accordingly.

     

    See below for a reference

    https://softchief.com/2022/11/08/filter-records-from-dataverse-using-createdon-field-using-power-automate/

     

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 86 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 55

#3
Ellis Karim Profile Picture

Ellis Karim 53 Super User 2026 Season 1

Last 30 days Overall leaderboard