Answered

Power Automate Action to Extract First Name from Parenthesis in User Display Name

(0) Share

Report

Posted on by cjwilson80

I have a Power Automate Flow that sends reminder emails to users when a deadline is approaching. Right now, the name in the email body appears as "Wilson, C (Courtney)". How can I parse this out so that I can extract the first name and last name from the display name? I am running this flow on a recurrence, that runs every day and gets all items in a list that match certain criteria.

See screen shots attached. Thank you!

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@cjwilson80 Use split() function.

First Name- Last(split("Wilson, C (Courtney)"),', ')

Last Name- First(split("Wilson, C (Courtney)"),',')

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
cjwilson80 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 Do I put this in a compose action, or a set variable?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@cjwilson80 Pls use compose action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

It doesn't matter.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@VictorIvanidze Pls avoid such comment.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15, why? Do you believe that using the Compose action is better than using the "Set variable"?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@VictorIvanidze Please avoid such discussion. Pls give complete solution if possible. Also if someone is already responding to thread do not come in between. There are others unanswered threads where your input could help someone.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
cjwilson80 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 THANK YOU SO MUCH!!! This works, however.... now it displays the first name as C (Courtney). How do I remove the C () and just get Courtney?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@cjwilson80 is this applicable to all names? Or only few users have such naming style.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
cjwilson80 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 This applies to ALL names in the 'Get Items' action I'm using to pull back Condition Owners from a SharePoint list. So, every user name has a Display Name that is formatted as LastName, First Initial (First Name)

Was this reply helpful? Yes No