Calculating value not displaying in edit form

(0) Share

Report

Posted on by Sri

559

Hi all,

I have a list called Consumption Tracker where there are 3 fields(number type). Gross effort is the field which should auto-populate the calculated value. Total effort saved(datacardvalue12) and estimated effort(datacardvalue14) will be the value entered fields. I have separate forms for edit and new. In new form On change and On select of the two value fields i have given this formula:

Set(
var,
Round(
IfError(
If(
!IsBlank(DataCardValue14.Text),
(DataCardValue14.Text) / (DataCardValue12.Text)
),
0
) * 100,
2
)
);

and the variable "var" I have set it to the default of the Gross effort field. The default value is

If( IsBlank(ThisItem.GrossEffort), var, Parent.Default)

In edit form the same code is there in the On change and On select and for the default value I have given.

If( !IsBlank(ThisItem.GrossEffort), Parent.Default, varedit)

It displays only the Parent.Default value and it doesn't shows the when we try to calculate here.

Any help/suggestion on this.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Uthhra ,

I cannot find where was the variable varedit created. Did you use the wrong variable?

Best regards,

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

s@v-jefferni
for the new form the variable is "var" and edit form it is "varedit". I have used set to create the variable. In edit form the code in On change and On select will be same as above only the variable name will be changed. So instead of Set var it will Set varedit.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Uthhra ,

For the formula If( !IsBlank(ThisItem.GrossEffort), Parent.Default, varedit), it means display varedit when GrossEffort is not blank in data source. varedit value will only display when there isn't value in GrossEffort column. So, if you want to display the variable, you need to change the formula to:

If(IsBlank(varedit) || varedit = Parent.Default, Parent.Default, varedit)

Best regards,

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni
If I try entering some value and If I don't click on save, it must change to the Parent.Default value but here it still retains the calculated value. Even though I give Refresh datasource on Onvisible

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

Like (0)

Report
Copy link

Link copied!

Hi @Uthhra ,

If you don't want the calculated value be saved, you can use Set(varedit, Blank()) when leaving the edit form screen or reset the field to be default again.

Best regards,

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni
Thanks a lot. You saved my day.

Was this reply helpful? Yes No