Unanswered

Get Email address from SQL and use it to send email

(0) Share

Report

Posted on by zoev_1811

Using Power Automate template. I'm Currently working on a POC to see if this process is possible:

1. Get emailID's from SQL database ( probably using an SQL query )

2. Use those ID's to send email notifications.

3. If possible send email one by one, not something like accumulated on a single email with multiple TO's.

Any idea's opinion would be gladly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

VictorIvanidze 13,073 on at

Like (0)

Report

Yes that's possible. But what's your question?

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report

Hi @zoev_1811 ,

It seems that you want to get rows from the table in the sql server and send an email to person in each row, if yes, 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
zoev_1811 6 on at

Like (0)

Report

Thanks, i was thinking about the dynamic expression, i just dont have much idea how to use it

Was this reply helpful? Yes No