cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zoltan
New Member

trigger email when file is modified and include the name of modifier

Hi,

 

I have created a flow to send an automatic email when a file is modified on OneDrive.

I have two issues:

  1. an email is triggered also when someone just opens the file but does not add anything. I want an email only when the file is really modified
  2. in the message body I would like to add who modified the file but so far I could not find a way to extract this information

Can anyone advise how to achive what I want?

 

Thanks

 

Zoltan

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Zoltan,

 

Please choose the trigger "When a file is created (properties only)" instead of trigger "When a file is created".

 

Best regards,

Alice

View solution in original post

4 REPLIES 4
v-yuazh-msft
Community Support
Community Support

Hi @Zoltan,

 

Do you mean the email is triggered in your flow when someone opens the file but does not add anything?

 

I afraid that it is because the excel file would be automatically saved after some minutes,so please make sure the excel wouldn't automatically save so the trigger "When a file is modified" wouldn't triggered.

 

If you want to add who modified the file in the message body,please refer to screenshot below to create the flow:

Capture.PNG

 

 

Best regards,

Alice

Dear Alice,

 

Yes, exactly what I meant. I hoped OneDrive can sense if someone actually adds something to the file or just views it. I do not want to deactivate automatic saving as this ensure no added content will be lost. If someone just looks at the file and do not change anything then I do not want a message triggered by the automatic saving.

 

For some reason the "last modified by" dynamic content does not appear for me in the selections.

 

Best regards

 

Zoltan

 

flow last modified.JPG

Hi @Zoltan,

 

Please choose the trigger "When a file is created (properties only)" instead of trigger "When a file is created".

 

Best regards,

Alice

View solution in original post

GabrielStJohn
Microsoft
Microsoft

Hello,  @Zoltan!

Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,971)