web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / filter linking contact...
Power Apps
Answered

filter linking contact to account

(0) ShareShare
ReportReport
Posted on by 31

I'm trying to make a dropdown that shows the contacts linked to an account selected in a combobox. This should be easy to do, but I'm unable to make a filter that returns any value.

 

It seem to me the filter should be something like:

filter(contact, contact.parentcustomerid = combobox.account.accountid)

 

However Power Apps forces me to use my local language (Dutch) so I can't use the actual entity and field names. The actual filter turn out like this:

Filter(Contactpersonen, Contactpersonen.Bedrijfsnaam = KlantenComboBox.Selected.Account)

 

However, this doesn't work. Mousing "Bedrijfsnaam" (see screenshot), which I thought would be parentcustomerid, shows _parentcustomerid_value with data type table. Doing the same on Account shows GUID. Mousing over the = shows "invalid argument type".

Capture.PNG
I have the same question (0)
  • Verified answer
    flowadmin3 Profile Picture
    31 on at

    I appear to have solved the issue myself with the following filter:

     

    Filter(Contactpersonen, AsType(Bedrijfsnaam, Accounts).Account = KlantenComboBox.Selected.Account)

     

  • alrezac Profile Picture
    Microsoft Employee on at

    Hi,

     

    Thanks for your response back on this issue. It looks like you were able to figure out what was going on. I just wanted to add in a little more information here. Feel free to take a look.

     

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

     

    Regards,

     

    Alex

     

    -------

     

    Community Support Team _ Alex Rezac
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 352 Most Valuable Professional

#2
11manish Profile Picture

11manish 192

#3
Valantis Profile Picture

Valantis 128

Last 30 days Overall leaderboard