Power Platform Community Forum Thread Details

Hey Community,

My Code looks like this:

Set(countVorgang; 1);;
Set(itemCount; 0);;
Set(itemSum; CountRows(tmp_recordsToUpdate));;

ForAll(
 tmp_recordsToUpdate;
 Patch(
 count_W2TML;
 First(
 Filter(
 count_W2TML;
 Titel = tmp_recordsToUpdate[@Titel] && Datum = tmp_recordsToUpdate[@Datum]
 )
 );
 {
 Titel: tmp_recordsToUpdate[@Titel];
 Anzahl: tmp_recordsToUpdate[@Anzahl];
 Datum: tmp_recordsToUpdate[@Datum];
 UName: tmp_recordsToUpdate[@Username];
 Mail: User().Email
 }
 );
 Set(itemCount; itemCount + 1); // Update itemCount for each item inside the loop
);; ;

Now my Question is, Is there a possability to count up a variable inside the ForAll Loop. And when how could i do this?

Thanks for your Help,

And have a nice Day! 🙂

Categories:

Building Power Apps

Hi @aka271 ,

You cannot set a Variable inside ForAll (as you have discovered). You can do a collection then CountRows that at the end

Set(countVorgang; 1);;
Set(itemCount; 0);;
Set(itemSum; CountRows(tmp_recordsToUpdate));;
Clear(colItems);
ForAll(
 tmp_recordsToUpdate As _Data;
 Patch(
 count_W2TML;
 LookUp(
 count_W2TML;
 Titel = tmp_recordsToUpdate[@Titel] && Datum = tmp_recordsToUpdate[@Datum]
 );
 {
 Titel: _Data.Titel;
 Anzahl: _Data.Anzahl;
 Datum: _Data.Datum;
 UName: _Data.Username;
 Mail: User().Email
 }
 );
 Collect(colItems: "x")
);;

but you already have the same count at the top. What is it that you are trying to set with the Variable ?

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