Showing results for 
Search instead for 
Did you mean: 
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


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.

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.




Helpful resources


Power Automate Community User Group Member Badge

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


Incoming: New and improved badges!

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


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,620)