I have a requirement to build a flow to check service portfolio for change request configuration item.
// Step 1: Get Parent Application Service
parent_service = LOOKUP(cmdb_rel_ci WHERE child = current.CI)
// Step 2: Get Service Portfolio
service_portfolio = parent_service.spm_service_portfolio
The lookup record is returning only one record and not checking if more than 1 record if exists. How can to return all service portfolio for parent record.
