cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.

View solution in original post

1 REPLY 1
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.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,901)