Need to remove duplicate from a list collector field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-26-2024 03:34 AM - edited ‎02-26-2024 03:50 AM
In Mapped application service table there is filed stakeholders which should include owned by + managed by + delegate + support by + others. (see the first attached file)
There is a catalog "Create/Update application services" where there are two option which are Create option and another Update option. In update option we need to update stakeholders with formula as bellow.
1) if new owned by, managed by, support by, delegate not updated then the stakeholders filed should be existing owned by + existing managed by + existing delegate + existing support by + other (if anything updating other than four item).
2) if new owned by, managed by, delegate, support by updating then it should be new owned by + new managed by + new delegate + new support by + other (if anything updating other than four item).
Also, the stakeholders field should be a unique filed, it should not contain duplicate value (means if owned by, managed by, delegate, support by or others are same then it should be select anyone. Please see the workflow and scripts screen shots.