Answered

Increment variable in ForAll

(0) Share

Report

Posted on by Iep90

Hello community
I have a Collection with the following nomenclature

Set(NumberToUse,1)
ClearCollect(
CurrentCustomersClientsCollection,
{
IDNumber:NumberToUse,
Name: ""
}
);

I have to increment the NumberToUse variable every time a record is created in the collection. How can I do?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Expiscornovus 33,718 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Iep90,

How much records will be in your CurrentCustomersClientCollection. If it will be under 50000 items you can probably implement a sequence function:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-sequence

Shane Young also has a nice video about using the sequence function in different approaches (also a couple examples with ForAll):

https://www.youtube.com/watch?v=oKJkVx2gehw

Hope this helps a bit?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @Iep90 :

You could try:

Collect(
CurrentCustomersClientsCollection,
{
IDNumber:Max(CurrentCustomersClientsCollection,IDNumber)+1,
Name: ""
}
);

Best Regards,

Bof

Was this reply helpful? Yes No