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"]
How can I extract the first and last name as content? For instance, First Name: "Joe" and Last Name: "Smith"
Thank you,
Chris
@chris_tortuga use a split expression and split on - followed by a space. Let me know if you need an example.
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
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.
User | Count |
---|---|
87 | |
37 | |
25 | |
13 | |
12 |
User | Count |
---|---|
117 | |
55 | |
36 | |
23 | |
21 |