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 @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:
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 @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:
Hope this helps.
Sik
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
192 | |
67 | |
46 | |
41 | |
22 |
User | Count |
---|---|
251 | |
122 | |
83 | |
80 | |
68 |