Forum Discussion
Sending Daily Emails about the Files to be Deleted Automatically Tomorrow
Hello,
We have a library that automatically deletes files added 14 days ago. We also need to set up an automatic email notification to specific individuals, notifying them of the files that will be deleted in 2 days. The email must include a hyperlink to each file. I have attempted to use Power Automate to set up a recurring email flow, but I am having trouble adding the file information to the email. Can you please assist me with this?
P.S. I am new to Power Automate and Sharepoint.
omergunduz This is a strange issue.
Try disabling new designer and use old designer once:
If you are still facing the issues. Try raising a support ticket with Microsoft. Check:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
omergunduz Can you add the screenshot of your Power automate flow, what you have tried so far?
Check these threads which might help you:
- FLOW TO SEND EMAIL WHEN DATE APPROACHES
- Send a recurring email based on specific date that has the different file attached to different email
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
I have set up a simple flow which works fine. Firstly, I use the "get files()" command, then I use a "foreach" loop with the body/value. However, it fails to add file names to the mail body. It only adds the file title, ID, etc., but not the file name. I am not sure why this is happening.
omergunduz Can you try using expression like this:
item()?['{FilenameWithExtension}']I just tried and it works for me:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
