prevent duplicates in request item variables(flow designer)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2024 03:07 AM
First step: My trigger is the service catalog
Action: Get catalog variables
Third step: A for each flow logic to retrieve my multi row variables.
The scenarios is that i don't want duplicate records in a specific tables where the variables are.
So i created a custom action scripted with the variables as inputs and their values as outputs. i tested it but it's not working the i already have a BR to avoid duplication but we need the flow as well
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2024 12:58 AM
Can you share the script logic, to debug futher!
sometimes same code as BR may not work due to syntax differences
If my response proves useful, please mark it "Accept as Solution" and "Helpful". This action benefits both the community and me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2024 10:40 PM
The easiest way to avoid "duplicate records in a specific tables where the variables are" is to create the logic (i.e. Business Rules) that will not allow duplicate records to be inserted at these specific tables.