I have shared an Excelfile on One Drive with many people. The flow rule is being triggered on chnages made to the files in a folder. The action should be to send an email to my attention.
file in folder modified --> send email
This email should include 1.) the file name and 2.) the name of user which has done the modification (last modified by xyz).
First part is no problem, but I am not able to pull the name out of the system.
Solved! Go to Solution.
I tried your scenario and I did a 'Get file metadata' on the Excel file I edited in OneDrive. I tried getting the file metadata by id and path, but I was only able to see the 'Last modified' time stamp.
You could make the author a column in your Excel row, and pull it out from 'Get rows,' but I realize that may not work for your scenario. I can take this as a request and let you know if it's possible to find the last modified author.
Thanks for your input!
Is there any update on this?
I checked the document for OneDrive API (Microsoft Graph) regarding get the driveitem, there is Last modified by user object in the respond JSON, which is not in string format:
Is it possiable to make it available under the Dynamic Content?
@FFAlaris, would it be convenient for you to submit this as an idea in the Microsoft Flow idea forum?
I opened a task to track this work on the connectors team. While the feature is possible for the OneDrive for Business connector, they're trying to understand how this change would impact other file-based connectors. I'll update the thread when I have more information from them.
@iPeatLastModifiedBy is available for the trigger "When a file is modified (properties only)." It looks like you are using the trigger "When a file is modified." Hope this helps.
I understood that the Last Modified Name feature is now enabled in Flows. But could you please guide us on how to fetch the last modified name in Sharepoint flows.
I have used the trigger
"beim Ändern einer Datei (nur Metadaten)--> Dateimetadaten über ID abrufen --> E-Mail senden"
Not 100% sure how this is in English, but should be something like:
"on changes of a file (only Metadata): path of folder --> call file meta data via ID: path to the specific file--> send E-Mail: "
Subject: The file "Name" has been changed
the file <i> "DisplayName" <i><br> has been changed by <i>"LastModifiedBy" </i><br><br>
check it out: <br>
<a href=URL pointing to file</a>
Hope, this helps a bit
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!