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)
But I thought there might be a simpler way as my array will never change.
Solved! Go to Solution.
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.
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:
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)?
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.