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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Power Up Program Community
Suggested Answer

Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported error

(1) ShareShare
ReportReport
Posted on by 205
Hi Experts,
 
I have a excel file has more than 333k rows , but the list rows actions will have a threshold of only 100k rows to list.
So that i want to list after 2023 joining date rows.
Below the date format we are using in the file and also the error message .
 
I think we cannot use filter array action after list rows (due to the threshold issue 100k only listing and then filtering the array is not in use)
 
 
 
Please help to sort this ..
Let me know if you required more info ..
 
 
Thanks
DK
 
Categories:
I have the same question (0)
  • Suggested answer
    Zdenka_Cech Profile Picture
    101 on at
    Hi DK 
    Maybe you could try to import the excel into a sharepoint list?
    you can then easy query on the get items with filter. Mind to setup paging in the Get items settings.
    Or you could take a look to use OfficeScript to sort/filter data and you can connect to powerautomate.
    *Zdenka
     
  • Suggested answer
    David_MA Profile Picture
    13,021 Super User 2025 Season 2 on at
    Normally date filters require the use of an ISO8601 formatted date (yyyy-MM-dd). Since you have ISO 8601 selected as the date format, try modifying your filter to JoiningDate gt '2023-12-30' instead.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Microsoft Power Up Program Community

#1
timl Profile Picture

timl 375 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 44 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 32 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Introduce yourself!