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

Extract email addresses from SharePoint HTTP Request

So what I am trying to do is replicate the classic SharePoint task list alert emails (task has been modified, task has been assigned), in a new modern SharePoint list. At the moment I am using the HTTP Request action to get all the versions of an item in the list, this is so I can retrieve the email address of anyone who would have just been removed from the Assigned To column so that they also get an email to make them aware they have been removed from the task. My flow works up until the point where I can retrieve the details of the people who were previously in the Assigned to column but them I need to somehow get the string values of their email addresses, this is where I am stuck. Any help would be greatly appreciated.

 

Following my the HTTP request and the Parse JSON I have an Initialise Variable action with the type of Object and the following expression;

 

body('Parse_JSON')?['d']?['results'][1]['AssignedTo']

 

This gets the values of the people in the Assigned To column of the previous version of the item. Which then gives an output of;

 

{

  "__metadata": {

    "type": "Collection(SP.FieldUserValue)"

  },

  "results": [

    {

      "LookupId": 4157,

      "LookupValue": "Smith, John Mr",

      "Email": "****************@********.uk "

    },

    {

      "LookupId": 19,

      "LookupValue": "Bloggs, Joe Mr",

      "Email": "****************@********.uk "

    }

  ]

}

 

How do I extract the emails from this output to then use in another action?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Like this: 

https://ibb.co/WB0yN4N

 

ExtractEmail.png

 

Please...

If I answered your question Accept it as a solution ✔️ 

If I helped you out, please give me some Kudos 👍

Thanks 😙

View solution in original post

2 REPLIES 2
Highlighted
Memorable Member
Memorable Member

Like this: 

https://ibb.co/WB0yN4N

 

ExtractEmail.png

 

Please...

If I answered your question Accept it as a solution ✔️ 

If I helped you out, please give me some Kudos 👍

Thanks 😙

View solution in original post

Highlighted

Perfect! Thanks for the assistance.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (10,968)