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