
Hello,
I am looking for some assistance. I have a folder within a document library that has multiple excel files , in table format.
I currently have a power automate that is taking a master file and splitting this in to the multiple files based on user name, and saving each of them down in a designated folder.
Within each file there is a column called email address, and for each file i need to email a link to the file for approval.
I can do all of the email with approval link but only if i hardcode in an email address, i don't know how to extract each email address and loop it through all of the files. Any help would be appreciated as i do not know where to start with this part.
Thank you very much in advance
How can i get the email address extracted from each file and a unique email sent to the user