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
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 (3,524)