cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 @Anonymous ,

 

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

@Anonymous
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.
Anonymous
Not applicable

Hi @mdevaney ,

 

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

 

Regards

Srinath

@Anonymous
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 @Anonymous ,

 

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

Anonymous
Not applicable

Hi @v-siky-msft ,

 

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

 

Regards

Srinath

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 (3,325)