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?
Solved! Go to Solution.
Like this:
Please...
If I answered your question Accept it as a solution ✔️
If I helped you out, please give me some Kudos 👍
Thanks 😙
Like this:
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
26 | |
25 | |
25 | |
20 | |
15 |
User | Count |
---|---|
54 | |
46 | |
33 | |
32 | |
30 |