cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fredl286
Regular Visitor

Filtering Table by Today's Date

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

 

flow.png

 
1 ACCEPTED SOLUTION

Accepted Solutions
fredl286
Regular Visitor

Hi,

 

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

ompose.png

View solution in original post

2 REPLIES 2
Jcook
Super User III
Super User III

Hello @fredl286 ,

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

pic1.png

 

 

Thanks,

-Josh


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





fredl286
Regular Visitor

Hi,

 

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

ompose.png

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,517)