App- remember the previous value of a field and used to current record

(0) Share

Report

Posted on by ciprianpopovici

159

I need to build an app that will manage the activities of specific people.

Once a day , each user will fill in the application how many orders and invoices resolve in a day. Everything seems simple to do, except for the part that must be retained where the total value from the previous day, which must be added to the current record. To exemplify I have attached what the application should look like.

The calculation formulas are as follows: Total in is the sum of the remaining orders from the previous day plus the orders entered today (Total in = Remaining from yesterday + In) . Initial Remaining from yesterday is zero. Remaining has the calculation formula Total In-Solved.

I don't know how to manage the value from the previous day (remaining from yesterday). Remaining from yesterday will be an read only field.

I have to use the value of Remaining in the next day's record Remaining from yesterday . Practically the field Remaining from yesterday will have the value of field Remaining from previous record of user.

Thank you

Hope someone will understand

Each type of activity is managed separately (invoices, orders, etc.)

Categories:

Building Power Apps

Capture.JPG

I have the same question (0)

All responses (4)

Answers (0)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

I am going to presume the Remaining from yesterday is a field in your data source? If not you will need to add it. Power Apps doesn't retain anything between uses. So you have to have that data somewhere it can get it for the user.

In your App OnStart, do a lookup for the current user to get the value of 'Remaining from Yesterday' and store it in a variable to use when needed.

Was this reply helpful? Yes No
ciprianpopovici 159 on at

Like (0)

Report

It's already a field in my data source (SharePoint list).Can you give some example of code to use to lookup for the value of the field 'Remaining from Yesterday' for current user? I'm not sure how to do it. Thank you

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
You can do this: Replace SPColumn with the name of the column that contains your user email address

Set(varRemaining, LookUp(SharePointList, SPColumn = User().Email).'Remaining from yesterday')

Was this reply helpful? Yes No
ciprianpopovici 159 on at

Like (0)

Report

I will try your solution and come back with feedback. Thanks

Was this reply helpful? Yes No