Tip #1449: Formula columns
Formula columns in Dataverse have some limitations when it comes to Power Fx functions and return types. To work around these limitations, you can use certain tricks. For example, if you need a formula column to return a whole number, make it a decimal with 0 precision. If you need to produce currency, create a formula to return a decimal and then convert it to currency using a calculated column. If you need a choice, you can only have "yes" or "no" as options, but you can use a similar approach with a formula column and then create a calculated column with if-then-else statements to cover all possible return values. It's worth noting that Power Fx in formula columns does not support the Power function.
Article 14m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time