cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chris_tortuga
Regular Visitor

How do I extract "Joe" from the output: ["Smith- Joe"]

I have a flow that pulls Bookings appointments from Outlook.

 

It takes the assigned staff member from the appointment, but the result is always (example): ["Smith- Joe"]

 

chris_tortuga_1-1620908575974.png

 

chris_tortuga_0-1620908562326.png

 

How can I extract the first and last name as content? For instance, First Name: "Joe" and Last Name: "Smith"

 

Thank you,

Chris

 

3 REPLIES 3
ScottShearer
Super User
Super User

@chris_tortuga use a split expression and split on - followed by a space.  Let me know if you need an example.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Thank for the reply @ScottShearer 

 

I'm a novice. Could you provide an example?

 

I'm guessing that I need to add an action "Set Variable (Staff Member)"

 

The value would be?

 

Thank you! Let me know if you need any additional screenshots!

Chris

@chris_tortuga 

This was a little more complicated than I realized...  Power Automate wants to treat your string as an array.  See my example below and let me know if you have any questions.

image.png

image.pngimage.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,741)