Answered

Replace space in variable with period

(1) Share

Report

Posted on by djox

I am calling a flow from Power Virtual Agents, I am passing the user name that contains spaces e.g. Fred A Smith and I want to replace the spaces with a period i.e. Fred.A.Smith to use in a API call

I initialized a variable USER_NAME with the UserName that was passed to the flow

I thought it would be a simple matter of using the compose to replace the characters, but no matter what I try the USER_NAME string is not been updated. And as a result the API does not return anything.

If I create a test variable in the correct format and pass that to the API my flow works correctly.

Am I missing something obvious?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Caspar_Rubin 831 on at

Like (0)

Report
Copy link

Link copied!
Instead of using the %32 etc. I usually just create a new String Variable (initialize variable) called "Space" and just put a space in it...

Then i can use this formula:

replace(variables('UserName'),variables('Space'),'.')

Output:

Was this reply helpful? Yes No
Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @djox

replace(variables('USER_NAME'),' ','F')
This is sufficient in compose which should do.
Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No