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

Replacing special characters in names in a Sharepoint list

Hi,

I am trying to generate a username from Forms (from the input Firstname and Lastname).

It must be in the format firstname.lastname but without any special characters (like ä, ç , ă, à).

I created with the flow a sharepoint list where I also added a column for the username and I am trying to set there the "clean" firstname.lastname 

Other solutions that I found didn't worked.

climby_1-1656431209175.png

 

climby_0-1656430792713.png

I tried this : https://powerusers.microsoft.com/t5/General-Power-Automate/Replace-%C3%85%C3%84%C3%96-with-expressio...

and this : https://powerusers.microsoft.com/t5/Building-Flows/Umlauts-in-Power-Automate-coming-from-Forms/td-p/...

Thanks a lot for your help 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
climby
Frequent Visitor

so it worked now with replace :  replace(replace(replace(replace(toLower(variables('First')),'ö','oe'),'ä','ae'),'ü','ue'), “à”, “a”)

see https://powerusers.microsoft.com/t5/Building-Flows/Umlauts-in-Power-Automate-coming-from-Forms/td-p/... 

but I still struggle to have all the special characters from names replaced not only 4 like here. 

View solution in original post

3 REPLIES 3
takolota
Super User
Super User

@climby 

 

Does the encodeuricomponent() expression work on these types of values?

climby
Frequent Visitor

Interesting ideea, but is it not used only for the URLs ? I didn't found nothing related to those special characters

climby
Frequent Visitor

so it worked now with replace :  replace(replace(replace(replace(toLower(variables('First')),'ö','oe'),'ä','ae'),'ü','ue'), “à”, “a”)

see https://powerusers.microsoft.com/t5/Building-Flows/Umlauts-in-Power-Automate-coming-from-Forms/td-p/... 

but I still struggle to have all the special characters from names replaced not only 4 like here. 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,249)