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:
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.