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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Calculated fields and ...
Power Apps - Microsoft Dataverse
Unanswered

Calculated fields and new field not appearing in the list

(0) ShareShare
ReportReport
Posted on by TroyH 4

Hi,

 

I have created an entity which has part data in it. I want to do a calculated field for total price, which is simply [Qtyinstock] * [cost]

 

When I first set this up it worked fine. I created the calculated field ok.

 

Then I realised I had defined the wrong data type for quantity, as I could change it I created a new field called [Quantity in Stock] and put the data in that field. When I try to change the calculated field the new field doesn't appear. If I type in the field name it fails validation. 

 

I have tried deleting the total field and recreating it, and deleting the old qty filed. the old field disappears from the list so I know the list is updating

 

Any thoughts?

 

Troy

Categories:
Entities
I have the same question (0)
  • v-siky-msft Profile Picture
    v-siky-msft on at
    Re: Calculated fields and new field not appearing in the list

    Hi @TroyH ,

     

    I have made a test from my side, I create a new whole number Field and it can be retrieved in Calculated field window.

    I can only suggest you check the type and enter the logical Name (not display name) in Calculation.

    If this still doesn't make sense, try to delete that field and re-create a new one.

    Best regards,

    Sik 

  • TroyH Profile Picture
    TroyH 4 on at
    Re: Calculated fields and new field not appearing in the list

    it seems that whole number works but floating number does not. 

  • v-siky-msft Profile Picture
    v-siky-msft on at
    Re: Calculated fields and new field not appearing in the list

    Floating point number cannot be used in Calculated field, Please change to use decimal field.

    You can try to create a decimal field, copy the values from those original floating-point field into the new decimal field by Flow. Then you should be able to use new decimal field to define a calculated field.

    Also, you can use UpdateIf(EntityName, true, {'decimal field': 'floating-point field '}) code to convert in PowerApps.

    Best regards,

    Sik

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans