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:
Solved! Go to Solution.
Hello @Dknight7 ,
which outputs are you getting from the "Compose" action?
I mean the following expression, that you're using, is correct:
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.
ok @Dknight7 ,
please run the flow and check the "Get items" outputs. Are you getting some rows in the outputs?
Please let me know.
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.
If it is the Lookup column, then the Filter Query syntax for the lookup column is: