Unanswered

Split Text String Based on Conditions

(0) Share

Report

Posted on by coolbeans23

In Power Automate I want to take output values from a previous step that is listed like 405, 402, 518 and transpose it vertically without the comma. If the output value says "All" then return the string "All". If the output value only has one number and no commas like 405 then just return 405.

Can someone demonstrate how I can achieve this?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

bshoyat 24 on at

Like (0)

Report

Hello, you can do this using the split function. For example, if you have your previous step be a compose named value. You can do the following in the next action:
split(outputs(‘value’), ‘,’)

that should do exactly what you are asking.

Was this reply helpful? Yes No
coolbeans23 53 on at

Like (0)

Report

That does not take into account the other conditions though like "All" and the single number like 405

Was this reply helpful? Yes No
bshoyat 24 on at

Like (0)

Report

Ohh okay so when it’s a single item you don’t want an array. So what you can do is something like this:
EDITED:
if(equals(length(split(outputs('value'),',')),1),outputs('value'),split(outputs('value'),',')).
i apologize if I missed a coma or a parenthesis as I don’t have power automate open.

@coolbeans23 , I apologize i was missing somehting in that. I have updated it now and it works on my end. One thing to note, if your previous action has "405, 507, 420", you will end up with
["405",
" 507",
" 420"]
The best way i can think to remove that is by including a replace function like this:
if(equals(length(split(outputs('value'),', ')),1),outputs('value'),split(replace(outputs('value'),' ',''),',')).

Let me know if you have other questions.

Was this reply helpful? Yes No
coolbeans23 53 on at

Like (0)

Report

The flow failed with the error: 'The template language function 'if' expects three parameter.....

Was this reply helpful? Yes No
coolbeans23 53 on at

Like (0)

Report

If you take a closer look there is a space before the second and third number. I tried using the trim function in my formula:
split(trim(triggerBody()['text']),',') but it resulted in the same thing below:

["405",
" 507",
" 420"]

How can I remove those spaces before the numbers? Is it a non-breaking space?

Was this reply helpful? Yes No
bshoyat 24 on at

Like (0)

Report

@coolbeans23,
use this
if(equals(length(split(outputs('value'),', ')),1),outputs('value'),split(replace(outputs('value'),' ',''),','))

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Hopefully this is what you're looking for. It depends on exactly what you want if there is more than one item - so added a few variations.

Initialize variable contains your data.

Select uses the following expressions to extract out each of the items including trimming any spaces.
//From split(variables('data'), ',') //Map trim(item())

Below are three different variations depending on what you're looking for.

Option 1: Join with new line character

This option would use a Join action to join the items with a new line character.
//From body('Select') //Join with decodeUriComponent('%0A')

Option 2: Join with </br> tag (will split the data in any HTML output including email)

This option would use a Join action to join the items with a </br> tag.
//From body('Select') //Join with <br>

Option 3: Output as array of items, or if one item, a single item

This option uses a Compose with the following expression.
if(equals(length(body('Select')), 1), first(body('Select')), body('Select'))

Examples using the numbers "405, 402, 518" for Join New Line, Join BR, and Compose respectively.

Examples using the numbers "405" for Join New Line, Join BR, and Compose respectively.

Examples using the numbers "All" for Join New Line, Join BR, and Compose respectively.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No