Using a multiselect control and Formula Map

1

Hi,

I was wondering if someone could tell me how to use FormulaMap to add n rows to a table, with each row using a value from the multiselect control.

At the moment, I have managed to write a formula in a button that takes the values from a multiselect control and will add the correct number of rows, will map the correct collumns, however, where I am getting issues, is all the selected options in the multiselect is inserted into the one cell, then the second row is the same…

Screenshot 2023-03-20 at 11.15.09 am
Screenshot 2023-03-20 at 11.15.09 am811×398 45.8 KB

Screenshot 2023-03-20 at 11.14.32 am
Screenshot 2023-03-20 at 11.14.32 am1097×277 27.2 KB

2

Hello and welcome to the forum!

You’re pretty close, I believe it’s just the last Inverter Model that’s the issue. Try replacing it with CurrentValue

CurrentValue is set by FormulaMap, it will be every item in the list you are iterating, one by one

3

Amazing!!! Thank you.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.