Answered

Remove Spaces in String Text

(1) Share

Report

Posted on by Power Platform Star

Hi currently I have a field from data verse which stores the account name, I need spaces to be removed from the account name so i can use it for a URL I'm trying to construct.

For example ;

Account name = "Test ABC 123"

I would need the output to be "TestABC123"

Can any one help?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Pstork1 69,127 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Have you tried using a Replace which targets a space and replaces it with an empty string?

replace('Test ABC 123',' ', '')

1 people found this reply helpful.

Was this reply helpful? Yes No
RichRicky 9 on at

Like (0)

Report
Copy link

Link copied!

my problem is similar!!!

For example;
input (text): 1 406 502
I want output: 1406502

My question: In the case of the 'power automate desktop' program, what functions and values do I need to use to get the output result?

Was this reply helpful? Yes No
123213123 on at

Like (0)

Report
Copy link

Link copied!

What to do if previous compose step is empty (this scenario can happen sometimes and then the flow says failed when i use the replace function) please help

Was this reply helpful? Yes No
emi215487 2 on at

Like (0)

Report
Copy link

Link copied!

Oups, I answered the wrong post, so I deleted it...

Was this reply helpful? Yes No
Pstork1 69,127 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can use the Coalesce function around the Outputs('Compose') to substitute something if the Compose output is null.

Was this reply helpful? Yes No