Skip to main content

Notifications

Power Automate - General Discussion
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."
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,105 on at
    Re: Dataverse List Rows Filter Query Error

    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard