Answered

Changing Display Form of User().Name

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

anibra 278 on at

Like
a
(1)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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