Compose and join a string

[Anonymous]

Hello, 

I want to separate a name and then unify it with a period. For example: 

Luis Guzman (into) -> luis.guzman

The input for composing it would come from the outputs of the trigger 'When an item is created in sharepoint' variable called 'Owner Alias'. Like this:

[ScottShearer]

@Anonymous
You'll want to use the split and concay expressions - I will provide an example later today.

[abm · Accepted solution]

Hi @Anonymous 

Please see below.

Here I have used two split functions.

split('David Smith', ' ')[0].split('David Smith', ' ')[1]

When you add the expression use a period between the split expressions.

This is my output

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[Anonymous]

Hey @abm!

Thanks! I wanted to that for the 'Owner Alias' value of the item created in SP. I was entering this small code for capturing the dynamic variable from the trigger: 

split(triggerBody()?['Owner Alias'], ' ')[1]

But it doesn't work, the following message error is shown in the result:

How can I capture that dynamic variable for the split function?

[abm]

Hi,

Could you post your flow screenshot?

Thanks

[abm]

Hi @Anonymous 

Try this.

Here I am checking the index is greater than 1 then use the split index 0 and 1 under the compose statement. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[abm]

Hi @Anonymous 

The reason for your earlier error is most likely the value is null here. Use the below syntax so that if the value is null then it won't throw an exception.

split(triggerBody()?['Owner Alias'], ' ')?[1]

You could also try my earlier suggested solution.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[Anonymous]

@abm

It's weird if I provide just the owner alias dynamic variable in the compose action it does read it. It isn´t null.

Dynamic variable providedoutput

This is my flow configuration. I try it with the latest idea:

It ain´t working. The error is: 

null parameter value error

I really don´t know why is it reading the value as null, because it does read it when it is just the dynamic value. 

Please help, thanks

[abm · Accepted solution]

Hi @Anonymous 

What's the data type of your column?

Another way you could do is use two compose action steps. First compose just map the owner alias field. Second compose use the split. That might work.

Let me know how it goes.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[v-litu-msft · Accepted solution]

Hi @Anonymous,

Just like @abm said, you can use the Compose action to store the Owner alias before you use the expression, I have a way could also share with you:

toLower(replace(outputs('Compose'),' ','.'))

Best Regards,
Community Support Team _ Lin Tu

[Anonymous]

Hey Thanks! @abm,

That worked, I captured the content of the owner alias through a first compose action - > then I created a variable and assigned the output of the first compose as the value - > and the splited the variable. 

Great solution!

[abm]

Hi @Anonymous 

Fantastic. Thanks for letting me know.