Answered

Parsing JSON to get email address from Azure DevOps ChangeBy field

(0) Share

Report

Posted on by mvanwagoner

I am tryin got create a flow that will notify the person who change a work item that they did something wrong. I am trying to get the email address from the JSON output "John Doe <john.doe@email.com>". I only want the email, what's in between the <>. I am not proficient enough in coding to know how to pull it out. Any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @mvanwagoner ,

you can extract it using the split(...) expression and picking the desired part of the split.

split('John Doe <john.doe@email.com>', '<')[1] = john.doe@email.com> split('john.doe@email.com>', '>')[0] = john.doe@email.com if you put it together: split(split('John Doe <john.doe@email.com>', '<')[1], '>')[0]

Was this reply helpful? Yes No
mvanwagoner 13 on at

Like (0)

Report
Copy link

Link copied!

I see you gave me the split expression - I am not sure where in my flow I would actually put that. Does it come after I do the "Parse JSON"? Do I need to create some kind of variable to grab it? Can you provide a visual of where in the Flow it would be put?

I tried to do a Compose with the Split expression as the input, but I was still getting a JSON parsing issue before it even got to the compose step

Was this reply helpful? Yes No
mvanwagoner 13 on at

Like (0)

Report
Copy link

Link copied!

I keep getting this error message "InvalidJSON. The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: M. Path '', line 0, position 0.'."

Was this reply helpful? Yes No
Verified answer

mvanwagoner 13 on at

Like (0)

Report
Copy link

Link copied!

I went about this different way - FYI - I was trying to get the email address out of the ChangedBy field from an Azure DevOps work item to then use an @mention user token to send them a message. I wanted the email to be dynamic and not hard coded. I thought using the Parse JSON was the initial way to go, but I managed the same result by Initializing a variable of the "ChangedBy" field and then composing using a slice function to pull just the email out. My flow looked like this

Was this reply helpful? Yes No