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?
Solved! Go to 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.
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.
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:
Regards,
Michael
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.
@Anonymous do you mind posting what you have done to resolve this concern?
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.
User | Count |
---|---|
260 | |
110 | |
97 | |
56 | |
40 |