Help with Combobox (data coming from Sharepoint list - multipleValueDelimiter)

[mapok]

Hi,

I would need your help on the multiple value delimiter in the combobox.

Based on item selected by the user , e.g. Gallery1.Selected.RobotName I would like to have a drop down with values coming from Sharepoint list (Column: Parameter).

This column is a single Text column, where I store values separated by ;

I would like to see these values as separate items in my drop down, however it seems the multiple value delimiter does not work in this case (it does not split).

I have tried to use Split function on Items:

Filter(RobotList,RobotName=Gallery1.Selected.RobotName) however it does not work as it's table, not Text, which I cannot convert.

Did anyone have similar issue and knows the solution?

BR
Martyna

[WarrenBelz]

Hi @mapok ,

Does the SharePoint list with Parameters have the RobotName as a field?
If so, calling the list SPList2 (change to your name), the Items for the DropDown/ComboBox would be.

Filter(
   SPList2,
   RobotName=Gallery1.Selected.RobotName,
 ).Parameter

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.

[mapok]

Hi @WarrenBelz 

thanks for your reply, it is not yet solving my issue.

RobotName is a list name, Parameter is the column name.

One of the values in this column is: "report;country;city"

I would like to see a drop down with 3 separate values for this selection:

report

country

city

I cannot use split for it as after Filter function I get Table, not Text

[WarrenBelz]

OK @mapok ,

Try this

ClearCollect(
   colParam,
   Split(
      Filter(
         RobotList,
         RobotName=Gallery1.Selected.RobotName,
      ).Parameter,
      ";"
   )
)

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.

[mapok]

@WarrenBelz , thanks for your reply.

unfortunately error pops up even if I use only Split functions (for now without ClearCollect):

Invalid argument type (Table), expecting a Text value instead

[WarrenBelz]

Hi @mapok ,

A little confusing here  - if you leave the Split out for the moment and do

ClearCollect(
   colParam,
   Filter(
      RobotList,
      RobotName=Gallery1.Selected.RobotName
   )
)

what do you see in the Parameter field?

[v-bofeng-msft · Accepted solution]

Hi @mapok :

Firstly, let me explain why you met this issue:

The value of “Filter(……)” or “Filter(……).’XX’” is a “Table”. The Split function can only divide “Text strings” into substring tables.

But we can handle it by “ForAll” function.

I’ve made a test for your reference:

Add a drop down control and set it’s items property to:

Distinct(Ungroup(                      /* Distinct the value*/ /* Format the table */

    ForAll(                            /* Traversing the table*/

        Filter(

            RobotList,

            RobotName = Gallery1.Selected.RobotName

        ),

        Split(                        

            'Parameter ',                

            ";"                         /* Split by “;”*/

        )

    ),

    "Value"

),Result)

 

Beat Regards,

Bof