Answered

Order By ODATA Value in Sharepoint Get Files (Properties Only) - Folder Name or Path

(0) Share

Report

Posted on by STLMDV

I have a Flow that emails and HTML Table of all Files Created or Modified in all sub folders in the last 7 Days. Flow works as designed EXCEPT, I want to order the output in the HTML table by the Sub Folder Name that houses the file, ascending order.

This would essentially group all the files by folder in the HTML Table. Is it Possible to use the ODATA Orderby field to set the order of the data pulled by the folder path or folder name?

Something to the affect of "Folder Path asc" I have tried countless variations of this and continually get errors stating the field/column doesn't exist

SharedScreenshot - Flow 1.3.jpg

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
There are some hidden columns for the documents in SharePoint, among them 'FileRef', which contains the whole file path including file name. You can use that in the Order By, just put there:

FileRef asc

and it'll sort the result by folder(s), subfolder(s) and file name.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @STLMDV & @tom_riha

I just tried couple of options including the FileRef and it didn't worked as expected. Initially I thought I could utilise FullPath which is the folder path but Filter Query only accepts a valid columns names.

Sorting array would have been a good option here but you could vote for this idea.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Sort-Array/idc-p/486807#

Unfortunately you won't be able to do this via Power Automate Sort Order property.

You have couple of options:

Write a custom function and execute via HTTP but you need some dev effort to achieve this.

Other option is please below link it explains how to sort some numeric values.

http://johnliu.net/blog/2018/12/how-to-implement-sort-with-microsoft-flow-in-3-actions-within-a-loop

Was this reply helpful? Yes No
STLMDV 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much, that did!

By Chance, do you know of link, document or method to lists these hidden columns?

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

@abm To me it looks fine, why do you think it's not working? Left side is using Order By = FileRef asc, right side doesn't have any Order By = sorted by defaut by ID?
@STLMDV for example here: https://dipansaha.wordpress.com/2012/07/23/useful-reference-for-sharepoint-internal-fields-name/

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @tom_riha

Thanks for your reply. Please see below.

Here aj is my library, x1 and a are the folders

The other question you asked about internal fields name. Here it is.

https://dipansaha.wordpress.com/2012/07/23/useful-reference-for-sharepoint-internal-fields-name/

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@abm I see what you mean, it's sorting by folder levels, and you'd like to sort it by the full path. I didn't see any issue because that's the sorting I expected.

Was this reply helpful? Yes No
HKEMnEEP 5 on at

Like (0)

Report
Copy link

Link copied!

Dear Tom,

Sorry for jumping into an old thread, I have exactly same question but I want to sort by the creation of date, down to second.

May you shed me some light on the ODATA syntax i should use?

Many thanks in advance.

Was this reply helpful? Yes No