Power Platform Community Forum Thread Details

Hello,

I've a SharePoint List which is connected to PowerApps.

I have created 2 fields with cascading dropdown to the PowerApps form.

1st is Customer Name and 2nd is Employee Name.

As per Customer Name selection we get to select appropriate name in Employee Name field.

For e.g. if below Customer names are selected from Customer Name field, In Employee Name we'll only see Cheyenne Name in the drop down

Mueller Group

Hood-Ross

Bass-Carr

Similarly if below Customer names are selected, if will show Preston's name in the drop down of Employee Name

Mccullough

Conway

Hart-Barry

Now what I'm looking for: the Customers which were assigned to Preston, now when the above Customer names are selected, we should have one more Employee name (James) to be selected.

So basically, Preston is no more responsible for any of this Customers. All are now assigned to James.

So we do not want to replace Preston name with James

Categories:

Building Power Apps

Hello @Prem4253,

Yes, without making any prior changes, you can simply implement the below code in the Employee dropdown. it will work as per your requirement. (Please note: this is a completely static implementation.)

For example, in the Items property of the Employee dropdown:

If(
    CustomerDropdown.Selected.Value in ["Mueller Group","Hood-Ross","Bass-Carr"],
    ["Cheyenne"],
    If(
        CustomerDropdown.Selected.Value in ["Mccullough","Conway","Hart-Barry"],
        ["James"]
    )
)

//CustomerDropdown - Replace this with customer name dropdown.

Approach 2: Recommended Solution

If you want a cleaner long-term solution, you can maintain a small mapping list in SharePoint instead of hardcoding names in the formula.

Like your list stracture: Assumed List name is : CustomerEmployeeMapping

Column Name	Data Type
Customer Name	Single line of text or LookUp
Employee Name	Single line of text or (Person or Group)

Set the Items property of the Employee dropdown to: (Below expression based on assumed single line of text column configuration in list)

Filter(
    CustomerEmployeeMapping,
    CustomerName = CustomerDropdown.Selected.Value
)

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!