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...
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.