How to populate the TITLE column (via Power Automate?)

Question

Hi&nbsp;I have made a&nbsp;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).&nbsp;I need to populate the TITLE field with the value from e.g. another column that I called SWIMMER.&nbsp;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?&nbsp;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?&nbsp;Any help is appreciated. Thanks.

dhirenmehtamsft · Answer

jensjakobsen1966&nbsp;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 -&gt; Columns -&gt; Click on "Title" -&gt; Require that this column contains information -&gt; Choose "No" -&gt; Save

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

jensjakobsen1966 · Answer

Yes - I need the column TITLE to be populated as I will create a PowerApp on top of it.

dhirenmehtamsft · Answer

jensjakobsen1966&nbsp;
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
&nbsp;
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.

jensjakobsen1966 · Answer

DhirenMehtaMSFT&nbsp;- thank you.&nbsp;Can we take it a step further, please?&nbsp;Some of my users will populate data directly from SharePoint, and others will do so from a PowerApp.&nbsp;So in my view, I believe I need to make a Power Automate flow.&nbsp;How would that look like?I've tried to build one, but I get an error on the GET ITEMS, that fails. I've provided 2 screendumps:1. The error, and the error description.2. My attempt at the Power Automate flow&nbsp;&nbsp;

ninjaryder · Answer

jensjakobsen1966&nbsp;DhirenMehtaMSFT&nbsp;,&nbsp;Appreciate the idea of not requiring a value in the title column, as that was a great start for my SP List.&nbsp; &nbsp;Would also love to discern how to auto update/advance a number series in a column, whether title or not, as it seems the title column needed as some sort of "anchor" to the entire list, whether used or not.&nbsp;&nbsp;&nbsp;I'd like to discern which flow trigger works best to auto update a new item with a sequential number (ie:&nbsp; SP List has 1 intital entry, and the next "create new item" updates the number column to 2, and so-on.&nbsp;&nbsp;&nbsp;Is this possible with triggers:&nbsp; 1) when an item is created,&nbsp; 2) when an item is created or modified?&nbsp; &nbsp;Or is using "calculated value" in list settings an option?&nbsp; &nbsp; I'm not quite sure how to "link" a new item created to the previous/last item ID number completed.&nbsp;&nbsp;

Forum Discussion

How to populate the TITLE column (via Power Automate?)

Share

Resources