Hi everyone,
I'm trying to build a flow that sends an email to specific recipients and uses as attachment a file specific to each recipient (e.g. sending an email to Mr Brown with the correct attachment file "Curriculum vitae_MrBrown"); all the files that must be used as attachment are stored in a Sharepoint folder, and all the information regarding recipients are stored in a table in Excel file (name and surname, email address, name of the specific attachment file, etc.).
I've already managed to build a simplified flow that works fine (it retrieves recipients' info from the Excel table and then, for each of them, retrieves the attachment file from the Sharepoint folder and sends the email), but only if I use the same file as attachment (meaning, for example sending the email to all recipients with the same file attached "Curriculum vitae_MrBrown").
To make this simplified version work, in the "Get file metadata" and "Get file content" actions I inserted the name of one of the files in the Sharepoint folder (highlighted in yellow in the screens below) as an example, but actually I need the flow to retrieve and attach the correct file associated to each final recipient.
I tried to run the flow several time and it always works fine with the same attachment file "Tartarelli_AnnaChiara_ANL_DDP ADV_CV_Mar24.pptx", here you can find the raw Input and Output for the main steps:
"GET FILE METADATA" raw Input >
"GET FILE METADATA" raw Output >
"GET FILE CONTENT" raw Input >
"GET FILE CONTENT" raw Output > see attachment section
"SEND AN EMAIL" raw Input > see attachment section
"SEND AN EMAIL" raw Output >
Hope someone can help me, thank you very much in advance!
