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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter wit filed.data ...
Power Apps
Unanswered

Filter wit filed.data not works with big data

(0) ShareShare
ReportReport
Posted on by 145
Good morning
if I put  StartsWith(value.Value;drop_text.Selected.Value)), getting that filter doesn't work with big data; instead without, the filter woks.
 
Filter(dblist;StartsWith(text1;txt1.Text&&
              StartsWith(text2;txt1.Text) &&
              StartsWith(value.Value;drop_text.Selected.Value))
 
Categories:
I have the same question (0)
  • timl Profile Picture
    36,319 Super User 2025 Season 2 on at
    Re: Filter wit filed.data not works with big data

    Hi @Giorgio67 

    What data source are you using? If it's SharePoint, the StartsWith function should be delegable.

    https://docs.microsoft.com/en-us/connectors/sharepointonline/

    Also, is your intention here to definitely use the logical And operator, rather than the Or operator?

    Filter(dblist;StartsWith(text1;txt1.Text) ||
     StartsWith(text2;txt1.Text) ||
     StartsWith(value.Value;drop_text.Selected.Value))

     

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 > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard