ODATA order by filename in Get Files ( Properties only)

Question

Hi, how can I order by the filename - what is the syntax for this?&nbsp; I have tried just puttingName asc&nbsp;but the flow fails.&nbsp; Please can someone help? Thanks&nbsp;

ricardo viana · Answer

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

sarahturner · Answer

Ricardo Viana&nbsp;No - so is the syntax literally just&nbsp;&nbsp;Name asc&nbsp;

ricardo viana · Answer

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

kevin_hoyt · Answer

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/

Forum Discussion

ODATA order by filename in Get Files ( Properties only)

Share

Resources