web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Converting from int to...
Power Automate - Building Flows
Answered

Converting from int to alphabetical letter

(0) ShareShare
ReportReport
Posted on by Wes_G 15

I used the Format Data by Examples tool to try to describe what I want to do. A screenshot is below, but basically I need to convert numbers to letters such that 1 would be "a", 2 would be "b" and so on. When I get to 27, it should do "aa" and 28 should be "ab".

formula.png

The formula interpreter doesn't seem to know what I am asking for, so I was wondering if this is the wrong way to go about solving this problem and if I should try a different way. 

I have the same question (0)
  • Verified answer
    NickMerrick Profile Picture
    NickMerrick 419 Super User 2024 Season 1 on at
    Re: Converting from int to alphabetical letter

    I started with setting up variables for your numeric input, then, setups  a Parse JSON with a prewritten table showing 26 numbers to letters. 

    NickMerrick_2-1690577547809.png

     

    [{"Number": 1,"Letter": "a"},
 {"Number": 2,"Letter": "b"},
 {"Number": 3,"Letter": "c"},
 {"Number": 4,"Letter": "d"},
 {"Number": 5,"Letter": "e"},
 {"Number": 6,"Letter": "f"},
 {"Number": 7,"Letter": "g"},
 {"Number": 8,"Letter": "h"},
 {"Number": 9,"Letter": "i"},
 {"Number": 10,"Letter": "j"},
 {"Number": 11,"Letter": "k"},
 {"Number": 12,"Letter": "l"},
 {"Number": 13,"Letter": "m"},
 {"Number": 14,"Letter": "n"},
 {"Number": 15,"Letter": "o"},
 {"Number": 16,"Letter": "p"},
 {"Number": 17,"Letter": "q"},
 {"Number": 18,"Letter": "r"},
 {"Number": 19,"Letter": "s"},
 {"Number": 20,"Letter": "t"},
 {"Number": 21,"Letter": "u"},
 {"Number": 22,"Letter": "v"},
 {"Number": 23,"Letter": "w"},
 {"Number": 24,"Letter": "x"},
 {"Number": 25,"Letter": "y"},
 {"Number": 26,"Letter": "z"}]

    Then find how what leader number you have with this expression in an integer variable I named leading

    div(triggerBody()['number'],26)

     then a condition if Leading is greater than 0

    in the no branch, its just a filter array

    NickMerrick_0-1690577430044.png

    if its greater than 0, meaning there is a leading number, expression for the base letter filter array is

    sub(variables('initialinteger'),mul(variables('Leading'),26))

    NickMerrick_1-1690577483883.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans