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
Microsoft
Microsoft

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

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

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

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

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

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

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

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

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

@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 Community Champion
Community Champion

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

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?

Microsoft
Microsoft

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

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (8,388)