Unanswered

Calculated fields and new field not appearing in the list

(0) Share

Report

Posted on by TroyH

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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TroyH 4 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No