Forum Discussion
How to populate the TITLE column (via Power Automate?)
jensjakobsen1966 DhirenMehtaMSFT ,
Appreciate the idea of not requiring a value in the title column, as that was a great start for my SP List. 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.
I'd like to discern which flow trigger works best to auto update a new item with a sequential number (ie: SP List has 1 intital entry, and the next "create new item" updates the number column to 2, and so-on.
Is this possible with triggers: 1) when an item is created, 2) when an item is created or modified? Or is using "calculated value" in list settings an option? I'm not quite sure how to "link" a new item created to the previous/last item ID number completed.
I have this working:
There is a power automate template called "Update the title of SharePoint item when a new item is created"....using that template, under WHEN AN ITEM IS CREATED enter your Site Address and make the List Name "Documents" and then under UPDATE ITEM, use the same list name "Documents" and insert the NAME column into the TITLE field. Save it and it will run each time a new file is uploaded to your library. You can show the Title field in that library to watch it populate...then hide it again. Over in your SP List, add a lookup, documents, Title field (i allowed multiple values). Then in list settings\advance settings, set "attachments to list items are:" to DISABLED.
- Can you share any screen shots of the flow? I'm not sure what steps where to make the LIST NAME "Documents" as my List Names are already named something else. (not sure if this is named in the flow using data operations commands, or its the actual list name). Also unsure where the NAME column is since its not apparent in my SP List. Thanks for the idea and assisting as I'm eager to get this going.
