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)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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
Copy link

Link copied!

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,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

is this how I set up the condition:

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No