You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Flow - Parameter which dynamically populates value based on value of another parameter

Incorrect Answer
31
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!