web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel List Rows filter...
Power Automate
Unanswered

Excel List Rows filter query not working for specific value or certain rows

(0) ShareShare
ReportReport
Posted on by 2

Hi, I have a table in Excel that records email events, part of that is a calculated week number field, called WkNo. I then have a scheduled task that produces a summary for the previous week. 

This has been working great for over a year, I fixed the clash where the week numbers repeated about a 2 months ago 😉

However for week 46 it just doesn't work, it's fine for 45 and 47, and yes there are records for 46. The List rows just returns 0 records.

Then it gets weird. If i change the WkNo to 50 (for testing) it still doesn't find them. If I change some from 47 to 50, it DOES find the ex47 records but still not the ex46 ones. Put things back and try with 46 again and nothing is returned.

I'm guessing there's something up with the table, but I can't see it, the records all look complete.

Any ideas where I can go with tracking down this problem?

Categories:
I have the same question (0)
  • AL-15081948-0 Profile Picture
    34 on at
    Were you able to find a resolution to this issue? I am experiencing the same thing.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard