Unanswered

OData Filter Date Check If Null and Date filter not working

(0) Share

Report

Posted on by RazenC

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

Here's my OData Filter Query.

So here's my Power Apps

Then here's the sample input in PA

Here's the value that's been inserted

This returns no results.

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RazenC on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RazenC on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No