@Anonymous
Calculated columns are usable in PowerApps, however, they are read only as it is the role of your SharePoint list to populate them.
This means that if you are entering in a record in your App, it is not submitted until you submit it. During the entry, the calculated column is meaningless. Once the record is submitted, the calculated column would have a value - but not until submitted.
So, from a user entry perspective, it is much better to have your calculations directly in your app.
You could leave the calculated column in place and ignore it in the app and do the calculations for display purposes only - but this would mean you are maintaining formulas in two places.
A better choice would be to have a new Cost column in your list and then in your form, you can add that field and make it non-editable by the user and put a calculation in the Text property of the TextInput control in the datacard that you will have.
A formula such as this in the Text property would give you what you need:
Text(
Switch(yourLicenseTypeDataCardValueControlName.Text,
"CAD", 100,
"EXTREME", 200,
"STANDARD", 300
),
"$#,##0.00"
)
Ultimately, you should possibly consider putting your pricing information in another list and reference the list instead in the formula. This way you can alter pricing and License Types in that list rather than altering your app.
I hope this is helpful for you.
