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

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,358)