
Hi
I am a newbie in Power Automate and hope to use this for my monthly housekeeping checks....
I have a folder in my one drive eg. Housekeeping which I will update monthly based on the housekeeping checks.
The folder will contain many files based on the each PIC's name. How can I achieve this by having power automate to auto get the relevant file from that folder and send email to each PIC and cc to my manager?
Eg. File with "Housekeepingdate - Tan.xlsx" added to the one drive folder. I am able to send that file to the Tan's email address and cc to my manager and sequentially to send the next file "Housekeepingdate - Ong.xlsx to that Ong's email and cc to my manager... so on.
Any advise is much appreciated.
Thank you in advance.
Joanna
Hey @simplyjojo76
After this just use condition and match it to the appropriate case and send email.
Outputs Formula: outputs('Compose_3')[0]
I hope this helps.