I am sure this might be easy but I'm very new to flow and couldn't figure out how to achieve the below requirement and feeling trapped in a loop.
When all of the necessary Subject records have been added to a Chronology, the user selects the ‘Find Events’ button which then fires a flow that finds all of the CONTACTS and Persons linked to the Chronology and then uses that list to find all relevant Events. For each Event, a corresponding Chronology Item record is created
Chronology Items: lookup: Chronology AND Event
Subjects: lookup: Chronology, contact and Persons
I tried to this way:
- Get records: Chronology with the record id
- Get records from the subject with matching same record id
- Get records: relevant events
- loop: on event
- create records for chronology items.
Maybe I'm failing to fetch the right records. any help would be appreciated. thank you