Questions tagged [concatenate]
The concatenate tag has no usage guidance.
9
questions
0
votes
1
answer
1k
views
Configuring calculated field with column type person in SharePoint Online
I need to concatenate two columns in SharePoint, and one of them is type person. I saw that is possible to create a workflow (question 218041), but I can't use SharePoint Designer in this site. There ...
CommunityBot
- 1
0
votes
1
answer
2k
views
Concatenate Sharepoint Data using Power Automate
I have some data in a Sharepoint list, but I want to combine the information from different rows into one row. I'm very low code. I know how to use Power Automate, but I can't figure out how to use it ...
CommunityBot
- 1
0
votes
0
answers
28
views
Concatenate while using Choice column in SharePoint
I have 3 columns (ColumnA, ColumnB, ColumnC) that need to concatenate in ColumnD. Final product should look like : ColumnA-ColumnB-ColumnC
ColumnC is a multiple selection Choice column so I cannot ...
- 45.8k
0
votes
1
answer
312
views
Multiple Attributes on Same Line in Teams List Gallery View
I have a Gallery view for a teams list where I'm looking to have multiple attributes display or concatenate on the same line rather than be stacked on top of each other. For example, displaying the ...
- 286
0
votes
1
answer
4k
views
SharePoint Online - Concatenate multiple field values into Title field
Looking for a way to concatenate multiple field values [Created By] and [Category] into the "Title" field as [Created By - Category] either using column formatting or calculation values. I'm ...
- 1
0
votes
2
answers
2k
views
Concatenate SharePoint Library Columns with Multi Select Options into a Single Column
@Matiur Rahman
Here is a copy of the columns I am working with, which reside in a document library. The scenario is to combine values from each of these fields, no matter what the user selects and put ...
- 2,502
0
votes
1
answer
292
views
Different display value from real value
Is it possible to have a different display value from the actual value of the field ?
I would like to have a choice field with category codes and the actual category but only the code must show up ...
- 4,240
3
votes
2
answers
174
views
If exceed 24 hours show "23:59:59"
So I got this calculated column called "Due time" with this format in it:
=IF([Hours]<24&&[Minutes]<60;CONCATENATE([Hours]&":";[Minutes]);"23:59:59")
I only get syntax error with ...
- 45.8k
0
votes
1
answer
267
views
JSON Formatting Nested Conditions
I have a field that I want linked to either the NewForm or the EditForm
If it is null, the link generated will point to NewForm.aspx, if it has a value, I want it to point to EditForm.aspx with the ...
- 8,070