cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mapok
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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.

Ive made a test for your reference:

Add a drop down control and set its 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)

 MyTest.PNG

 

 

Beat Regards,

Bof

View solution in original post

6 REPLIES 6
WarrenBelz
Super User
Super User

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
Frequent Visitor

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

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
Frequent Visitor

@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

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
Community Support
Community Support

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.

Ive made a test for your reference:

Add a drop down control and set its 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)

 MyTest.PNG

 

 

Beat Regards,

Bof

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,093)