Unanswered

Creating Weekly Notification

(0) Share

Report

Posted on by Dknight7

232

Hello, I have another flow that I want to create. I want to send a weekly email out that has the number of records with a status of "needs approval" in my Sp list. What type of trigger do I start with and how do I go from there?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Dknight7

Use a recurrence trigger set to fire daily.

Then, add a SharePoint get items action with a filter query

The filer query will make it so that only items with a status of Needs approval will be returned.

You can then check to see how many records were returned (length() ) and send the email.

In my example below, Status is the INTERNAL NAME of the status column (may or may not be the same as the display name).

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

how do I type the filter function? Here's a screenshot of where I currently am:

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

I want it to send an email if there are one or more records with a status of "needs approval"

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Dknight7

See the screen shot that I added above.

You can add a condition - if the output of the Compose action is greater than 0, then send the email.

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

is this how I set up the condition:

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

Last thing, it's saying that I have zero when I have 11 in my sp list:

Was this reply helpful? Yes No