Trim function not deleting whitespace

(1) Share

Report

Posted on by DaveMelton

I'm trying to delete whitespace in a string using this expression

replace(Trim(triggerOutputs()?['body/Title']),' ','.')

This is for a SharePoint triggered flow and the title was renamed to "Full legal name" in the associated list. It trims the ends just fine. But according to this article (https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-trim), trim should eliminate the extra spaces in the string (it even shows it in one of their examples) as opposed to TrimEnds. And yes, once the string is trimmed, I need to replace the space with a period. I'm using this to generate what their email address will be for later on in the flow.

Currently, if their name comes in as "Desaad Joker ", it will trim off the whitespace at the ends and replace the two spaces in the string with periods "Desaad..Joker". What am I missing?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

DaveMelton 17 on at

Like (1)

Report
Copy link

Link copied!

I think I just answered my own question. The whitespace trim only works that way in Power Apps. Not Power Automate.

Hey, Microsoft! Can we get some consistency here?

For the rest of you, is there a standard way of removing whitespace? (and yes, I still need a single space between words)

Was this reply helpful? Yes No
Joseff 37 on at

Like (1)

Report
Copy link

Link copied!

Hey David,

I usually go for something like

trim(replace(replace(replace(triggerBody()?['text'],' ',' _ '),' _',''),'_ ',''))

Where triggerBody()?['text'] is the text I want to remove extra spaces from

Was this reply helpful? Yes No
AnthonyAmador 2,557 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @DavidMelton

Unfortunately the trim function doesn't remove the white spaces between words, from documentation the Trim function removes all spaces from a string of text except for single spaces between words.

What I do to remove the whitespaces is the function replace(), replace ' Hello World ! ' with your variable.

replace(' Hello World ! ', ' ', '')

Hope this helps.
Anthony.

Was this reply helpful? Yes No
Suggested answer

David_MA 14,586 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

-----

Was this reply helpful? Yes No