Forum Discussion
Using the ID column to generate a number in a calculated column.
Hello. I was wondering if I could get some help with an issue I'm currently having. I'm trying to generate a ticket number system based on the ID column for an existing sharepoint list. The new ca...
Make sure your column Data type returned is set to Text?
It's always set to single line text
- I always use flow for stuff like this. Any reasons why you couldn't just create a flow to set that Value when a New item is created in the list?
- Well, the list is already populated with items. I'm not sure that kind of flow would work retroactively.
SuzanoSho Consider this:
- For existing list items: create a power automate flow with manual trigger, read all item using "Get items" action and then update column value using ID from dynamic content for each list items - This will be one time activity only
- For new items (in future): create a automated power automate flow with "When an item is created" trigger and use single "Update item" action which will update column value using ID from dynamic content
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Calculated don't even work for me from ID either right now, just stays blank until I go "save" the column settings again.
