Forum Discussion
Solved
Text column = Calculated Column
I have two columns one is a required column that i would like to restrict to unique values. The other column is a calculated field that is concatenating 4 other columns into 1 long text string. Because I cannot set, or I do not know how, the calculated column to only allow unique values, I would like the text column, that does allow for enforcement of unique values, to just be equal to the value of the calculated column.
I have tried:
=[Title2)
=Text([Title2])
=VALUE([Title2])
none of those have worked in the field shown in image.
Thanks
- You cannot do that with SharePoint columns. You will need to utilize power apps customization form then you can concatenate values and check for duplicates etc. on that text column.
1 Reply
- You cannot do that with SharePoint columns. You will need to utilize power apps customization form then you can concatenate values and check for duplicates etc. on that text column.