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

Categories:

Using flows

I have the same question (0)

All responses (11)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Hello @Dknight7 ,
which outputs are you getting from the "Compose" action?
I mean the following expression, that you're using, is correct:
length(outputs('Get_items')?['body/value'])
So, please check in a run the number in the Compose outputs. If it's equal to 0, like seen in the email body, it means that there's some filters in the "Get items" action.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

no

Was this reply helpful? Yes No
IsaCi 13 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

Here are screenshots of the other two flows I tested with the same email:

Was this reply helpful? Yes No
IsaCi 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

Here are the screenshots:

Was this reply helpful? Yes No
Dknight7 232 on at

Like (0)

Report

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

Was this reply helpful? Yes No