I am creating an HTML table from the info of a sharepoint list. So far it was easy until I ran with the column Initiator, which I thought behaved like the column Author. The difference being that Initiator can have more than One Name on it(up until 3). So when selecting the dynamic value option that is displayed by power automate I get the following value in my table cell:
[{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser”,”Claims”:”i:0#.f|membership|[email protected]”,”DisplayName”:”xxx, xxx(xxxxx x)”,”Email”:”[email protected]”,”Picture”:”https://xxxx.sharepoint.com/teams/TCNX-knowhow-KeyUser/_layouts/15/UserPhoto.aspx?Size=L&[email protected]”,”Department”:”xxxxx”,”JobTitle”:”Mechanical Design Engineer”}]
Out of all of this I only need the value in DisplayName. I have tried with no success to loop and parse the JSON OR set a variable and try to save this elements in the variable.