There is a case where you can change the content of a list (List 2) based on the selection in another list (List 1).
Say I have List 1 containing Countries and List 2 containing Cities. If the user selects U.S. in List 1, then only U.S. cities will appear in List 2, similarly, if the user selects Canada, only Canadian cities will be available in List 2.
Does this sound like what you are trying to accomplish? If not, please provide more information and perhaps a simplified example.
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Thanks for the reply however, my case is bit different it is like I have two List parents 1. Active Employees and 2. Inactive Employees under them they have list of respective employees name so, if any employee's leaving date is entered than particular employee's name should moved to Inactive Employee list from Active Employee list
Hi, The active status of an employee is not a structure feature and therefore should not dictate the structure of the hierarchy. Instead, the active status is a property or attribute of the list item. Therefore, create a mapping in a properties module dimensioned by the employee list. Create a line item dimensioned as the active/inactive list. Alternatively, use a boolean format. And a date or time period formatted line item if you need to differentiate across time. You can use filtering and aggregation functions in downstream formulas to differentiate data across these attributes. This is a simpler approach, does not require an action and will keep sparsity to a minimum. Good luck,
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA