Answered

Search with SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
erockafella 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No