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

Scramble letters to Phonetics

I have created a password generator, which will generate 15- and 8-digit characters respectively, those are alpha numeric, Upper, and lower case, special characters, and numbers, Label1 at the top will show the generated password, and label2 at the bottom should show the password here I would wanted it to show the data in phonetics

 Label2 should display:

p - Papa

d - Delta

S - Sierra

y - Yankee

r - Romeo

c - Charlie

R - Romeo

L - Lima

 

Veera0612_0-1653540943425.png

 

Please help.

2 ACCEPTED SOLUTIONS

Accepted Solutions
rubin_boer
Super User
Super User

hi @Veera0612 

 

Create a reference table with the phonetics in it

there are a few ways to go about this, something like:

Set(
    Phonetics,
    Table(
        {
            key: "a",
            phonetic: "alfa,"
        },
        {
            key: "b",
            phonetic: "bravo"
        },
        {
            key: "c",
            phonetic: "charlie"
        },
        {
            key: "d",
            phonetic: "delta"
        },
        {
            key: "e",
            phonetic: "echo"
        },
        {
            key: "f",
            phonetic: "foxtrot"
        },
        {
            key: "g",
            phonetic: "golf"
        },
        {
            key: "h",
            phonetic: "hotel"
        },
        {
            key: "i",
            phonetic: "india"
        },
        {
            key: "j",
            phonetic: "juliett"
        },
        {
            key: "k",
            phonetic: "kilo"
        },
        {
            key: "l",
            phonetic: "lima"
        },
        {
            key: "m",
            phonetic: "mike"
        },
        {
            key: "n",
            phonetic: "november"
        },
        {
            key: "o",
            phonetic: "oscar"
        },
        {
            key: "p",
            phonetic: "papa"
        },
        {
            key: "q",
            phonetic: "quebec"
        },
        {
            key: "r",
            phonetic: "romeo"
        },
        {
            key: "s",
            phonetic: "sierra"
        },
        {
            key: "t",
            phonetic: "tango"
        },
        {
            key: "u",
            phonetic: "uniform"
        },
        {
            key: "v",
            phonetic: "victor"
        },
        {
            key: "w",
            phonetic: "whiskey"
        },
        {
            key: "x",
            phonetic: "x-ray"
        },
        {
            key: "y",
            phonetic: "yankee"
        },
        {
            key: "z",
            phonetic: "zulu"
        }
    )
)

 

Add a gallery and set the Items as follows:

AddColumns(
    Split(
        yourPassWordValue,
        ""
    ).Result,
    "phon",
    LookUp(
        Phonetics,
        key = Lower(Result)
    ).phonetic
)

 

Result:

Two label in the gallery

label1 = ThisItem.Result

label2 = " - " & Proper(ThisItem.phon)

rubin_boer_0-1653550232058.png

 

Hope it helps,

R

 

 

hey there if you liked the post give it a thumbs up, and if it solved your question please accept it as a solution.

View solution in original post

Veera0612
New Member

Thank you so much, it worked as expected.

Veera0612_0-1653626459322.png

 

View solution in original post

2 REPLIES 2
rubin_boer
Super User
Super User

hi @Veera0612 

 

Create a reference table with the phonetics in it

there are a few ways to go about this, something like:

Set(
    Phonetics,
    Table(
        {
            key: "a",
            phonetic: "alfa,"
        },
        {
            key: "b",
            phonetic: "bravo"
        },
        {
            key: "c",
            phonetic: "charlie"
        },
        {
            key: "d",
            phonetic: "delta"
        },
        {
            key: "e",
            phonetic: "echo"
        },
        {
            key: "f",
            phonetic: "foxtrot"
        },
        {
            key: "g",
            phonetic: "golf"
        },
        {
            key: "h",
            phonetic: "hotel"
        },
        {
            key: "i",
            phonetic: "india"
        },
        {
            key: "j",
            phonetic: "juliett"
        },
        {
            key: "k",
            phonetic: "kilo"
        },
        {
            key: "l",
            phonetic: "lima"
        },
        {
            key: "m",
            phonetic: "mike"
        },
        {
            key: "n",
            phonetic: "november"
        },
        {
            key: "o",
            phonetic: "oscar"
        },
        {
            key: "p",
            phonetic: "papa"
        },
        {
            key: "q",
            phonetic: "quebec"
        },
        {
            key: "r",
            phonetic: "romeo"
        },
        {
            key: "s",
            phonetic: "sierra"
        },
        {
            key: "t",
            phonetic: "tango"
        },
        {
            key: "u",
            phonetic: "uniform"
        },
        {
            key: "v",
            phonetic: "victor"
        },
        {
            key: "w",
            phonetic: "whiskey"
        },
        {
            key: "x",
            phonetic: "x-ray"
        },
        {
            key: "y",
            phonetic: "yankee"
        },
        {
            key: "z",
            phonetic: "zulu"
        }
    )
)

 

Add a gallery and set the Items as follows:

AddColumns(
    Split(
        yourPassWordValue,
        ""
    ).Result,
    "phon",
    LookUp(
        Phonetics,
        key = Lower(Result)
    ).phonetic
)

 

Result:

Two label in the gallery

label1 = ThisItem.Result

label2 = " - " & Proper(ThisItem.phon)

rubin_boer_0-1653550232058.png

 

Hope it helps,

R

 

 

hey there if you liked the post give it a thumbs up, and if it solved your question please accept it as a solution.
Veera0612
New Member

Thank you so much, it worked as expected.

Veera0612_0-1653626459322.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,623)