cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Srinath
Helper IV
Helper IV

Working With Combo Boxes In Power Apps

Hi,

 

I have a SharePoint list where data is stored as comma separated values for a particular column.

Eg: Column name is 'Department' and the data is stored as Sales,Marketing for a particular user A.

 

In the application i have a combo box where i want the department values to be shown as individual items based on the user name selected from a combo box above.

 

How can i achieve this ?

 

Any help will be appreciated greatly.

 

Regards

Srinath

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @Srinath ,

 

Please try to put the following codes to Combo box Items property and DefaultSelectedItems property.

 

Split(First(Distinct(Filter(TableName,Country=CB_CountryNew.Selected.Result&& EmployeeEmail=VarUserEmail),'Project Department')).Result,",")

 

Modify Update property of Data Card to convert the selection to Text when submitting.

 

Left(Concat(CB_Department.SelectedItems,Result & ","),Len(Concat(CB_Department.SelectedItems,Result & ","))-1)

 

Test Result:

Snipaste_2020-03-16_14-24-42.pngSnipaste_2020-03-16_14-25-24.png

Hope this helps.

Sik

View solution in original post

5 REPLIES 5
mdevaney
Super User
Super User

@Srinath
Setup Combobox2 like this:

DefaultSelectedItems
Split(ComboBox1.Selected.Departments,”,”)

Items (must include every possible option)
[“Marketing”,”Sales”]

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Hi @mdevaney ,

 

Please find attached some screenshots of my app. Kindly suggest how I can implement the above solution here.

 

Regards

Srinath

@Srinath
Have you tried my suggestion above?

If not, create a new ComboBox and insert the code I suggested in those properties.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
v-siky-msft
Community Support
Community Support

Hi @Srinath ,

 

Please try to put the following codes to Combo box Items property and DefaultSelectedItems property.

 

Split(First(Distinct(Filter(TableName,Country=CB_CountryNew.Selected.Result&& EmployeeEmail=VarUserEmail),'Project Department')).Result,",")

 

Modify Update property of Data Card to convert the selection to Text when submitting.

 

Left(Concat(CB_Department.SelectedItems,Result & ","),Len(Concat(CB_Department.SelectedItems,Result & ","))-1)

 

Test Result:

Snipaste_2020-03-16_14-24-42.pngSnipaste_2020-03-16_14-25-24.png

Hope this helps.

Sik

Hi @v-siky-msft ,

 

Thanks for the response. I have tried your solution and it works.

 

Regards

Srinath

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.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,305)