Questions tagged [concatenate]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
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 ...
0 votes
1 answer
194 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 ...
0 votes
1 answer
3k 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 ...
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 ...
0 votes
1 answer
265 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 ...
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 ...
0 votes
1 answer
260 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 ...