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
Solved! Go to Solution.
Hi @Anonymous
Here it is
See the above expression I am using to get the index
My test results
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogSorry, 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)?
Hi @Anonymous
Here it is
See the above expression I am using to get the index
My test results
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThe first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
42 | |
18 | |
16 | |
15 | |
13 |
User | Count |
---|---|
66 | |
36 | |
27 | |
21 | |
17 |