Show First Name only?

[bbsin]

Hi

I have a label - User().FullName  ; how to just show First name?

is that right?

Trim(Last(FirstN(Split(User().FullName,',"),2)).Result)

Thanks

[v-albai-msft · Accepted solution]

Hi @bbsin ,

I think you can achieve this using the Office 365 Users connection.

Office365Users.MyProfile().GivenName

Best regards,

Allen

[Ethan_R · Accepted solution]

Hi @bbsin ,

You can try this in a Label

First(Split(User().FullName, " ").Result).Result

Hope this helped.

[bbsin]

Thanks @Ethan_R 

[rob7785 · Accepted solution]

Thanks, used this in combination with am/pm to create a greeting.

If(Text(Now(),"am/pm")= "AM", "Good Morning " & First(Split(User().FullName," ").Result).Result, "Good Afternoon " & First(Split(User().FullName," ").Result).Result)

[bbsin · Accepted solution]

Hi 

Thank you