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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter on Dataverse Form
Power Apps
Unanswered

Filter on Dataverse Form

(0) ShareShare
ReportReport
Posted on by 199

I'm building a Model Driven App. 

 

I am working with two tables - "PO Items" and "Purchased Items". 

 

PO Items has a lookup column called "Item" that points to Purchased Items. Purchased Items has two columns - "Categories" and "Name".

 

On the form for a new PO Item, I would like to select the category from Purchased Items. Based on the selected category this options for Purchased Items (Name) would be filtered. How do I do that?

 

Thank you.

I have the same question (0)
  • Verified answer
    thomasfnorthrup Profile Picture
    252 on at

    Hello, thanks for reaching out. 

    Of course you could write javascript on the form to filter the lookup but that can be complicated and would have to be updated with any changes to logic. I use the out of the box offering to filter a lookup based on another lookup on the form. 

    To do this you would need the category column on purchased items to be a lookup to a custom table called Purchase Categories, or whatever works best for you.

    1. Create custom table Purchase categories
    2. Then on PO items place a lookup column to Purchase Categories and place that on the form.
    3. Then on the Purchase Items place a lookup column to Purchase Categories. 
    4. Then back on the PO Items form editor select the lookup column for Purchase Items
      1. You may need to do this in Classic mode if in Make.powerapps.com
      2. If you open the properties of the lookup column you will see an option to filter results based another field.
      3. Select the purchase categories field on the PO Item form

    Now when a purchase category is selected on the form, the purchase items will be filtered based on the category selected. You can control if the users can disable this filter and select something else. 

    Please mark as solution or give a kudos if this helped. 

    Good luck, have a great day!

  • rbergan Profile Picture
    199 on at

    @thomasfnorthrup ,

     

    Thank you! I currently have a Category column on PO Items and a Category column on Purchased Items. They are both Choice columns looking at the same Choice set. Will that work, or do I have to go the way you are proposing?

  • thomasfnorthrup Profile Picture
    252 on at

    Hi, unfortunately the lookup will only filter on another lookup setup the way I described. 

  • ShawnBaer Profile Picture
    2 on at

    Good day, I have a form setup with two fields - both lookups as you describe above. The filter works sometimes but not all the time. Any idea why this would be or what can be causing this behavor? The App with the form is in high use and fails to filter about 25-30% of the ime.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 840 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 275

Last 30 days Overall leaderboard