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

Community site session details

Session Id : SSmvOGRscdHOJGcG0g0evv
Power Automate - General Discussion
Unanswered

OData Filter Date Check If Null and Date filter not working

Like (0) ShareShare
ReportReport
Posted on 1 Nov 2023 15:14:56 by

I'm using Dataverse List Rows action. I have a Power Apps that calls a flow upon clicking a button that's passing these values. 

PowerAppsExportAllToExcelV2.Run(
 txt_requirementId.Text,
 txt_policyNumberNewCase.Text,
 dte_requirementDate.SelectedDate,
 User().Email)

 

I have 2 issues here:

1. The Date filter doesn't work whenever I select a date in power apps and I'm sure there's a data from my Dataverse. I tried changing the date format as mentioned in Date Filter OData but still no luck.

 

2. If no Date has been selected it's returning an error. Is there a way to handle null values when you are dealing with dates?

 

Here are the parameters of my Power Automate flow

 

PowerAut1.JPG

 

Here's my OData Filter Query. 

 

PowerAut2.JPG

 

So here's my Power Apps

 

PowerAut6.JPG

 

 

Then here's the sample input in PA

 

PowerAut3.JPG

 

Here's the value that's been inserted 

 

PowerAut4.JPG

 

This returns no results.

 

 

Another thing is if I click the button when there's no Date selected, PA returns this error.

PowerAut5.JPG

  • Nived_Nambiar Profile Picture
    17,982 Super User 2025 Season 2 on 02 Nov 2023 at 16:26:14
    Re: OData Filter Date Check If Null and Date filter not working

    Hi @RazenC 

     

    May be instead of date field odata filter using eq , could you try contains operator which check whether date component let's say 2023-07-17 is present in column field ?

     

    would that helps ?

     

    Refer the below links : https://sharepains.com/2019/06/10/filter-queries-in-the-list-records-action-in-the-microsoft-dataverse-connector/#contains

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • RazenC Profile Picture
    on 01 Nov 2023 at 19:29:07
    Re: OData Filter Date Check If Null and Date filter not working

    I've checked the data being returned in JSON after running the flow with results (without the Date filter row).

    Is there a way to change the format of these via Power Automate to match the equal value for '2023-07-17'?

     

    PowerAut7.JPGPowerAut8.JPG

  • RazenC Profile Picture
    on 01 Nov 2023 at 17:53:46
    Re: OData Filter Date Check If Null and Date filter not working

    Hi Nived, 

    Thank you. Totally get the point for the 2nd one. Is there an action that has some If statement capabilities to check whether a parameter is null or empty? 

     

    and lastly for the first one you've said about satisfying the conditions. It doesn't show any results also when there's a value in the CONTAINS function in requirementid and policy number. Not sure what you mean by it. 

  • Nived_Nambiar Profile Picture
    17,982 Super User 2025 Season 2 on 01 Nov 2023 at 16:23:26
    Re: OData Filter Date Check If Null and Date filter not working

    Hi @RazenC 

     

    for the first scenario, where you are not getting desired results, would it be due to the fact that other column values used within the odata filter query is not satisfied ?

     

    Also for second scenario when the date is null or empty, i would recommend to create conditional branching based on when value of date is empty use a list rows in datavase action without date column being used within OData filter query and for other conditional action use list rows with odata query having Date column.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete