cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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
Highlighted
Frequent Visitor

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
Highlighted
Helper IV
Helper IV

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
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (8,715)