Unanswered

Filter Array action in a For each action send an emaill of all items in my sharepoint list instead of items where todays date equals date in SuggestedNextDate column

(0) Share

Report

Posted on by kevindGG

I have a Sharepoint List and Power Automate. In my 'Filter Array' action that is wrapped in a 'For each' action it is sending an email of all items in my sharepoint list instead of just the items where todays date = date value in SuggestedNextDate column. Why?

Here is the Filter Query of the body/value:

@equals(@{formatDateTime(items('For_each')?['SuggestedNextDate'], 'MM/dd/yyyy')},@{formatDateTime(utcNow(), 'MM/dd/yyyy')})

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@kevindGG Can you please share a screenshot of your flow? You'll need to check the logic of your flow.

You might find these two tutorials helpful:

Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

----

If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: 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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @kevindGG,

I think to compare the date in SP list, you should make sure the date format is 'yyyy-MM-dd':

@equals(@{formatDateTime(items('For_each')?['SuggestedNextDate'], 'yyyy-MM-dd')},@{formatDateTime(utcNow(), 'yyyy-MM-dd')})

Was this reply helpful? Yes No
Venkata Golla 78 on at

Like (0)

Report

I am guessing you put the send email action in For-each loop.

Can you please share a screenshot of your flow?

Was this reply helpful? Yes No
kevindGG 39 on at

Like (0)

Report

your change in date format does not work. here is the Flow screenshot

Was this reply helpful? Yes No
kevindGG 39 on at

Like (0)

Report

yup. see screenshot of Flow same issue exists

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@kevindGG I don't think the Filter Array action is necessary in your flow case. You need to use the Filter Query in the Get Items action.

I'm using the Classic Designer — I find the New Designer a bit buggy.

In my SP list I have 3 items with today's date.

The filter query in my Get Items action would look like this. You will need to use the internal column name of your Date 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. Ensure that the dynamic content for current date/time is between single quotes.

Return Count of Items

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. Ensure the number is what you are expecting. If not, there are a couple of things you can do.

Check the filter query. Toggle open the Get Items action and check the date output. Depending on what time you run this flow and your timezone—the output of the utcNow() function may output the next day.

If your SP list has a lot of items, you may need to toggle on pagination and set a threshold. Click on the three dots and select settings.

Toggle on pagination and set a threshold. Don't forget to scroll to the bottom and press Done.

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.

Place all other actions into the YES branch. Ensure you are selecting the value dynamic content from the Get Items action to loop through.

If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: 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

Was this reply helpful? Yes No
kevindGG 39 on at

Like (0)

Report

Thanks. I take your point that the Filter Array action is necessary in your flow case. You need to use the Filter Query in the Get Items action. But I already have a working example with Filter Query.
I'll note your above steps if needed but more interested in the possibility of using Filter Array.

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@kevindGG You've indicated that your flow isn't working. I'm saying that in your flow the filter array action isn't necessary. You just need to add a Filter Query to your flow so you can filter out the items that match your criteria BEFORE you loop through them.

Was this reply helpful? Yes No