*** editing post since conditions for project changed as of 8/5/2024**
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
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
ashley123@gmail.com .
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.