Hi everyone,
I need your help to automate a repetitive task. During the month, I collect meal receipts (just by taking photos) and then email them to the accounting department for reimbursement. So basically, I have a folder in SharePoint. In this folder, I have one Excel file that I fill throughout the month, and I have photos of my meal receipts. Employees have to email photos and the filled xlsx file to a certain email address(e.g.,accounting@mailcom) on the last working day of the month at 17:00 CET. For instance, I sent them today (31.10.2023), and in November, I will send them on 30.11.2023.
Can someone help me with this workflow? Files in a certain folder should be sent automatically to a certain email address on the last working day of month at 17:00.
It would be nice if, after the files have been sent, photos were automatically removed(sent to the recycle bin), but not the xlsx file, as I am filling the same Excel file month after month.
I found these two flows. They basically do what I want but since I am a newbie I don’t know how to combine these two flows.
this one helps to identify the last working day
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Send-an-e-mail-notification-the-last-working-day-of-the-month/td-p/787942
and this one to send all files: https://learn.microsoft.com/en-us/microsoft-365/community/power-automate-send-sharepoint-files-as-attachments
The subject of an email can be: 'Meal receipts' and body:
Dear team,
I have attached meal receipts.
Thank you
Thank you in advance
@SudeepGhatakNZ
