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.

MicrosoftTeams-im...

All responses (5)

Answers (0)

SamLed 2,332 Moderator on at

Like (1)

Report

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

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.
Sukesh_Reddy09 5 on at

Like (0)

Report

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

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
SamLed 2,332 Moderator on at

Like (0)

Report

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

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.
Sukesh_Reddy09 5 on at

Like (0)

Report

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

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
SamLed 2,332 Moderator on at

Like (0)

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

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.

Community site session details

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

______________________________________________________________

______________________________________________________________

______________________________________________________________

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

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

______________________________________________________________

______________________________________________________________

______________________________________________________________

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates