Unanswered

Remove domain from user principle name

(0) Share

Report

Posted on by cdmcali

I am trying to build a flow that uses the get user profile (v2) module and only want to pull the user's username from the system. I would like to remove the @xxxxx.com from the user principal name dynamic content and add it to a column in a sharepoint list. How would I do that?

I have the same question (0)

All responses (6)

Answers (0)

David- 1,254 on at

Like (0)

Report
Re: Remove domain from user principle name

You basically want to split the e-mail address into two parts; the address and the domain. You can use the split expression to do this, which will generate an array with two outputs. You can then reference each one of theses through the expression in the compose actions.
The expression used in each of the above are:
split(outputs('Get_user_profile_(V2)')?['body/mail'],'@') - splits the e-mail address at the @ symbol
outputs('Compose')[0] - gets the first item from the split (the e-mail address)
outputs('Compose')[1] - gets the second item from the split (the domain)

Was this reply helpful? Yes No
cdmcali 64 on at

Like (0)

Report

Re: Remove domain from user principle name

Here is what happened:

It put thi sin my sharepoint list: outputs('Compose')[0]

Was this reply helpful? Yes No
cdmcali 64 on at

Like (0)

Report

Re: Remove domain from user principle name

Is this setup right?

Was this reply helpful? Yes No
cdmcali 64 on at

Like (0)

Report

Re: Remove domain from user principle name

I see what I was doing wrong but still not getting the right result:

Output: split(flowiitsautomation@XXXXX.edu,'@')[0]

Was this reply helpful? Yes No
cdmcali 64 on at

Like (0)

Report

Re: Remove domain from user principle name

I see what I was doing wrong now. I was not using the expression. Thanks!

Was this reply helpful? Yes No
David- 1,254 on at

Like (0)

Report
Re: Remove domain from user principle name

You need to use the expression builder for the formulas in each of the compose actions. If you have done it correctly, the Inputs will look like the image I posted with a pink box with fx at the beginning. When you click on the input box it should open this menu:
You need to click on Expressions and enter the formula in the fx box. As you build it, you can switch to the Dynamic content tab to get the e-mail field, etc. The three expressions you need:
split(outputs('Get_user_profile_(V2)')?['body/mail'],'@') - splits the e-mail address at the @ symbol
outputs('Compose')[0] - gets the first item from the split (the e-mail address)
outputs('Compose')[1] - gets the second item from the split (the domain)
As long as you did not rename the Get user profile action, and don't rename your first compose action, the bold text above is what should work in the expressions.

Was this reply helpful? Yes No