startswith delagation warning sharepoint

[skylitedave]

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

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list

Here is the statement that is throwing the warning....

Filter(Products, StartsWith(Code,TextInput1.Text))

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??????

[Ozzie]

Hi,

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:

Account	Level1	Level2	Level3	Level3 file path (here I want to index)
	Account1
		OptyA
			File1.xlsx	Account/Account1/OptyA/File1.xlsx
			File2.doc	Account/Account1/OptyA/File2.doc
		OptyB
			File3.xlm	Account/Account1/OptyB/File3.xlm
	Account2
	Account3
		OptyC
		OptyD
			File4.jpg	Account/Account3/OptyD/File4.jpg

The column I filter is in level3.

How could I add an index at that level?

Thanks!

Ozzie

[skylitedave]

Here is my Suggestion

• Use SharePoint to save the files - put them in a document library
• Make sure you add the Account and Opportunity names as metadata to the file when you add it to the SharePoint doc library
• Create an index on Account Name field and another to the Opportunity name field in SharePoint
• Back in PowerApps, create a gallery then set the items property to filter by the account name, then sort the results by the opportunity name

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!

[RyanXExner]

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. 

[takolota]

Why am I also getting the delegation warning and limited records due to StartsWith()?

[theozapps]

Holy crap I finally figured this out.

I just needed to put my text lookup value into a variable.

For some reason, it did not like me using a control value directly or piecing together a value based on other variables + text.

[justinstevenson]

Hi there, I figured I would chime in because I experienced this problem too.

The problem? SharePoint default metadata can't be delegatable. So when you are trying to filter a document library or list with the built-in fields that are always created, that can't be delegated. Workarounds would be making the document library or list from SharePoint a collection and then filtering that, because it's saved offline.