Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Up Program - Create Power Automate cloud ... / Only single 'eq', 'ne'...
Power Up Program - Create Power Automate cloud ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by DineshK_ 203
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:
General Discussion
  • Suggested answer
    David_MA Profile Picture
    David_MA 11,744 Super User 2025 Season 1 on at
    Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported error
    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.
  • Suggested answer
    Zdenka_Cech Profile Picture
    Zdenka_Cech 86 on at
    Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported error
    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
     

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

News and Announcements

Welcome to the Power Platform Communities

Leaderboard > Microsoft Power Up Program Community

#1
w.p Profile Picture

w.p 288

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 138 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 80 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans