How to Extract the name from claims in a Powerapps form

[A27152]

I am developing a powerapp and I need to extract the membership name in the claims data as shown in the attached picture.

You feedback is appreciated.

[Pstork1]

I'm assuming the membership name is the same as the one presented in the email address.  If so couldn't you use Split() to get the first entry in the email?

[A27152]

The email is is like belwo I think my pic is off..

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|A27111@wiXXXX.onmicrosoft.com",
Department:"",
DisplayName:"Some User",
Email:"Some.User@wiXXXX.onmicrosoft.com",
JobTitle:"",
Picture:""

I need to get to the "A27111" data.

[ohthreesixfive]

You should be able to get what your looking for by doing a double Split() like so:


First(Split(Last(Split([CLAIMS VALUE], "|")).Result, "@")).Result

If all goes according to plan, the last result of the inner split should return 'A27111@wiXXXX.onmicrosoft.com'; with the first result of the outer split then giving you 'A27111'.
Edit (6/17/2019):
I've tested it out and made some minor changes, specifically adding .Result to the end of each Split(). This will return the result as a text value for you to use.

Cheers,
Ramiro

[A27152]

I will give it a try tomorrow and let you know the results - Thanks.

[ohthreesixfive]

My pleasure, I've tested it out on my end and made a minor change. Please check my original post and give that a go.

Cheers.