cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Wauters
Level: Powered On

Sharepoint Delegation

We'd like to filter items of a SharePoint library based on a folder name. We keep getting delegation warnings and as a result we do miss some items in our gallery. According to the documentation, Filter & StartsWith are delegable functions when using text data types. So to my understanding the below should work (and be delegable):

 

image.png

 

When modifying the filter to check for column Title, this does seem to be delegable (but it doesn't solve our requirement):

image.png

 

This makes me think the "Path" column is not of type text but the "Title" column is? Would this be the reason? If yes, where can I find the fields and types of data the SharePoint connector returns (documentation)?

 

Additional question, what does the '{}' mean? Does this imply being a complex type? Again, documentation might help.

image.png

 

Thanks in advance!

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Sharepoint Delegation

@Wauters 

You are correct in your statement (partially) - "This makes me think the "Path" column is not of type text but the "Title" column is".

You're partly right, but the Path column is of type text.  The difference is that Path and FileName and several other columns (usually that you will see with the {}) are calculated columns (in a sense).  They don't really exist in the structure of the list/library when you define it.  However, SharePoint will generate them for you on the fly.  

And...therein lies the reason you get a delegation warning - because "on the fly" columns cannot be delegated against. 

 

Had a similar thread on this just this past week that you might want to review as well.  More importantly for a concept of how to work around it.

 

I hope this clears things up a bit for you and is helpful.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
1 REPLY 1
Highlighted
Super User
Super User

Re: Sharepoint Delegation

@Wauters 

You are correct in your statement (partially) - "This makes me think the "Path" column is not of type text but the "Title" column is".

You're partly right, but the Path column is of type text.  The difference is that Path and FileName and several other columns (usually that you will see with the {}) are calculated columns (in a sense).  They don't really exist in the structure of the list/library when you define it.  However, SharePoint will generate them for you on the fly.  

And...therein lies the reason you get a delegation warning - because "on the fly" columns cannot be delegated against. 

 

Had a similar thread on this just this past week that you might want to review as well.  More importantly for a concept of how to work around it.

 

I hope this clears things up a bit for you and is helpful.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 195 members 3,632 guests
Recent signins:
Please welcome our newest community members: