Email address in string

[Haz]

Hi ,

Can someone advise me how can i obtain the email address from this string using Powerbi DAX ?

[{"displayName":null,"modifiedProperties":[],"userPrincipalName":"murray.mclaren@abc.com","id":"ecf6f9a6-1bca-4733-a9a6-623071a5c416"}]

[PattemManohar]

@Haz Please try this.. I've intentionally made it into different steps so that it will be easy to debug and for understanding as well.

Email = 
VAR _Search1 = SEARCH("userPrincipalName",Test53StrExtraction[Data])
VAR _SearchVal1 = MID(Test53StrExtraction[Data],_Search1,LEN(Test53StrExtraction[Data]))
VAR _Search2 = SEARCH(":",_SearchVal1)
VAR _SearchVal2 = MID(_SearchVal1,_Search2+2,LEN(_SearchVal1))
VAR _Search3 = SEARCH(",",_SearchVal2)
RETURN MID(_SearchVal2,1,_Search3-2)

I suggest to transform all these kind of data in Power Query rather in DAX.