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?

All responses (6)

Answers (0)

Dknight7 232 on at

Like (0)

Report

Re: Creating Weekly Notification

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

Like (0)

Report

Re: Creating Weekly Notification

is this how I set up the condition:
ScottShearer 25,208 Most Valuable Professional on at

Like (1)

Report

Re: Creating Weekly Notification

@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.
Dknight7 232 on at

Like (0)

Report

Re: Creating Weekly Notification

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

Like (0)

Report

Re: Creating Weekly Notification

how do I type the filter function? Here's a screenshot of where I currently am:
ScottShearer 25,208 Most Valuable Professional on at

Like (1)

Report

Re: Creating Weekly Notification

@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).