web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Create a new Formula c...
Power Apps
Answered

Create a new Formula column in Dataverse with an IF clause based on a Choice field

(1) ShareShare
ReportReport
Posted on by 286

Hello everyone,

So, I have this Choice data type column called 'Level 0'. Its values are 'Cost', 'Others', 'Revenue'.

I'd like to build a new column, 'Revenue or Cost', where: IF 'Level 0' = 'Revenue', then 'Revenue', else 'Cost'.

For the life of me I can't make it work...

It works fine with text columns though.

Can anyone help, please?

Thank you,

Alice

Categories:
I have the same question (0)
  • Verified answer
    AliceW Profile Picture
    286 on at

    Ha, I found it! Here's the formula, in case anyone else needs it 🙂

     

    If('Level 0' = 'Level 0 (Table Name)'.Revenue, "Revenue", "Cost").

     

    Basically, you need to enter a '.' and select, from the drop-down list that will appear, the value you want.

  • ricardost Profile Picture
    7 on at

    it helped me a lot! thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 408

#2
WarrenBelz Profile Picture

WarrenBelz 382 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 328 Super User 2025 Season 2

Last 30 days Overall leaderboard