cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tomgardzinski
Level: Powered On

Multiple column filter

Hello Flow Community,

I'm attempting to filter a SPL and send a daily report where a survey date = today's date.

There are 6 columns which I'd like to evaluate and if they have a date = to today's date I want it to be sent in an email HTML table like so:

 

<Client Name>; <the column heading matching today's date>

For example, if ClientA is due for a 3 month survey today, ClientB is due for a 6 month survey today and ClientC is due for a 12Month2ndRequest, the result would be:

Client A       Three month

Client B        Six month

Client C        12Month2ndRequest

 

My data is organized in a SPL as such (Client Column missing):

daily report surveys1.PNG

 

The flow will start:

1. Recurrence

2. Get items

3. Compose where output = today

Then I'm lost,

 

Any thoughts on how to complete this?

 

Thanks Tom

 

2 REPLIES 2
fermoreno
Level: Powered On

Re: Multiple column filter

I think you can do it by Filterting (ODATA) from Get Items stage, so you filter what it comes from SPL but before I would create a Compose with (to get the today date)

 
formatDateTime(utcNow(), 'dmy')
as expression (or whatever format you need to match SPL)  then in Filter query add:
 
Six Month eq OUTPUT_OF_COMPOSE or Three month eq OUTPUT_OF_COMPOSE or (and so on).
 
I don't have access to sharepoint right now, will give it a try tomorrow but let me know if it works.

Fer
tomgardzinski
Level: Powered On

Re: Multiple column filter

Hi Fer,

I'll need some screenshots of the flow to make a determination if this is the correct solution.

 

Thanks,

Tom

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,937)