I've a sharepoint list (named: myTable), with value like this:
A | 4
B | 6
C | 2
D | 3
In a gallery , I have a dropdown element. I'd like to have the dropdown values generated by a formula, as follows:
At element A, I'd like to have the values 4,3,2,1, so every value between MyHighNumber value and 1.
At element B, 6,5,4,3,2,1
How can I define values with a formula? Thanks for the help!
Solved! Go to Solution.
Hi @yashag2255 ,
thanks for your reply. I don't know what can be the issue, but I cannot assign this formula to my dropdown Items.
You can see my error is the attachment. Something is not right. Should I make some other change in the settings to enable formula in the Items list?
Perhaps your locale is the issue, try the formula that @yashag2255 suggested except with this change:
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Did you miss the call? Check out the Power Apps Community Call here.
We are excited to announce the Power Apps Super Users!
Check out our new profile badges recognizing authored solutions!