Announcements
I have a drop-down menu that lists files names that are located in the Teams SP default document library in a specific folder. The code below is on the "Items" property and works but I need to list the files in A-Z ascending order. What do I need to add to make this work? Any recommendations are greatly appreciated.
Filter(Documents, 'Folder path' = "Shared Documents/Response/Files/Red/" && !IsFolder)
@Anonymous
Assuming the name of the document is stored in the Title column will this work for you?
Sort(Filter(Documents, 'Folder path' = "Shared Documents/Response/Files/Red/" && !IsFolder), Title, Ascending)
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Thank you @mdevaney for your quick response. The title field does not contain the file name so I am using the Name column field in SP to hold the file names. Your suggestion was the solution and it is much appreciated!
// Worked! Sort(Filter(Documents, 'Folder path' = "Shared Documents/Response/Files/Red/" && !IsFolder), Name, Ascending)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 432 Super User 2026 Season 2
Mohsin Ali 347
WarrenBelz 254 Most Valuable Professional
