cancel
Showing results for 
Search instead for 
Did you mean: 

Improve SharePoint connector delegibility

When you connect to SharePoint using the Sharepoint connector, there will be delegation issues if you try to filter or sort on columns like FileNameWithExtension, Name, 'Folder Path', IsFolder. There may be more, these just come to mind as most useful candidates.

 

A formula like 

SortByColumns(
    Filter( SharepointSource, 'Folder path' = path ),
    "{IsFolder}",Descending,
    "{FilenameWithExtension}",Ascending
)

appears as though it should be valid and properly delegable!

 

Earlier thread about this, and my thread for reference.

Status: New
Comments
Advocate II

It gets better (OK, actually worse), you can't use > or < (or >= or <=) on the ID field of a SharePoint list/library, even though it's a number...  and Value(ID) doesn't help.