Filter Array not filtering dates correctly?

[powcontributer3]

Hello, 

I am attempting to retrieve dates that contain a date greater than or equal to today. I cannot seem to figure out why it is not proper filtering out. My expression is 

@greaterOrEquals(formatDateTime(items('Apply_to_each')['Column5'],'yyyy-MM-dd'),formatDateTime(utcNow(), 'yyyy-MM-dd')))

Any help would be greatly appreciated!

[ekarim2020]

Hi @powcontributer3 ,

I would need to see the the flow actions and the data it's acting on.

But for now can you try the following modified condition in the Filter Array action:

@greaterOrEquals(formatDateTime(item()['Column5'],'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))

Could you also post a screenshot of the filter array action too.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[ManishJain]

Hi @powcontributer3 ,

Please refer to this thread :

https://powerusers.microsoft.com/t5/Building-Flows/Date-Comparison-Issues/td-p/679511

Thanks

[grantjenkins]

@powcontributer3 I'll let the other people that have already responded help you solve the date issue.

I just wanted to mention that it would likely be a much better solution if you filtered your data prior to getting to the Apply to each if possible. That way you are only iterating over a subset of items which will definitely speed up your flow.

I'd also suspect that you may not even need an Apply to each here and instead use a Select to build up your array of JSON objects. This would potentially allow your flow to complete in just a few seconds. Are you able to show the source data you are feeding into the Apply to each?

[creativeopinion]

@powcontributer3 I would agree with @grantjenkins. In your previous post, I recommended that you use a Filter Array action to filter out the items before looping through them.

In this section of a YT Tutorial I cover how to create a dynamic date range. This involves using compose action to store your dates as well as a Covert Time Zone action to ensure you are returning the correct dates. Doing this should help you see what dates you are returning. You can then use those Compose actions in your Filter Query.

Filter the items first, then use the Apply to Each action to loop through those items. The way your flow is currently set up is is incorrect. 

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[powcontributer3]

@grantjenkins 

Hello, I have the apply to each in place so that I can change the date format from a serial number to a ISO 8601. I am unable to do this within the get rows action because excel is not reading the column with dates as dates, but as a custom number format.  

[powcontributer3]

Hello, @creativeopinion 

I have the apply to each in place so that I can change the date format from a serial number to a ISO 8601. I am unable to do this within the get rows action because excel is not reading the column with dates as dates, but as a custom number format.  

[creativeopinion]

@powcontributer3 You need to select ISO 8601 in the DateTimeFormat dropdown as mentioned in my response to your previous post.