Answered

Remove spaces from string

(1) Share

Report

Posted on by TimBroeren

Hi everyone,

I am trying to build a flow and I'd like to remove spaces from a string. It works for me in other flows and I use the same formula in Power Automate.

I've got an example where the surname is divided by a space.

I use the following formula in the Compose action. replace(body('output_surname'),' ',''). What I expect to see is that "Sur Name" becomes "SurName". When the testflow has run, I check the input if the example above is expected. But the input value is already "SurName". While in fact it's not. When the following action is to add a row to Excel. The surname-value gives "Sur Name".

Can you guys help? Why is the input "SurName", while it's in fact "Sur Name".

I look forward to your replies.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@TimBroeren - Is the response from a MS Forms? and are you trying to remove the space from output of ParseJSON output. As you mentioned something it is working in another Flow instance, so something might be different.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
TimBroeren 32 on at

Like (0)

Report

@CFernandes It's a response from a MS Forms and it's a direct output from this Form.

Was this reply helpful? Yes No
Verified answer

TimBroeren 32 on at

Like (0)

Report

I created a variable first and after I created this variable I composed this variable. My problem is solved.

Was this reply helpful? Yes No