cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dknight7
Helper V
Helper V

Weekly Reminder Notification

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

1 ACCEPTED SOLUTION

Accepted Solutions
IsaCi
Regular Visitor

Hi @Dknight7 

 

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

View solution in original post

11 REPLIES 11
MarconettiMarco
Super User
Super User

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

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

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

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
Helper V
Helper V

Screen Shot 2022-08-08 at 2.33.31 PM.png

no

 

IsaCi
Regular Visitor

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.
download1.png
2. Here is my flow:
length(outputs('Get_items')?['body/value'])
download2.png
download3.png
3. Result screenshot:
download4.png
 
Best regards,
Isa

 

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. 

 

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

Screen Shot 2022-08-09 at 9.26.02 AM.png

Screen Shot 2022-08-09 at 9.26.07 AM.png

  

IsaCi
Regular Visitor

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:
download.png

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.
 
In this example, I would write the following formula in the Filter Query:
Status/Approve eq 'Needs Approval'
 
Best,
Isa

Here are the screenshots:

Screen Shot 2022-08-10 at 12.53.46 AM.png

Screen Shot 2022-08-10 at 12.53.14 AM.png

Screen Shot 2022-08-10 at 12.52.14 AM.png

   

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

IsaCi
Regular Visitor

Hi @Dknight7 

 

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,800)