Power Automate

How i can split a sting to generate Array without empty string

(0) Share

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have a Child Flow which accept names in a semi-collon separate string, here are examples of the string:-

;test

test;test2

test;;test2

test

now i want to generate an array but i do not want the array to have empty strings .. can i write a single formula to do this? i do not want to do a separate action to filter the Array. i am searching to do this in a single formula..Thanks

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report

Are these all the possible examples? :-)

split(

if(

startswith(replace(outputs('String'),';;',';'),';'),

substring(replace(outputs('String'),';;',';'),1),

if(endswith(replace(outputs('String'),';;',';'),';'),

substring(replace(outputs('String'),';;',';'),0,length(replace(outputs('String'),';;',';'))-1),

replace(outputs('String'),';;',';')

)

)

,';')

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report

@lbendlin

Thanks for the formula, but i got that it is not valid when i add it to the compose action. any advice? As i know that SubString() should contain 3 parameters, but your first SubString() contains only 2 parameters

for the combination, i might have this string format:-

;p;;p6;

where i only need p & p6..
Thanks

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Would this expression work for you? I've updated the expression based on your sample data.

json(replace(replace(string(split(variables('varString'),';')),'"",',''), '""]',']'))

Ellis

https://elliskarim.com/

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report

The third parameter of substring is optional if you want to get the whole rest of the string.

I forgot that you cannot subtract numbers easily in Power Automate.

split(
substring(replace(variables('String'),';;',';'),
if(startswith(replace(variables('String'),';;',';'),';'),1,0),
sub(length(replace(variables('String'),';;',';')),
add(if(startswith(replace(variables('String'),';;',';'),';'),1,0),
if(endswith(replace(variables('String'),';;',';'),';'),1,0)
)
)
)
,';')

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report

@lbendlin

Thanks , but i am getting invalid error when i tried to add your formula

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

I updated my response.

Was this reply helpful? Yes No