Unanswered

Emailing users that have past due information needed from Excel spreadsheet (with tables)

(0) Share

Report

Posted on by KLaATu

Hello, I've started a automated flow (scheduled task) that I need a little assistance with please. So far I have everthing figured out except, how and where do I write the filter query expression that'll email the user that they're 30 days past getting the information back to me. It's a reminder date field from a excel spreadsheet located in a document library, it also has a column with their email address as well. Any assistance will be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

You could run your flow on a daily, add a Filter action after List Rows to filter all dates that are less than "Today -30"

Was this reply helpful? Yes No
KLaATu 2 on at

Like (0)

Report

Thank you sir, but I actually did "list rows present in a table" then "filter array"? Also, can you write out the full expression you used....the screenshot is blurry:(

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Hi @KLaATu ,

I am using this excel data.

As you can see that I have only one invoice which was due 30 days back.

Therefore, I am currently executing a workflow and determining the date that occurred 30 days earlier.

And then comparing it against the excel data.

Here is the full flow

Output:

Was this reply helpful? Yes No