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:
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights