Get email values from excel saved in sharepoint folder

(0) Share

Report

Posted on by MysteryMadMan

I have a flow:

1. email with pdf comes to email address (xxy@neki.net)

2. pdf is saved in shared folder

3. email with link is send

What I need is the following....

Emails have to be read from an excel file saved in one folder File is a simple 3 column table. how can i get all the email in this excel file and be inserted into bcc field... ?

I am new to flows so I am loosing my mind with this quite simple flow.

Thank you

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MysteryMadMan ,

Could you please share more details about the excel?

Could you please explain more details about the requirement? Are you want to save the email body in a column of the excel table?

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
MysteryMadMan 4 on at

Like
a
(0)

Report
Copy link

Link copied!

saving pdf as an attachement to sharepoint folder already works.

What I need to implement is that the process reads a column (mail) from excel with a list of emails and insterts them into bcc field to send a "mass mail" message.

My excel is:
name, mail, note
John, john@abc.net,
Merry, mr@bgs.net,employee
....

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MysteryMadMan ,

You could refer to screenshot below to create the flow:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No