cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
t_vuorenmaa
New Member

Replace ÅÄÖ with expression

Iam building a flow to create Azure AD Users based on a Sharepoint list. 

Iam building UPN based on: firstname.lastname@domain.com

 

It works fine, but.. two questions.

1st. Since iam from sweden we like to add ÅÄÖ to our names, is there any good way to replace these letters with A and O instead? For UPN only? 

2nd. If the UPN is allready taken, is there anyway to enumurate and add for example 1,2,3 etc to UPN? 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @t_vuorenmaa

 

 

You could replce the "ö" in the First Name to "o" refer to screenshot below:

Capture.PNG

The expression in the Compose as below:

replace(triggerBody()?['First_x0020_Name'],'ö','o')

The expression in the Create User action as below:

concat(outputs('Compose'),'.',triggerBody()?['Last_x0020_Name'],'@domain.com')

 

And you could refer to my solutions to replce the "Ö" in the First Name to "O",replace the "Å" to "A", replace the "Ä" to "A" and so on.

 

 

Best regards,

Alice

View solution in original post

4 REPLIES 4
v-yuazh-msft
Community Support
Community Support

Hi @t_vuorenmaa

 

I couldn't understand your requirement from your description, could you please explain more details about your requirement such as:

1. The screenshot of the configuration of your flow.

2. The run details of your flow, and what would be the UPN be created in your flow looks.

3. How you want the UPN to be created looks.

 

Best regards,

Alice

Hi @v-yuazh-msft,

 

Thank you for your reply.

See attateched picture

 

Lets say i have a user called

Firstname: Björn

Lastname:Andersson

 

For Mailnick and UPN i would like to replace Ö for O, since Ö wont be accepted in UPN or Mailnick.

2018-12-14 10_04_44-Edit your flow _ Microsoft Flow.png

 

Hi @t_vuorenmaa

 

 

You could replce the "ö" in the First Name to "o" refer to screenshot below:

Capture.PNG

The expression in the Compose as below:

replace(triggerBody()?['First_x0020_Name'],'ö','o')

The expression in the Create User action as below:

concat(outputs('Compose'),'.',triggerBody()?['Last_x0020_Name'],'@domain.com')

 

And you could refer to my solutions to replce the "Ö" in the First Name to "O",replace the "Å" to "A", replace the "Ä" to "A" and so on.

 

 

Best regards,

Alice

bastian94
New Member

I was wondering if it's possible use one code string to adjust all possible ÅÄÖ?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,707)