Flow Stages table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2024 11:03 AM
I am noticing when I change the stage from the Update Record action that I have multiple records of the same name. I would love to clean this up but I am having a hard time finding where these records live.
Anybody know?
- Labels:
-
flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2024 11:30 AM
Hi @Adam Peterson ,
Please right click on Stage Field on sc_req_item form and click on Configure Dictionary
Following Form will open
Scroll Down and go to Choices Related List
From here you can clean duplicate choices -
if my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful." This action benefits both the community and me.
Thanks,
Astik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2024 12:30 PM
Astik,
Thanks for your reply. I checked my instance and went to choices and only see 1 instance of Completed. Yet in Flow Designer, I have 4 records of Completed. It must be pulling from somewhere else.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2024 02:14 PM
Hi @Adam Peterson,
I believe the lists are generated from 2 tables, one for Workflow stages and one for Flow stages.
- Workflow Stages [wf_stage]
- Flow Stages [sys_hub_flow_stage]
If you look at the records in the tables, you will see that there are records with the same 'Label' but with different 'Value'. Hence you are seeing the same in the choice list within the Flow action.
It would be a lot of effort to clean these up as you will have to update all the Workflows/Flows that are using the duplicate stage values. Also, this may cause some issues with reporting or other functionalities as you are changing the value of the stage (even though the label is the same). So, unless something is broken, I wouldn't recommend changing it right way but maybe changing one at a time in the future.
Additionally, I would recommend changing the stage via 'Add a Stage' functionality in the Flow designer.
e.g.
Cheers