Why am I getting a delagation warning using StartsWith in a filter against a single line of text in a SharePoint list?
Documentation says that Startswith is delegable ( is that a word) when using with a Filter in SharePoint
Here is the statement that is throwing the warning....
Documentation says this should work so what's up with the warning? Can you use Startswith within a filter against a single line of text in a SharePoint list or not??????
Thanks sky for your response.
Adding an index sounded interesting and I suspect it would possibly work for an item list.
The problem I have is that the powerapp is embedded in dynamics. It gets customer and opportunity information, and then retrieves a list of files that are linked to that opportunity and underlying folders.
The folder structure in place starts from the Account, then a folder for the account. Underneath, a folder is created for the opportunity, and underneath, files and folders created in dynamics are visible there.
The filter aims to find files/folders in sharepoint whose path starts with the account/opty combination.
So the structure would look like:
Level3 file path (here I want to index)
The column I filter is in level3.
How could I add an index at that level?
Here is my Suggestion
This will give you what you are looking for
If you step back, Folders are really just metadata with a pretty face... You can mimic their functionality using filtering and sorting 🙂
Best of luck!
Any update to this?
Changing the items property to a collection and populating the collection onselect works, but it pulls back a lot of data and sets the IsSearchable property to false.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.