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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / keep the duplicated va...
Power Apps
Answered

keep the duplicated values from the past time

(0) ShareShare
ReportReport
Posted on by 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.

I have the same question (0)
  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    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.

     

    Screen Shot 2021-07-28 at 5.19.58 AM.png

     

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


    Thanks!


    Drew

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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

  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard