Converting strings to intergers

[Anonymous]

I'm doing a simple feedback survey which asks someone to rate their experience from 1-5, except I'm using emojis to represent those numbers. So the options are: 😠,🙁,😐,🙂,😀

I tried composing an array but I couldn't find an expression that searches the array and returns the index number. Something like getindex(array,item)

I found this: https://powerusers.microsoft.com/t5/Building-Flows/Return-the-index-that-contains-a-specific-value/t...

But I thought there might be a simpler way as my array will never change.

Thanks

[abm]

Hi @Anonymous 

So your array size is 4 (index from 0 onwards). Believe what you are looking is which array cell /index have some value and rest all are blank.

Thanks

[Anonymous]

Sorry, I'm not following. The output from the choice of otions is going to be for arguments sake: terrible, bad, indifferent, good or great. So I create an aray:

['terrible','bad','indifferent','good','great']

So terrible is index 0, great is index 4. What function can I use to give it one of those strings and have it output the index (0-4)?

[abm · Accepted solution]

Hi @Anonymous 

Here it is

See the above expression  I am using to get the index

My test results