Unanswered

Extract images path from excel file to embed in Email

(0) Share

Report

Posted on by Community Power Pla...

Hi...I'm new to Flow.

I have an excel file that contains URL in a column. Each cell contains a different URL referencing an images. Basically I need a flow to go line by line, fetch the images so I could embed them in an Email. The goal is to be able to change the links in the excel file and have that change reflect in the email I send weekly.

Can you please be so kind to give a hint on how to do it?

Thanks,

Omar

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

HenWang Microsoft Employee on at

Like (0)

Report

Hi @Anonymous ,

Below is my test and it's used to get all the links inside the excel and send them in email weekly. Not sure whether this is what you want, if no, please explain more about your purpose so that I can help further:

Whole flow:

My excel: image column hold the link value

Select:

Compose action:

Send an email action:

Hope this can help.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @HenWang ,

thanks for your reply, it facilitated a good start, but the images are still showing as links although i used sharepoint path.
and here is the excel table I am using

and from the email I am getting I can see the output is all the images in the table, is there a way to have each image as a separate output?

Best Regards,
Omar

Was this reply helpful? Yes No