cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DanM19
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
Paulie78
Super User
Super User

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
Paulie78
Super User
Super User

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

Perfect! Thanks for the assistance.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,902)