
Announcements
I've been experimenting with the Power Fx calculated columns in (full) Dataverse as announced here: https://powerapps.microsoft.com/en-us/blog/boost-maker-productivity-inside-dataverse-using-formula-columns/ which look great. However, I think I've found an area for improvement with whole numbers.
If the formula in a Power Fx calculated column is guaranteed to return an integer the column type should be detected and set to 'Whole Number (fx)' currently all numeric results get a column type of 'Decimal (fx)', e.g.
even a where the value is explicitly an integer always causes a decimal column, e.g.
or just
My main use case for this is returning a persons age, where we normally treat as a whole number.
This documentation mentions that the following column types are currently possible
I suspect that more column types will be available in the future