Unanswered

Sorting Document Library on Created By and Modified by fields

Like (1) Share

Report

Posted on 17 Oct 2024 13:38:35 by NotOnUrNelly7

Hi All,

I have a gallery connected to a Sharepoint Document Library and I would like to sort the gallery based on the Modified By or Created By Fields.

The following formula is producing an error for Modified By when I add the "Editor" Field to the Sort. (Error: Cannot Sort on the Expression Type)

SortByColumns(Filter(Documents,'File Type - Original' = "Manual" || 'File Type - Original' = "Instructions" 

|| 'File Type - Original' = "Template"),"Editor",

If(locSortLoaderDescending,SortOrder.Descending,SortOrder.Ascending))

The "ThisItem" for the field in the gallery is :

ThisItem.'Modified By'.DisplayName
 
Again, this does not work when "Modified By'.DisplayName" is hard coded into the formula. 

(Error:Specific Column "Modified By'.DisplayName"  does not exist).

When I try to figure the Sharepoint FileType by clicking sort in the document library it uses " Editor"

(&sortField=Editor&viewid).

Can anyone help me with this and provide the code for Modified By and Created By.

Many Thanks

Jamie

Categories:

General Questions

All responses (2)

Answers (0)

WarrenBelz 147,384 Most Valuable Professional on 24 Oct 2024 at 23:59:35

Like (0)

Report

Sorting Document Library on Created By and Modified by fields

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
WarrenBelz 147,384 Most Valuable Professional on 18 Oct 2024 at 00:55:58

Like (0)

Report
Sorting Document Library on Created By and Modified by fields

Hi NotOnUrNelly7

Try this
SortByColumns( AddColumns( Filter( Documents, 'File Type - Original' = "Manual" || 'File Type - Original' = "Instructions" || 'File Type - Original' = "Template" ), ModSort, 'Modified By'.DisplayName ), "ModSort", If( locSortLoaderDescending, SortOrder.Descending, SortOrder.Ascending ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee