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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
192 | |
45 | |
44 | |
38 | |
35 |
User | Count |
---|---|
262 | |
83 | |
82 | |
70 | |
69 |