Filtering Table by Today's Date

[fredl286]

Hi there,

I am creating my first flow and have a hit a hurdle..

The flow is designed to take an excel file received by email, filter it to show today's dead cases and then email the report out to people within the company.

I have it functioning and have been able to add a static Status contains 'Dead' filter.

How am I able to add a second filter to the table that only includes cases from today's date?

I have played with utcNow to no avail so thought I would look here for the answer. Screenshot of flow below

[Jcook]

Hello @fredl286 ,

Have you tried using the ';If Condition action'? something like i have don here?

Thanks,

-Josh

[fredl286 · Accepted solution]

Hi,

I was finally able to achieve what I needed using compose as shown in the screenshot, thanks.