cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pure
Frequent Visitor

Umlauts in Power Automate coming from Forms

Hello everyone, 

 

I am struggling with replacing Umlauts Ö,Ä,Ü (aka the German Characters) in Power Automate.
I tried to use the information I read on this Forum but I cant make it work, so I would be very grateful for any help!

 

I have a Flow, I am getting the information from a Forms and this Forms sends out a Mail and creates the Azure User.
Since the Forms gets filled out by different users I want to make sure that the forms doesnt just crash whenever someone uses an Umlauts(öäü) or uses a "space" at the end of the username. 

 

This is how it looks in a picture 

Unbenannt.png

 

My goal is that whenever I use Firstname or Lastname from Forms in my Flow, that it replaces ö,ä,ü with oe,ae,ue 
I tried to do that with initiliaze variable and compose but it sadly did not work.


Thank you very much for help 

10 REPLIES 10
VictorIvanidze
Memorable Member
Memorable Member

Hi @pure, what exactly did not work? 

Hi @VictorIvanidze at the moment compose is giving me the same input as output.

Try to use the following expression:

 

replace(replace(replace(variables('Firstname'),'Ö','oe'),'Ä','ae'),'Ü','ue')

 

Hi @pure, did you test it? 

Hi @VictorIvanidze I believe they way I am using the initialize variable and compose are not quiet right here

pure_0-1598357814979.png

This is how it looks at the moment.
Thank you very much so far for your help!

Just use the string I gave you earlier to initialize a variable.

Hi @pure ,

 

Can you please share you compose expression . 

 

Following url can help you do that :

https://www.alanps1.io/power-platform/flow/flow-stripping-unwanted-characters-or-special-characters-...

 

Thanks

pure
Frequent Visitor

Hi @ManishJain and @VictorIvanidze 
Thank you two for your help so far.

I tried to follow the URL and also to use the string.
Now it looks like that 

pure_0-1598430479658.png

The error message I get is

The inputs of workflow run action 'Set_variable' of type 'SetVariable' are not valid. Self reference is not supported when updating the value of variable 'InvalidCharacters'
 
I have not used composed here, because if I understand it right, with this settings every öäü should get automaticly replaced, right?

Again thank you very much!

You have to initialize both variables FirstName and LastName with 

 

replace(replace(replace(variables('Firstname'),'Ö','oe'),'Ä','ae'),'Ü','ue')

pure
Frequent Visitor

I have tried now various ways of using initialize variable or compose but in the end it never worked.

I would really appreciate it, if someone could tell me when and where to use the initialize variable here in combination with forms and when to use compose.

Thanks alot!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,477)