I have a scheduled Flow in ServiceNow that generates Smart Assessments for control records.
Current setup:
- Trigger: Scheduled
- Lookup Records: Table = Control Table
Look Up records Filter:
- state != retired (Retired value = retired)
- Primary control owner (field = owner) is not empty
Flow Logic: For each control record → Generate Smart Assessment → Assessor = Control Owner
This works fine and creates one assessment per control record.
Help I am looking for: If a Control Owner has multiple controls (e.g., Owner 'A' has 6 controls), the system should generate only one Smart Assessment for that owner.
Question: Is there any way to group by Control Owner (or any Lookup Records field) in Flow Designer so that I can trigger one assessment per owner instead of per control?
