Unanswered

A problem for update variable during a ForAll oop

(0) Share

Report

Posted on by baron33

This is my code

Set(remaining_amount_needed,total_amount_required);

ClearCollect(SelectedPacks, []); // This collection will store the selected packs.

ClearCollect(
 SelectedPacks,
 ForAll(
 PurchaseOptionsSorted,
 If(
 remaining_amount_needed > 0,
 {
 Drug: Drug,
 PackSize: AMT,
 UnitPrice: Unit_price,
 Order: RoundDown(remaining_amount_needed / AMT, 0),
 Quantity: RoundDown(remaining_amount_needed / AMT, 0) * AMT,
 left_quantity: remaining_amount_needed-RoundDown(remaining_amount_needed / AMT, 0) * AMT
 },
 Blank()
 );
 // Update remaining_amount_needed for the next iteration
 //UpdateContext({remaining_amount_needed: remaining_amount_needed - RoundDown(remaining_amount_needed / AMT, 0) * AMT})
 //remaining_amount_needed=remaining_amount_needed +1
 
 )
)

For each loop, I want to update the varaiable, remaining_amount_needed= its starting value - quantity

and the loop should finish when it becomes 0

ChatGPT told me to add this in the end of the loop:

Set(remaining_amount_needed, remaining_amount_needed - RoundDown(remaining_amount_needed / AMT, 0) * AMT

but it gave me error:

This function cannot be invoked within ForAll.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@baron33 ,

You cannot set a Variable inside a ForAll function. You can however add items to a collection and then reference

Last(CollectionName).FieldName

for the value you need.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
baron33 2 on at

Like (0)

Report
Thanks. I know I can collect the first / last record's field.

but i still can't think how i can use it to do my work. e.g. in my case, the key variable / condition is if > 0 or not
remaining_amount_needed > 0,

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@baron33,

Maybe set the variable after the ForAll to the value of the field in the last record of the collection

Was this reply helpful? Yes No