cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DLan
New Member

Email to item owners from devops query

I would like to send a reminder email to each work item owner from a devops query on a weekly basis.  I have a recurrence that calls a query, then an apply to each with a send email 2 inside.  Testing the flow manually correctly calls the query and returns the results, however, I cannot correctly extract the Assigned To and place it in the To field.  First, the fields from the current item do not appear in the dynamic content picker for the To field.  Second, the Assigned To field does not appear in the dynamic content picker for other slots like the subject or body.  Other fields like Title do appear in the dynamic contect picker.  I placed this in the email Subject and it populates correctly in the test.  

 

Any help would be appreciated.  

1 ACCEPTED SOLUTION

Accepted Solutions

I'm sorry,  I can't figure out how to upload a screenshot.  

 

I got this working as a Logic App.  There are two blocking issues.  First, for some reason I do not understand the DevOps connector in Flow does not pass along the "Assigned To" field.  All of the others are there, but AssignedTo is needed to figure out who to send the mail to.  Second the DevOps connector does not pass the value of this field as an email address.  It passes it as a contact e.g. "John Doe <john@doe.com>" and I needed to use several functions to pull out just the email address "john@doe.com".  Either DevOps should pass the email, or the email activity should accept the contact format like Outlook does.

 

Thank you very much!

 

Dave

View solution in original post

8 REPLIES 8
v-yuazh-msft
Community Support
Community Support

Hi @DLan,

 

Would you please share a screenshot of the configuration of your flow so we would try to provide a proper workaround for you?

 

Best regrads,

Alice

I'm sorry,  I can't figure out how to upload a screenshot.  

 

I got this working as a Logic App.  There are two blocking issues.  First, for some reason I do not understand the DevOps connector in Flow does not pass along the "Assigned To" field.  All of the others are there, but AssignedTo is needed to figure out who to send the mail to.  Second the DevOps connector does not pass the value of this field as an email address.  It passes it as a contact e.g. "John Doe <john@doe.com>" and I needed to use several functions to pull out just the email address "john@doe.com".  Either DevOps should pass the email, or the email activity should accept the contact format like Outlook does.

 

Thank you very much!

 

Dave

View solution in original post

tommytables
Frequent Visitor

I am having similar issue when using a custom identity field in DevOps to send an item via email to update stake holders.  

 

My flow attempts to send to "User Name <Username@domain.com>" instead of "username@domain.com" and fails.

 

Please help.

 

 

tommytables
Frequent Visitor

What functions did you use to pull out the emails?

It's been a while, but I think I bumped this code up to a Logic App then I could get a hold of what I needed to.  Sorry I cant be more clear.  

tommytables
Frequent Visitor

Darn, you wouldn't remember that particular Logic App?  Does anyone know how to parse this using JSON?

"body": {
"Body": "@{items('For_each')}",
"Subject": "@items('For_each')?['System.Title']",
"To": "@{first(split(last(split(items('For_each')?['System.AssignedTo'],'<')),'>'))}"
}

 

It doesn't give you the email in JSON.  Its something like "John Doe <johndoe@contoso.com>".  That magic up above gets out the email address.

Update 1/8/2020 - What worked for me is this. I needed to use Apply_to_each instead of For_each.

 

  • Manual trigger
  • Get query results
  • Apply to each
    • Select an output from previous steps: "value"
    • Send an email (V2)
      • To: "first(split(last(split(items('Apply_to_each')?['System.AssignedTo'],'<')),'>'))" (an expression; no quotes)
      • Subject: "Test"
      • Body: "Test"

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,959)