Is the a way to use Fomulamap in another Formulamap and use different CurrentValues?

[Artem_F]

So here is the case:

I have a form that has 3 fields: Text, MultiSelect1, and MultiSelect2.

I would like to add a row to a table for each combination possible.

For example, if the user selected MS1 - 3 options, and MS2 - 2 options, I want to add 6 rows using 1 button click:
Text, MS1.Value1, MS2.Value1
Text, MS1.Value2, MS2.Value1
Text, MS1.Value3, MS2.Value1
Text, MS1.Value1, MS2.Value2
Text, MS1.Value2, MS2.Value2
Text, MS1.Value3, MS2.Value2

I tried FomulaMap(MS1, FormulaMap( MS2, AddRows(Table, Column1, Text, Column2, CurrentValue…
And then I realized that there is only one CurrentValue and I can’t refer to the other one inside inner FormulaMap.

Is there a proper way to do this or I need to use a different solution (which I found knowing that MS1 has static 2 values, so I could use an IF() for that?

[Christiaan_Huizer]

hi @Artem_F , welcome.

Yes you can via WithName()

Launched: Reuse logic and create nested loops with the new WithName() formula

We’re excited to introduce the new WithName() formula which enables two key scenarios - reusing logic within a formula, and nested loops. [WithNameExample] Reusing logic within a formula Sometimes you need to use the same logic twice in different parts of the formula. Until now, you had a few choices: Duplicate the logic twice. For example: If( Tasks.Filter(Team="Eng").Count() > 0, Tasks.Filter(Team="Eng").Count(), “Done!” ) Create an intermediate column or named f…

@Federico_Stefanato is a great fan of this approach, examples he provided using WithName() are:

Help with nested loops and the new WithName() formula

Hi @Breno_Nunes , basically you are asking the button - in plain english: Hey, would you please create a new row in the Item table for every entry that is selected in the Orders table The key here is for every and the only way to instruct the processor to do that is through FormulaMap(). The WithName() function only allows to, well, give a name to an expression. I have the feeling you might have interpreted the RunActions() as an implicit FormulaMap() “For every row of my dataset do…”. …

best, christiaan

[Artem_F]

Thanks, i hoped i could find some posts myself, but i guess i was using wrong search terms