Extract First Name

(0) Share

Report

Posted on by Canadiansal

310

I am using a flow to extract send an email once a row is inserted in a SP list.

In the email body, I will like to use the User's First name.

Currently, I am using "CreatedbyDisplayName" which has the full name of the users. How to I extract just the First name?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

jinivthakkar 4,187 on at

Like (2)

Report

@Canadiansal You can use following action and try Preferred name

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (2)

Report
@Canadiansal If you just want to get from CreateByDisplay name, you can get by initialise the variable and the default value would be

split(triggerOutputs()?['body/Author/DisplayName'],',') /*splits by comma(,) */

and then as need refer the index which has your required data.
variables('varFName')[0] /*gets first name in 0th index */

Please note: I have split the value by comma "," as my name display name is Jiniv, Thakkar and then I took the 0th index which gives me my first name "Jiniv"

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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

Like (2)

Report

Hi @jinivthakkar, good solution but rather "Given Name" is equivalent of the First Name, not "Preferred Name".

Was this reply helpful? Yes No
MLCarter1976 51 on at

Like (1)

Report

@VictorIvanidze I wanted to thank you as I was asked to "hey can you make that display name a first name?" Uhhhhhhhhh suuureee.
So I went to the interweb and here I am! THANK YOU! I appreciate it. I struggle with the Power Platform, yet see the value in it. I am an IT Pro who handles administration better than low code solutions. So thank you!
This is what I have working, maybe it is not working, if so, I am open to suggestions / recommendations / best practices!

When people submit items to nominate their favorite thing, I do a SPO, "When an item is created" and then to the variables I go!

I create one string and have it ready to accept the given names of persons.

We have a need to include the person and their manager, so I go and grab all their names in a condition for yes / no, based on if their email address is null (empty / blank).
If it is then I add it to items and get their email address and I think I have to search for them as well and then I can get their manager name / email to write to the person and their manager. I found that I have to set the variable and then append to it, oh I didn't include the other initial variable I have for each person. So I have one for the person and then for all the persons, IF they exist and then I found I had to append the semicolon for their email (another variable and append) and a comma, for given name (to make it look nice).

Then way down in email, I go to the variables, I have a few! One for the email which for me is the "mail" for the persons (I have one for the managers email too) and the string email goes in the TO field and the given names go in the subject line to indicate to others a more personal feel. I have to put in the (above) append to for he semicolon or comma or else it won't work and will all be jumbled together. My next "step" is to figure out how to get rid of that last comma for persons to not make it look weird.

You've helped me so I thought I'd let you and others know what it did for me! THANK YOU!

Was this reply helpful? Yes No