Unanswered

ForAll inside a ForAll that is inside a Collect

(0) Share

Report

Posted on by Sroldan

I have 2 ListBoxes, I'm trying to create a collection with all possible combinations of those lists. The problem in the formula is shown in the second ForAll, when you write it the SelectedItems option is not there, I tried also creating different collections and using them but it seems that it just doesn't work. This is the code I used in the Button:
Note: my powerapps is in Spanish, so there is no error in the semicolons and since comas changed to semicolons, semicolons changed to double semicollons

Collect(
Prueba;
ForAll(
ListBox1.SelectedItems;
{
varGrupoRamo: Value; // Capture the current item from ListBox1
Correo: User().Email;
TiempoEmpleado: 0;
id: 0;
// Inner ForAll loop for ListBox1_2
ForAll(
ListBox1_2.SelectedItems;
{
GrupoRamo: varGrupoRamo; // Use the captured value from ListBox1
ProcesoSV: Value; // Assuming Value is the property you want from ListBox1_2
Correo: User().Email;
TiempoEmpleado: 0;
id: 0
}
)
}
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Sroldan ,

Edit: What is it exactly you are trying to do with the second ForAll loop? I see in the first one you are defining a record, but there's no key defined before the second ForAll.

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey @Sroldan

As already mentioned its not very clear what you are intending to do so this is just a guessing.

You can try something like this:

Clear(Prueba); // Ensure Prueba is empty before adding items Clear(ColIntermediate); // Clear intermediate collection first // First loop over ListBox1 ForAll( ListBox1.SelectedItems; Collect( ColIntermediate; // Second loop over ListBox2 for each item in ListBox1 ForAll( ListBox1_2.SelectedItems; { GrupoRamo: varGrupoRamo; // Use the captured value from ListBox1 ProcesoSV: Value; // Assuming Value is the property you want from ListBox1_2 Correo: User().Email; TiempoEmpleado: 0; id: 0 } ) ) ); // Now move the combined data from ColIntermediate to Prueba Collect(Prueba, ColIntermediate);

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Sroldan 14 on at

Like (0)

Report

@mmbr1606 and @BCBuizer in the first place, thanks for answering.

What I'm trying to do is create a collection with all the possible combinations of both lists. I already solved this problem if I wanted to do it only for one of them:
Collect( Prueba; ForAll( ListBox1.SelectedItems; { GrupoRamo: Value; Correo: User().Email; TiempoEmpleado:0; id: 0 } ) )
So if I was doing it like in python it would be:
for i in ListBox1:
GrupoRamo=i
...
...

But I want to do it for both of them, so it would be like this
for i in ListBox1:
for j in ListBox1_2:
GrupoRamo: i
rocesoSV:j
Correo: User().Email
TiempoEmpleado:0
id: 0

Not Sure if this is enough to clear what I would like to do

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Sroldan ,

I think the below should do the trick for you then:

Clear(Prueba);; ForAll( ListBox1.SelectedItems As _GrupoRamo; ForAll( ListBox1_2.SelectedItems As _ProcesoSV; Collect( Pruebo; { GrupoRamo: _GrupoRamo.Value; ProcesoSV: _ProcesoSV.Value; Correo: User().Email; TiempoEmpleado: 0; id: 0 } ) ) )

After running this formula, the Pruebo collection should contain all possible combinations of the selected items in both listboxes.

Was this reply helpful? Yes No
Sroldan 14 on at

Like (0)

Report

Thank you so much @BCBuizer, that is true, it did it for me. So if anyone else reads this at any moment, my main error when I was trying, before asking, was using the Collect function before both ForAll functions and also helps a lot using the aliases (As).

Was this reply helpful? Yes No