Is StartsWith delegable in Power Apps with SharePoint?

Yes, on text columns such as Title. In my test, Filter with StartsWith found VPN access #1517 at ID 518 with no warning. It isn't delegated on Choice or Lookup subfields, or when you wrap the column in Text() or Lower().

Why does EndsWith show a delegation warning?

SharePoint doesn't support EndsWith, so Power Apps runs it on the first 500 rows (the Data row limit). On my list it returned 0 rows for #1517, an item at ID 518, with no error.

Is Power Apps StartsWith case-sensitive?

No, when the data source is case-insensitive by default, which includes SharePoint, Dataverse, SQL Server and collections. "VPN" and "vpn" both counted 52 titles. See the StartsWith and EndsWith reference on Microsoft Learn .

How do I filter a Power Apps gallery with StartsWith on two columns?

Join two StartsWith checks with || inside Filter, for example StartsWith(Title, txtSearch.Text) || StartsWith(RequestedOnText, txtSearch.Text). SharePoint delegates Or as long as both columns are text.

Is there a startsWith function in Power Automate?

Yes. In a flow expression it's lowercase: startsWith('text', 'searchText') returns true or false, and endsWith works the same way. You can use it in a Condition or in a Power Automate filter array .

Power Apps StartsWith vs EndsWith: Delegation Tested

Think about where your users type. Search boxes almost always match the start of a value, like a ticket title or a last name, and that’s exactly what StartsWith does. EndsWith checks the last characters, which is handy for file extensions and reference numbers.

Here’s my rule after testing both on a SharePoint list with more than 500 items: use StartsWith whenever the filter runs against SharePoint, and keep EndsWith for collections, small lists or single text values. StartsWith delegates to SharePoint; EndsWith doesn’t, and it misses rows without any error.

In this tutorial, we’ll compare the Power Apps StartsWith and EndsWith functions on one real list. You’ll see the syntax, case sensitivity, the delegation warning, the wrong counts it causes, and how to switch an EndsWith search to one that finds every row.

Table of Contents:

StartsWith vs EndsWith in Power Apps at a Glance

Both functions take two pieces of text and return true or false. Here’s the syntax from Microsoft Learn:

StartsWith( Text, StartText )
EndsWith( Text, EndText )

Every test below runs on the same Service Requests list on my SPGuides site, with titles such as VPN access #1517 and Password reset #1017. Here’s how the two compared. If you’re new to formulas in canvas apps, the Power Apps tutorials hub is a good place to start.

Feature	StartsWith	EndsWith
Checks	The first characters of the text	The last characters of the text
Returns	true or false	true or false
Case-sensitive?	No (on SharePoint and collections)	No (on SharePoint and collections)
Empty search text	Returns true, so every row shows	Returns true, so every row shows
Delegable to SharePoint	Yes, on Text columns	No: yellow delegation warning
Past row 500 on SharePoint	Found (VPN access #1517, ID 518)	Missed: 0 rows for #1517
Choice or Lookup subfields	Not delegable	Not delegable
Typical use	Search-as-you-type galleries	File extensions, suffix checks

Build the Demo App Step by Step

You can follow along with any SharePoint list that has more than 500 items. Mine is Service Requests, with 620 sample requests and the columns Title, Status, Priority, Requester, DueDate, RequestedOnText and MeetingStart.