Been searching all over for this, but nothing that gets me exactly what I need.
Ultimate goal: Send an email with an attachment of the most recently modified Excel file from a SharePoint folder where the file starts with a specific string.
The folder has multiple files, some with the same naming convention. For example "Top Customers - yyyy-MM-dd.xlsx". I want to be able to filter down to the file that starts with "Top Customers" and has the most recent last modified date (last modified on the file property, not necessarily the date listed in the file name itself.
Once I filter down to this single file, I want to send it as an attachment via Outlook email. I've done this step many times, but filtering down to a single file has been my headache.
Hi @hgbi ,
I have built one flow and here are the steps you needed.
Above 'aj' is my document library.
Filter Query you need to use 'FileLeafRef' which is the Title of the document. You can't use Title or Name here. It will return nothing. Top tip 🙂
Here are my run results:
If you need further help please let me know.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!