Questions tagged [concatenate]
The concatenate tag has no usage guidance.
7
questions
0
votes
1
answer
349
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
468
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
74
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 ...
0
votes
1
answer
665
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 ...
3
votes
2
answers
169
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
519
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
167
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 ...