Modern Table Sort not working on certain columns when connected to Document Library

(2) Share

Report

Posted on by ST-24070323-0

111

Hello All - I was using the modern table with a SharePoint Library. It displays correctly the fields that are selected. The sorting also works on fields like Created, Modified, Created By. However certain fields like Name and FilenameWithExtension when you Sort on that column throws an error on the table itself. Below is the error received:

Error when trying to retrieve data from the network: The expression "{FilenameWithExtension} asc" is not valid. Creating query failed.

I know it is a preview control. But anyone know of any workaround or solution to this. Also how do i post this as an issue to Microsoft.

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (0)

ST-24070323-0 111 on at

Like (0)

Report

Modern Table Sort not working on certain columns when connected to Document Library

What do you mean by share the whole thing. It is just a modern table which is connected to a document library. The Fields in the modern table are FilenameWithExtension, Name, Title, Modified, Modified by and so on. The modern table has the inbuilt sort which i am talking about. The sort works on Modified, Created, Modified by. As soon as i try sorting on FilenamewithExtension, Name, Link columns i get the error which i posted.
Suggested answer

Michael E. Gernaey 41,002 Super User 2025 Season 1 on at

Like (0)

Report

Modern Table Sort not working on certain columns when connected to Document Library

Hi

please share the whole thing, just showing the little bit isn't very useful as we need to see the syntax of the entire expression.

also I dont know of any sorting that use asc for it