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:
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!