Announcements
I have a SharePoint list with an ID and Principals column. Principals is a Choices column.
Is it possible to create a collection, delimiting the choices values with a comma. So my output collection would be something like :
Like this:
Collect(CollectionNew,{Text: Concat(ComboBox8.SelectedItems,ThisRecord.Item & ",")})
If you need additional help please tag me in your reply and please like my reply.If my reply provided you with a solution, pleased mark it as a solution ✔️!Best regards,Gonçalo NogueiraCheck my LinkedIn!Buy me a coffee!Check my User Group (pt-PT)!Last Post on CommunityMy website!
@Nogueira1306 Thanks for the reply.
The output is what I require, but how do I adjust the code so there is no requirement for a combobox? I want every record from list lstPrincipals to be merged.
Is that possible?
Collect(CollectionNew,{Text: Concat(lstPrincipals, Text)})
Like that, maybe?
@Nogueira1306
I get an "invalid argument type record expecting a text value instead" error with that - on the assumption I should be replacing
Text: Concat(lstPrincipals, Text)
with
Text: Concat(lstPrincipals, Principals)
Yes, you need to change to your field names... The names I wrote might be wrong.
In that case, I'm still getting the "invalid argument type record expecting a text value instead" error.
Which type of field is "Principals"?
Its a Choice column
Text: Concat(lstPrincipals, Principals.Value)
You need to insert the ".Value" after the field.
I'm getting a "invalid argument type table expecting a text value instead" error with that.
Perhaps what I want to do isn't possible?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 324 Most Valuable Professional
11manish 193
Valantis 138
