Answered

Changing Display Form of User().Name

(0) Share

Report

Posted on by Community Power Pla...

I made an App for my Project Managers through which they can actualize their Projects.

In the first Screen they now see all active Projects while I'd like them to only see the one they are managing.

In order to achieve this I inserted a Search function in the Gallery Item Propriety whcih works if one inserts his name manuelly in the Search Bar I made.

I'd like the App to automatically show the right Projects by matching the User().Name with the Names in the Managers Column of my Database. The Problem i encountered is that the Names in my Database are stored as Initial First Name. Last Name (Ex. J. Smith).

How might I transform the name which I get from User().Name in this form?

Thank you very much.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

anibra 278 on at

Like (1)

Report

Hi @Anonymous ,
to get the initials of the name (J.) -> Concatenate(Left(Left(User().FullName,Find(" ",User().FullName)),1),".")
to get last name-> Right(User().FullName,Find(" ",User().FullName))
to get the name in format J. Smith) -> Concatenate(Concatenate(Left(Left(User().FullName,Find(" ",User().FullName)),1),". "),Right(User().FullName,Find(" ",User().FullName)))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @anibra
Thank you very much this does in fact goes in the right direction.
Somehow it does not give the full last name but just a part of it.
Ex. Muster Mustermann becomes M. ermann

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Anonymous ,

Please try:

1\Add an office365Users connection

2\Try this formula:

With({TheRecord:Office365Users.MyProfileV2()},TheRecord.givenName & " " & TheRecord.surname)

or

With({TheRecord:Office365Users.MyProfileV2()},TheRecord.surname & " " & TheRecord.givenName)

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Dear @v-bofeng-msft

Thank you for your Answer.

This way though gives the name of the user but not in the format I'd need it to be.

The Name is given as Bill Example will I need it as B. Example.

Thank you

Best Regards,
TMue

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

For whomever might have the same issue

Concatenate(Left(User().FullName; 1); "."; " "; With({TheRecord: 'Office365-Benutzer'.MyProfileV2()}; TheRecord.surname))

This gives the name in the needed format.

I use the german version so u'll have to subsititute ; for ; and change the name of the Office connector

Was this reply helpful? Yes No