How to send email to assigned to people if work items in ADO, by getting the query details.

(0) Share

Report

Posted on by Sukesh_Reddy09

I am trying to get the ADO query details and send email to the Assigned to people in that query.

tried the below flow but is not sending out the emails but running for days. any help will be appreciated.

Categories:

Using flows

MicrosoftTeams-im...

I have the same question (0)

All responses (5)

Answers (0)

SamLed 2,338 Moderator on at

Like (0)

Report
Hi,
Ok, few questions :
the "Assigned To" contains one or many emails ?
Why are you appending "Assigned to" to a string variable and use the "Assigned To" dynamic content in send mail instead of your variable.
Have you thought to add semi-colon after "Assigned To" in order to separate email in your variable ?
Why using "Send an email notification (V3)" instead of "Send an email (V2)" ?
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Sukesh_Reddy09 5 on at

Like (0)

Report

Our query contains 82 work items each has its own assigned owner, so i want to send emails individually to those people on the existing mail thread.

Is this Possible?

ss.jpg

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report

Possible, if value of Assigned To is an email else you'll need to get email from else where according to Assigned To.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Sukesh_Reddy09 5 on at

Like (0)

Report

Assigned to looks like this, it contains name and email.

i tried to add email as a separate column but ADO doesn't provide email as an option.

sss.jpg

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report

If ADO gives "fullname <email>" try this expression in your send email to field :

slice([assigned to], add(indexOf([assigned to], '<'),1), indexOf([assigned to], '>'))

Where [assigned to] is dynamic content "Assigned to".

______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No