cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FFAlaris
Regular Visitor

One Drive file - last modified by NAME

Hi,

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.

Any ideas?

rgds

Frank

1 ACCEPTED SOLUTION

Accepted Solutions
Power Automate
Power Automate

Re: One Drive file - last modified by NAME

@v-micsh-msft @FFAlaris

 

This feature has been been deployed to all regions. Tag me if you have any issues with it and I can contact the connectors team.  Thanks for participating in our community!

View solution in original post

20 REPLIES 20
Power Automate
Power Automate

Re: One Drive file - last modified by NAME

Hello,

 

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!

Melinda

FFAlaris
Regular Visitor

Re: One Drive file - last modified by NAME

Hi Melinda,

thanks for the fast respond on this topic. I'm looking forward to have this soon as parameter in the Flow app, which is btw a great tool!!

Rgds

 

Frank

Community Support
Community Support

Re: One Drive file - last modified by NAME

Hi @melim,

 

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:

Get a DriveItem resource

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?

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power Automate
Power Automate

Re: One Drive file - last modified by NAME

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.

Power Automate
Power Automate

Re: One Drive file - last modified by NAME

This feature request was accepted by the connectors team and it should be deployed by the end of April. Thanks for contributing to our community!

Power Automate
Power Automate

Re: One Drive file - last modified by NAME

@v-micsh-msft @FFAlaris

 

This feature has been been deployed to all regions. Tag me if you have any issues with it and I can contact the connectors team.  Thanks for participating in our community!

View solution in original post

FFAlaris
Regular Visitor

Re: One Drive file - last modified by NAME

Hi, I have just tested it - with success!! Thanks to the MS team for implementing this in such a short time!!

Great Job!!

tokarjan
New Member

Re: One Drive file - last modified by NAME

Hello.

 

Would it be possible to have this dynamic content (name of the user who modified the file) also available for SharePoint usage?

 

Thanks

 

Jan Tokar

iPeat
New Member

Re: One Drive file - last modified by NAME

I'm I missing something? I don't see "last modified by NAME"Screen Shot 2018-02-16 at 8.19.09 AM.png

Power Automate
Power Automate

Re: One Drive file - last modified by NAME

@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.

iPeat
New Member

Re: One Drive file - last modified by NAME

Thank you,

except for LastModifiedBy: is Empty despite when I look on OneDrive and see a name clearly listed

Screen Shot 2018-02-16 at 1.27.56 PM.png

Power Automate
Power Automate

Re: One Drive file - last modified by NAME

I'm able to reproduce this issue too. I'll ask the connector team about it and report back with a fix ETA.

balakrishannvig
New Member

Re: One Drive file - last modified by NAME

Hi Melinda,

 

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.

 

 

 

balakrishannvig
New Member

Re: One Drive file - last modified by NAME

Hi Flaris,

 

Can you please help/guide me on how to fetch the last modified name in Microsoft Flow for Sharepoint

balakrishannvig
New Member

Re: One Drive file - last modified by NAME

Yes. @iPeat even I am facing the same issue.

 

FFAlaris
Regular Visitor

Re: One Drive file - last modified by NAME

Hi,

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

Body:

 Hi, <br>

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

 

 

FFAlaris
Regular Visitor

Re: One Drive file - last modified by NAME

LastModifiedBy.pngHere is a screenshot

Highlighted
SivaShanmukha_9
New Member

Re: One Drive file - last modified by NAME

i am not able to see that feature

 

SivaShanmukha_9
New Member

Re: One Drive file - last modified by NAME

i am not able to see your developed feature

 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,658)