Answered

One Drive file - last modified by NAME

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Using connectors

I have the same question (0)

All responses (20)

Answers (1)

Sort by

melim Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

@Anonymous, 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

Was this reply helpful? Yes No
melim Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
melim Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

melim Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

@v-micsh-msft @Anonymous

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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tokarjan 4 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
iPeat 8 on at

Like (1)

Report
Copy link

Link copied!

I'm I missing something? I don't see "last modified by NAME"

Was this reply helpful? Yes No
melim Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No