Flow - Parameter which dynamically populates value based on value of another parameter
Summary:
Hi,
How do I create a parameter in a flow which populates value in a list, based on the value entered in another parameter?
Eg: I created a flow as below. When I chose the Payroll Relationship number, the Payroll parameter should be automatically populated.
I've written the below code in the Basis value
select Max(py.payroll_name)
from PAY_ASSIGNED_PAYROLLS_DN ap, pay_PAYROLL_TERMS pt,
PAY_PAY_RELATIONSHIPS_DN pr, PAY_ALL_PAYROLLS_F py
where ap.payroll_term_id = pt.payroll_term_id
and pt.payroll_relationship_id = :payroll_relationship_id
and ap.payroll_id = py.payroll_id and pr.person_id = papf.person_id
1