Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Remove Spaces in String Text

Like (1) ShareShare
ReportReport
Posted on 10 Feb 2021 17:24:18 by 6

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?

 

 

  • Pstork1 Profile Picture
    66,093 Most Valuable Professional on 12 Dec 2022 at 18:15:48
    Re: Remove Spaces in String Text

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

  • emi215487 Profile Picture
    2 on 12 Dec 2022 at 16:51:19
    Re: Remove Spaces in String Text

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

  • 123213123 Profile Picture
    116 on 01 Dec 2022 at 10:21:13
    Re: Remove Spaces in String Text

    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

  • RichRicky Profile Picture
    9 on 04 Sep 2021 at 10:18:31
    Re: Remove Spaces in String Text

    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?

  • Verified answer
    Pstork1 Profile Picture
    66,093 Most Valuable Professional on 10 Feb 2021 at 17:29:32
    Re: Remove Spaces in String Text

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

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard
Loading started