Power Platform Community Forum Thread Details

I have a combobox which is a multiselect field showing all account name from Table Accounts.

I need to autopopulate another combobox called Contacts which should get data from all contacts of Selected accounts. May i know how to achieve this?

Accounts Combobox Items Property

Choices([@Appointments].Account_Appointment)

Categories:

Microsoft Dataverse with Power Apps

You need to cascade the selection from Accounts to Contacts. Here's how to populate the Contacts combobox based on selected accounts.

Add this to the Contacts combobox Items property:

Filter(
    Contacts,
    'Account' in AccountCombobox.SelectedItems.Account_Appointment
)

This assumes:

Your Accounts combobox is named AccountCombobox
The Contacts table has a lookup field named Account pointing to the Accounts table
The relationship between Contacts and Accounts exists in Dataverse

If the relationship uses a different field name, adjust the formula. Check your Contacts table schema to see what the lookup column is called (often parentcustomerid or similar).

For multiple selected accounts, you need a different approach:

Filter(
    Contacts,
    'Account' in AccountCombobox.SelectedItems
)

If you're getting blank results, the relationship field name might be wrong. Try this diagnostic:

Add a label with CountRows(Contacts) to verify Contacts data loads
Add another label with CountRows(AccountCombobox.SelectedItems) to confirm selections register
Check the Contacts table in Dataverse to see the exact lookup field name

OnChange event for AccountCombobox:

Add this to refresh the Contacts dropdown when accounts change:

Reset(ContactsCombobox)

This clears any previous Contact selections when users change their Account selection.

Alternative using Concat for debugging:

If the filter isn't working, test with:

Filter( Contacts, 'Account'.Account_Appointment in Concat(AccountCombobox.SelectedItems, Account_Appointment, ",") )

Community site session details

Fetch all contacts of related accounts in combobox dropdown

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates