keep the duplicated values from the past time

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a column as "amount" requested from my customer to save all the amounts he predicted to make in 2021/9.

But no matter what amount he filled in, this prediction will be ended up in 2021/8/15.

And he can make a comparison with the truth of 2021/9.

So I need to keep the prediction in another column like "Prediction_2021/9" that we can make the checking procedure.

In Dataverse, I made a calculated column that

"Prediction_2021/9" would be set as the copy of "amount"

if the modified date before 2021/8/15,

but the problem is

if "amount" was modified AFTER 2021/8/15, whatever the amount saved in "Prediction_2021/9" would be CLEARED.

I did nothing in Else part that I have no idea how to prevent the "refreshing".

What should I do to keep the previous amount there without clearing?

Thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @Anonymous ,

You are right, if you do not put an else condition in here it will clear the field and you can not reference the current value of the field or you will get a circular reference.

I was able to accomplish your business requirement in a test utilizing. a business rule instead and not using a calculated field. I created a field called Prediction BR 2021/9 and setup a business rule to set the value to the Amount column if the Date Check field was < 2021/8/15. This set the value appropriately up until I utilized a date after this date and then it did not set it at all and kept the previous value in the column.

Hopefully this helps. Please accept if answers your question or Like if helps in any way.

Thanks!

Drew

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Drew,

Thank you for the solution!
Sorry because there are still some problems that I have to fit my original design,
But I am really appreciated for your help!

Dave

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous , you could use combination of both approaches and on the else set the value to the one set in the business rule. The other field would need to be on the form but you could hide it…

thanks,

Drew

Was this reply helpful? Yes No