Power Platform Community Forum Thread Details

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

Categories:

General topics

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! 🙌