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.
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
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! 🙌
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'?
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.
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.
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! 🙌
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2