ODATA order by filename in Get Files ( Properties only)

Brass Contributor

Hi, how can I order by the filename - what is the syntax for this?  I have tried just putting

Name asc 

but the flow fails.  Please can someone help? Thanks

SarahTurner_0-1593623382904.png

 

4 Replies
That looks fine, did you find out what was wrong?

@Ricardo Viana No - so is the syntax literally just 

 

Name asc

 

That was what I thought but just tested it myself and I have the same issue, although if I create a custom column it works
You can use FileLeafRef to sort by the name of the document. See this blog post for details.
https://tomriha.com/power-automate-to-filter-file-in-sharepoint-by-file-name/