I am new to Power Automate.
I have a folder in sharepoint called ” employee documents”(word docs) and another folder in the same sharepoint site called ” employee email addresses”. The documents names are the “ID” (eg: 123) that are in the employee email addresses file, which is an excel document.
example:
Employee documents
123(its a word doc)
456((its a word doc)
789(its a word doc)
***123, 456, and 789 are the TITLES of the documents***
Employee Email Addresses (an excel file, i have excel online)
Employee Name | Employee #| Employee Email
Ashley | 123 | [email protected]
Maddy | 456 | [email protected]
the output is that I want the Employee documents to be sent to the respective email address based on the Employee # in the excel document. So, document 123 will be sent to [email protected] .
Please help me, i have been trying to figure this out for 2 days and i can’t seem to really understand power automate and how to accomplish this task.
—————edit 8/7/24***
I accomplished the task using automated flow but i’ve now been asked to do it as manual flow and for some reason power automate keeps automatically creating “apply to each” and i don’t know how to avoid that. Please assist:
enter image description here
enter image description here
last image is the example flow that actually works, automated flow. but since i have to use “get file (properties only) instead of “when a file is created (properties only), i get into an automatic apply to each issue i can’t fix or understand.
enter image description here
10