cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ATUFAILHAASAN
Helper I
Helper I

Dropdown to Text Initials

I have a dropdown box created in the power apps and I have entered my choices as manual inputs. 

The dropdowns are names of Different users. 

I want a separate label that will display just the initials of these dropdown values and not the entire text values. 

ATUFAILHAASAN_2-1664995854438.png

 

ATUFAILHAASAN_1-1664995822275.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
cmitchener
Helper III
Helper III

I actually just had to do this exact thing in one of my apps. Here's a way to do it:

 

Concatenate(

   Left(

      First(

         Split(Dropdown3.SelectedText.Value, " " )

      ).Result, 1

   ),

   Left(

      Last(

         Split(Dropdown3.SelectedText.Value, " " )

      ).Result, 1

   )

);

 

 

 

This splits the name into 2 pieces (first and last), first grabs the first letter of the first name, then grabs the first letter of the last name, then concatenates the two. The Split function is splitting the names by the space, hence the " " in the formula.

View solution in original post

1 REPLY 1
cmitchener
Helper III
Helper III

I actually just had to do this exact thing in one of my apps. Here's a way to do it:

 

Concatenate(

   Left(

      First(

         Split(Dropdown3.SelectedText.Value, " " )

      ).Result, 1

   ),

   Left(

      Last(

         Split(Dropdown3.SelectedText.Value, " " )

      ).Result, 1

   )

);

 

 

 

This splits the name into 2 pieces (first and last), first grabs the first letter of the first name, then grabs the first letter of the last name, then concatenates the two. The Split function is splitting the names by the space, hence the " " in the formula.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,344)