Hi all,

We use lists in SharePoint to track who has read notices in our department.

Team members go into the list, select "yes" from a yes / no option in the list, and then occasionally we do a manual check.

The idea was to have a check run every two weeks automatically, see who is still marked as "no", and send them an email reminding them to check their notices.

I've got the flow finding the list, filtering who is marked as "no", but I cannot get the flow to take that user's email address and auto populate the send email function.

For now I've got it as a manual trigger.

I've tried so many different steps, using conditions, compose, different filter types. It seems when I get one part to work, another stops.

Categories:

Building flows

@EZSULD

Can you expand your Filter Array action? It's unclear what you are using this action for.

If you are only checking to see if the test dan column is equal to No, you should use the Filter Query field to filter out the items.

Filter Your Items

You will need to use the internal column name of your test dan column. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

Return Item Count

Whenever I use a Filter Query in a Get Items action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.

Insert a Compose action. Add an Expression. Use the length() function.

Select the Dynamic content tab and insert the value dynamic content from the Get Items action into the length() function.

Run a test. Review the outputs of the Compose action to ensure the number of items being filtered out is what you are expecting. If it's not, you'll need to check your filter query.

Condition Check

Add a Condition action to your flow. If items have returned (aka there is number stored in the Compose action—that is not equal to 0), add the rest of your actions to the Yes branch. If not, do nothing.

Since you are using a person column (Team Member) the Get User Profile (V2) action isn't required. When you use the person column, there is a lot of dynamic content available to select from. Use the Email dynamic content for your person column to return the email address of the user assigned to the SP item.

Note: My person column name is Person. You will need to select your respective person column email dynamic content.

You might also find this YT Tutorial helpful if you ever need to send multiple items in a single email: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram