Power Automate Error - The execution of template action Filter array is skipped

[Pratickkumar]

I am trying to send emails automatically using power automate taking the help of YouTube video. 

https://youtu.be/1g7NA5hYYSo?si=LqabMqgOSIiz2Q6M

From @Myonelinetraininghub , initially it was working but now it has stopped working and I am getting an error. 

I feel it's value cant be obtain the value from excel. I checked it is showing "[ ]".

Please help someone. 

 

 

[creativeopinion]

@Pratickkumar The reason your Filter Array action skips is because it's nested inside an Apply to Each action. The Apply to Each action requires an array of items to loop through. 

In your case, it's a row from the List Row Present in a Table action. However, in your screenshot it shows that there are no rows returned from the List Rows Present in a Table action.

The cause of this could be a couple of reasons:

• If you are using a Filter Query in the List Rows present in a table action, none of the rows match your Filter Query. Keep in mind, you can only use a single condition in the Filter Query field of the List Rows Present in a Table action.
• You have more than 256 rows in your Excel Table. By default, the List Rows Present in a table action will return 256 rows per call. To increase this, you'll need to toggle on pagination for the List Rows Present in a table action. The maximum number of rows that can be returned per call when pagination is enabled is 5000 rows.

For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

---

To learn more about how to use the Filter Array action, please refer to this YT Tutorial: 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

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

[Pratickkumar]

No My excel sheet data is lesser than 256 rows. And yes I am using one filter query. I have posted a screenshot of the same. but when I remove that query then I am able to receive mails while running. But when I add the filter query it doesn't.  And I have attached a screenshot of the formatting of dates in my excel 

 

•  

[creativeopinion]

@Pratickkumar When using the eq (equals to) operator the filter query is looking for an exact match. You've formatted your date in this format:

Yet, the date format in Excel is different:

Your filter query will always return zero results because there isn't a match. You'll need to adjust your format so there is a match.

You may be interested in this YT Tutorial: How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:

✅ 4 Date Functions You Need to Know

✅ How to use the Convert Time Zone Action

✅ How to Get a Future Date

✅ How to Get a Past Date

✅ How to Return SharePoint Items Due in a Number of Days

✅ How to Return SharePoint Items Due within a Date Range

✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

✅ How to Calculate the Number of Days between Two Dates

✅ How to Check for a Birthdate and Anniversary Date

✅ How to work with Dates and Times in Excel

✅ How to use a Manual Trigger with Date Input

✅ How to Output Dynamic Text with an Expression

✅ How to Check if a Date Falls on a Weekend

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