Hi All,
I am having trouble to get a contact name from sharepoint list previous version.
I added below as a variable and get trying to get the employee name, then display this variable in a email.
body('Parse_JSON')?['d']?['results'][1]['EmployeeName']
However, the email show a string value like below.
{"__metadata":{"type":"SP.FieldUserValue"},"LookupId":24,"LookupValue":"George, Miller","Email":"GeorgeM@blabla.com"}
Below as the Parse Json Schema for the field employee name. Actually i just want the email to display the name which is the above "George,Miller" right after the lookupvalue.
Can anyone help me through how i can just call the Name instead of the entire string?
Thank you for your help.
"EmployeeName": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"LookupId": {
"type": "integer"
},
"LookupValue": {
"type": "string"
},
"Email": {
"type": "string"
}
}
},
