Re: How to convert Text Value tu Number in Data Table Column?
For me it seems to work
Table before converting to number/sorting:
After Sorting:
Only thing is that PAD seems to not like dot for decimal separator (it tries to make it date or it removes the dot when converting to number). Maybe Power Automate Desktops Datatable cant have float but only integer type numbers? And maybe if it is decimal the datatable item is just string type at that poin? Does anyone know if this is the case?
To troubleshoot check the value after you have converted and updated the item in data table:
Add variable that stores the just updated datatable item:
Then open the variable and check its type that its numeric value
