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 😙

Perfect! Thanks for the assistance.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,286)