Answered

How to move to next value?

(0) Share

Report

Posted on by LTomas

Good day!

I am planning to create a monitoring app wherein users can see the current quantity of the entry and subtract every time they do an export.

Here's how my table roughly looks like connected in an Excel sheet:

ID	Title	Qty
1	A	25
2	B	30

Let's say you want to get 10. It should get 10 from the first row and update the remaining Qty as 15. But Let's say you want to get 30, it must first get the 25 from the first row and get 5 from the next. And ideas/formulas on how to do it?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @LTomas ,

I made a sample for you:

Create a table in Excel.

In PowerApps, ‘Data Table’ to connect to Excel table for view data, ‘Text input’ to enter numbers, ‘Button’ to submit data and set as follows.

ClearCollect(TestA,ForAll(Test,If(Sum(FirstN(Test,Value(ThisRecord.ID)),Qty)<Value(TextInput1.Text),{ID:ID,Title:Title,Qty:0})));
UpdateIf(Test,ID=LookUp(Test,!(ID exactin TestA.ID)).ID,{Qty:Sum(FirstN(Test,Value(ThisRecord.ID)),Qty)-Value(TextInput1.Text)});
UpdateIf(Test,ID exactin TestA.ID,{Qty:0})

Enter the number and submit, the data is updated.

Best Regards,

Wearsky

Was this reply helpful? Yes No
LTomas 40 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much! Will apply this logic.

Was this reply helpful? Yes No
LTomas 40 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft!

Just tried your method. having problems in converting it to be suitable in my use case.
in the said table, the records in the table is using sharepoint list. And one of the columns is Commodity (textColumn). The items section is Filter('Import-Polymers', Commodity = dropdown_rawmaterial.Selected.Value).

So based on your code, I just have to replace "Test". But for some reason, I have been encountering errors with Power Apps not actually explaining said error. Can you provide an alternative version of the said code?

Was this reply helpful? Yes No