what if i want to change multiple text values in a column to numeric values? i have this problem, the values are in a sharepoint list (text format) and i need to obtain the max value without change the type in sharepoint, just in the app. there is some way to do that?
You could create a switch statement to handle that such as Switch( value, “1/2”, 0.5, “1/4”, 0.25, “3/4”, 0.75) for example. You can then find and replace in the original text the output of the switch.
@@FlowJoeVideos , thanks for your replied. But seems not what I want. I’m using data verse collecting data, say Data point A, Data point B and Data point C. I want to do calculations in Power Apps Canvas App, once user input the value of A and B, the it can use the formula column to calculate A/B or B/A or any latest need for this formula and save as Data point C’s value. Your suggestion is good idea for static assumption of prediction. And I need dynamic. Anyway, thanks for your reply again