Search with SharePoint list

[Joshann]

I am building a PowerApp that has a SharePoint list with 14,000+ records in it as its data source.  I need my users to be able to search for a text string within a field.  However, the Search function is not delegable with SharePoint, so it only searches the first 500 records if I use the Search function.  The StartsWith function is delegable, but as I said, I need my users to be able to search for a text string within a field, not for a field that starts with the text string.

Being able to search records is such a common task, that I am thinking there must be some sort of workaround for this problem.  Can anyone help me?

[v-micsh-msft]

Workaround should be:

1. Cache the SharePoint list in collection within PowerApps,

2. Consider take use of Sort () and filter together.

Adding the delegation for reference:

Delegable data sources

Regards,

Michael

[Joshann · Accepted solution]

Thank you for your reply.  Since I posted this question, I figured out how to do what I needed.  Soon I will post what I did so others might benefit from it.

[erockafella]

@Joshann do you mind posting what you have done to resolve this concern?

[Joshann · Accepted solution]

Unfortunately, it turned out that I was wrong.  There is currently no way to search a SharePoint list that has more than 5,000 records for a text string contained in a field usig PowerApps.