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
Solved! Go to Solution.
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:
Hope this helps.
Sik
Hi @mdevaney ,
Please find attached some screenshots of my app. Kindly suggest how I can implement the above solution here.
Regards
Srinath
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:
Hope this helps.
Sik
User | Count |
---|---|
251 | |
102 | |
94 | |
47 | |
37 |