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:
Solved! Go to Solution.
Please see below.
Here I have used two split functions.
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @LuisGuzman98,
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
Please see below.
Here I have used two split functions.
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHey @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:
How can I capture that dynamic variable for the split function?
Hi,
Could you post your flow screenshot?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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 provided
output
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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @LuisGuzman98,
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
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!
Fantastic. Thanks for letting me know.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsDive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
44 | |
40 | |
38 | |
36 | |
24 |
User | Count |
---|---|
39 | |
38 | |
32 | |
31 | |
28 |