Hi Everyone,
I have a choice checkbox list in sharepoint where an employee handles different relationships.
I am trying to get all the checkbox selections items for that user to Power Apps text box field and have them concatenated as a single text line separated by commas.
However, when I try to add the field to the text box it comes up with an error saying expected a text value.
How can I resolve this?
Thanks You In Advance
Solved! Go to Solution.
@adsa ,
If you really want to go there, this should work
With(
{
vList:
Concat(
ThisItem.'External Relationships',
Value &
", "
)
},
Left(
vList,
Len(vList) - 2
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Thanks @adsa ,
You need to use Concat() - not Concatenate().
Your code is not clear as to what you are attempting, but assuming your Combo Box name is _selecteduser and that the value of a single item was
_selectedUser.Selected.'External Relationships'
then the Default of the text box with a new line for each item would be
Concat(
_selectedUser.SelectedItems,
'External Relationships' & Char(10)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Thank you for the response, however i'm still having issues.
I have created an employee directory from SharePoint. A user manages external relationships (See screenshots from the original post). These are selected from SharePoint based on with choice checkbox.
In the powerapps gallery for the employee, there are 3 dots that when clicked displays more info about that employee.
I am trying to get all the relationships (From Sharepoint) that the user is managing into a single text line in the more section about that employee.
Please bear with me as I'm new to PowerApps.
Code behind the 3xdots (more info about this employee)
Set(_selectedUser, ThisItem);
As in the sample ouput below, i am trying to have a new line that says:
External Relationships: A, C, R, F
A,C,R,F are the selections from sharepoint selected for that user.
Thanks @adsa ,
Your screenshots did not show any list that you are trying to concatenate.
How does the user select these values (what type of control in Power Apps) - and you please send a screenshot of this with some items selected.
How does the user select these values (what type of control in Power Apps) - and you please send a screenshot of this with some items selected.- This has already been selected and set in Sharepoint.
So when I look for my employee profile I want it to show all the selections from Sharepoint in this format:
External Relationships Managed: Compliance Committee, Divestment To Contract Lease Negotiation, External Accountants
No editing required in Power Apps just want to pull through whatever has been set in Sharepoint for the user to come through on the more info screen in the format above.
@adsa ,
Your original request was
I am trying to get all the checkbox selections items for that user to Power Apps text box field and have them concatenated as a single text line separated by commas.
The screen shows they are already concatenated with commas in the field. Are you asking to simply display the 'External Relationships' field in Power Apps?
The screen shows they are already concatenated with commas in the field. Are you asking to simply display the 'External Relationships' field in Power Apps?- Yes I am
@adsa ,
So it would simply be a label with the text ThisItem.'External Relationships'.
Sorry I have re-read your post several times and I am just not getting my head around this.
User | Count |
---|---|
182 | |
111 | |
88 | |
44 | |
42 |
User | Count |
---|---|
229 | |
110 | |
110 | |
69 | |
68 |