Hi

I have made a SharePoint list. I really have no use for the TITLE field, as all of my other fields in that lists are getting values from a lot of dropdown values (lookup columns).

I need to populate the TITLE field with the value from e.g. another column that I called SWIMMER.

As far as I know, the TITLE column cannot get values from a lookup field by switching the default value from TEXT to CALCULATED VALUE option. If it's possible, then how do I do it?

If it's not possible, I guess I need to create a Power Automate workflow, which will copy the value from the SWIMMER field into the TITLE field?

Any help is appreciated. Thanks.

Hi

I have made a SharePoint list. I really have no use for the TITLE field, as all of my other fields in that lists are getting values from a lot of dropdown values (lookup columns).

I need to populate the TITLE field with the value from e.g. another column that I called SWIMMER.

As far as I know, the TITLE column cannot get values from a lookup field by switching the default value from TEXT to CALCULATED VALUE option. If it's possible, then how do I do it?

If it's not possible, I guess I need to create a Power Automate workflow, which will copy the value from the SWIMMER field into the TITLE field?

Any help is appreciated. Thanks.

jensjakobsen1966 a calculated column can be created and linked to the Title (or any other column) with  =[Column name] added in the formula field (Column name being the name of the column you have inserted).  This calculated column will then always have the same text string as the Title column can then be used in place of the Title field for deep links, etc

I know this isn't what you are asking, but could be a potential workaround.

jensjakobsen1966 So out of curiosity, Do you really need the Title field to be populated? if not, you can try this and see if that fulfills your requirement.
- Go to List Settings -> Columns -> Click on \"Title\" -> Require that this column contains information -> Choose \"No\" -> Save

- From the Default view and any other view, de-select Title field

jensjakobsen1966 

Ok Thanks for the detail. So you are correct in assumption that you can't set Calculated Value based on another column as Default value. See following forum discussion which explains as to why it's not possible to set it this way.
https://social.technet.microsoft.com/Forums/en-US/9c32f6fe-9391-4e13-b297-1661dd5d7a03/error-message-the-formula-contains-references-to-fields?forum=sharepointgenerallegacy

So if you are planning to use PowerApps, Can you actually create an additional column to fill out the value that you are wanting to have in that column and use it for your business logic?

- Second option would be to fire off a Flow (as you have already mentioned) once the item is created and update the Title column to the value you desire.