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

Inquiry - Power Automate mailing

Good morning Dear, I have a question, does the Power automate also allow you to send an email when a file from the one driver or Sharepoint is not modified on a daily basis?
For example A file must be filled every day at 7 am if it is not filled send a notification by mail

2 ACCEPTED SOLUTIONS

Accepted Solutions
abm
Super User III
Super User III

Hi @danielhinojo 

 

Follow the below steps:

 

image.png

 

Above expressions are as follows:

formatDateTime(outputs('Get_file_metadata_using_path')?['body/LastModified'],'yyyyMMdd')

formatDateTime(utcNow(),'yyyyMMdd')

formatDateTime(outputs('Get_file_metadata_using_path')?['body/LastModified'],'HHMM')

 

Here first I am checking the last modified date is equal to todays date. Next checking the hour and minutes is less than 07:00. If true means user has modified the files. If not user not modified the file so under the no condition you can set the email notification.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Hi @danielhinojo 

 

Thanks for your reply. Did you tried  OneDrive Get file content using path?

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

4 REPLIES 4
abm
Super User III
Super User III

Hi @danielhinojo 

 

Follow the below steps:

 

image.png

 

Above expressions are as follows:

formatDateTime(outputs('Get_file_metadata_using_path')?['body/LastModified'],'yyyyMMdd')

formatDateTime(utcNow(),'yyyyMMdd')

formatDateTime(outputs('Get_file_metadata_using_path')?['body/LastModified'],'HHMM')

 

Here first I am checking the last modified date is equal to todays date. Next checking the hour and minutes is less than 07:00. If true means user has modified the files. If not user not modified the file so under the no condition you can set the email notification.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

 
 

 

Thank you very much it helped me a lot, one more query please I want to attach in that notification the file that I am validating in this case is an .xls and it is in one drive, I have looked for options but it does not allow me please if you could help me
 
 
 

Hi @danielhinojo 

 

Thanks for your reply. Did you tried  OneDrive Get file content using path?

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Thank you very much it worked for me, one more query please I would like to validate the content of an excel to see if they fill it daily, for example: I have a daily checklist that must be completed, within this checklist there are tabs for months and within each tab they are in the cells the days in the columns, how could I validate according to the day today if the corresponding column was completed correctly

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (30,914)