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

Notifications

Announcements

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard