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
a
(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
a
(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
a
(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
a
(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