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 filter again...
Power Automate
Answered

Dataverse filter against date only columns

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all

 

I am having trouble in configuring my flow and filtering against a date column.

In my dataverse datasource, i want to filter all project records that are due to tomorrow.

Everytime I try to filter against the date column, i either get "Syntax errors" or "Binary errors".

 

I have initialized a variable which sets the date for tomorrow

NativeNass_0-1637079810406.png

Below that I try to filter my datasource with that variable inside it.

My column in dataverse is firstit_clusterdate (this is correct)

 

When I execute my flow with following filter I get this error

NativeNass_1-1637079917294.png --> 

NativeNass_2-1637079952851.png

 

When I add double quotes around my variable I get the following error

NativeNass_4-1637080009133.png

-->

 

NativeNass_3-1637079994734.png

 

I feel like I tried almost everything in getting this thing to work.

I just want to filter everything that has the date of tomorrow in that column.

My datasource column is 

NativeNass_5-1637080068277.png

 

 

Sharepoint felt so much easier...

 

 

Thank you in advance for any help 🙂

 

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Never mind, it seems that my last effort did the trick, when exporting everything i saw that my column format was

    "firstit_clusterdate": "2021-11-17",

     

    So i changed the format in my flow 

    NativeNass_0-1637080553642.png

     

    This seems to work.

     

    Strange since this is the first time i see the date in that format, even in dataverse views is says it's different.

    I'll just leave this here in case someone else sees the same problem 🙂

  • mPeter Profile Picture
    13 on at

    I have a similar problem. I have a dataverse column called new_duedate which is "Date only". When I look at a record the format looks like this (why 03:00:00?): 

    mPeter_0-1676023950867.png

    I do not manage to make a filter for records with the due date today.

    E.g new_duedate eq formatDateTime(utcNow(),'yyyy-MM-ddT03:00:00Z') is not working.

     

  • laksh_hari Profile Picture
    12 on at

    I have a similar issue. Were you able to resolve it?

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard