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.

 

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.

@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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,010)