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

(2) Share

Report

Posted on by ST-24070323-0

115

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ST-24070323-0 115 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No