Answered

Weekly Reminder Notification

(0) Share

Report

Posted on by Dknight7

232

Hello, I have a flow that collects the number of records with a status of "needs approval" and sends an email out to the user on a weekly basis. The issue I'm having is that the formula isn't displaying the number of approvals. It just says that I have zero when I have 11 records with an approval status of "needs approval" in my sp list. Here's a screenshot of all the info:

Screen Shot 2022-08-08 at 10.28.24 AM.png

Screen Shot 2022-08-08 at 10.27.58 AM.png

All responses (11)

Answers (1)

Verified answer

IsaCi 13 on at

Like (0)

Report

Re: Weekly Reminder Notification

Hi @Dknight7

Please try the following formula in Filter Query of your Get items action:
Status/Title eq 'Needs Approval'

Best,
Isa
Dknight7 232 on at

Like (0)

Report

Re: Weekly Reminder Notification

Also, when I do Status Source List/Status eq 'Needs Approval', I get an error
Dknight7 232 on at

Like (0)

Report

Re: Weekly Reminder Notification

Here are the screenshots:
IsaCi 13 on at

Like (0)

Report

Re: Weekly Reminder Notification

Hi @Dknight7

Could you please show me the screenshots of the run history of your flow? What is the output of your Compose action?
Also, could you please show your whole flow in the edit mode?

Maybe the flow ignores the "Send an email" action, and it might because the flow fails to filter the condition.
So could you please show your Status column in your SharePoint list?
Is your Status column a Lookup type of column?
Here is an example to check the type of column:

If it is the Lookup column, then the Filter Query syntax for the lookup column is:
InternalFieldName1/InternalFieldName2 operation 'value'
Where Internal Field name 1 is the name of the lookup column in the list, and Internal Field name 2 is the column of the Source list.
What is SharePoint column internal name and where to find it (tomriha.com)

In this example, I would write the following formula in the Filter Query:
Status/Approve eq 'Needs Approval'

Best,
Isa
Dknight7 232 on at

Like (0)

Report

Re: Weekly Reminder Notification

Here are screenshots of the other two flows I tested with the same email:
Dknight7 232 on at

Like (0)

Report

Re: Weekly Reminder Notification

It's saying it's successful, but now I'm not receiving an email at all. I've double checked my email too. Nothing shows up in spam or anything. I also added a semicolon at the end of the email too, but that didn't work. Im using the same email for two other flows and when I test them I dont have any problems.
IsaCi 13 on at

Like (1)

Report

Re: Weekly Reminder Notification

Hi @Dknight7

What is the type of your Status column? Is that a Lookup column?
Based on your description, I have made a simple test for your reference.
1. I have a SharePoint list called App list, and it contains a Lookup column called Status.
The Lookup column selects a list (which name is another) and its column (Approve) as the source.
2. Here is my flow:
length(outputs('Get_items')?['body/value'])
3. Result screenshot:

Here are some links for your reference:
Power Automate - Get items - Filter by lookup columns (angelogulisano.com)
Power Automate SharePoint Get Items Filter Query + 12 Examples - EnjoySharePoint

Best regards,
Isa
Dknight7 232 on at

Like (0)

Report

Re: Weekly Reminder Notification

no
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Weekly Reminder Notification

ok @Dknight7 ,
please run the flow and check the "Get items" outputs. Are you getting some rows in the outputs?

Please let me know.

BR,
Marco
Dknight7 232 on at

Like (0)

Report

Re: Weekly Reminder Notification

This is the current filter I have on my get items function: