cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ninjaryder1st
Helper IV
Helper IV

Separating a Display Name that appears as a String without commas.

Any idea if I can use a data tool to separate or split the "display name" content into 2, and use only the first name.  

For example:  I would like to use first name only and separate the "displayname":  "bob smith"  to only "bob" and use "bob" later on in the flow with a dynamic content component.  

ninjaryder1st_0-1616630357551.png

 

6 REPLIES 6
Expiscornovus
Super User
Super User

Hi @ninjaryder1st,

 

Yes, you should be able to use a split function and use the space character for the split. Use the [0] index position to get the first part.

 

Below is an example in a couple of compose actions. 

split(outputs('Compose'), ' ')[0]

 

split_onspace.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Mira_Ghaly
Dual Super User
Dual Super User

@ninjaryder1st 

Did you try to split by space

split(displayName,' ')[0]

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Thanks, I did learn about split expressions, but my issue is that when I pull out Display Name for "compose" its places an "apply to each" function for DisplayName, and I understand that apply to each cannot be used for Initialize Variable commands.   

 

ninjaryder1st_0-1616631370120.png

 

and composing w/ split expression yields this, w/o a name : 

 

ninjaryder1st_1-1616631506224.png

 

Ok, I forgot the Compose 1 before the Compose 2 with Split expression.  That works and I've split the name, but its not allowing me to recover the first name output from the split so I can place it later in the flow under HTML format for "send and email (V2)"..

ninjaryder1st_2-1616632221245.png

ninjaryder1st_3-1616632349365.png

 

Mira_Ghaly
Dual Super User
Dual Super User

@ninjaryder1st can you add screens how your flow is structured?

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hi @Mira_Ghaly ,

 

Sure!  

ninjaryder1st_0-1616677954028.png

ninjaryder1st_1-1616677999143.png

ninjaryder1st_2-1616678030817.png

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,646)