Skip to main content
Community site session details

Community site session details

Session Id :
Power Pages - Power Apps Portals
Unanswered

dynamic filter on lookup

(0) ShareShare
ReportReport
Posted on by 2

Hello,

I have a form in a powerapps portal.
this portal has a loockup field for which I would like to add a dynamic filter based on earlier selected values.

 

At the moment, I remove invalid values during the "loaded" event. But this is a little bit of an ugly solution as I sometimes have 0 results on one of the pages.

I would like to apply a filter on the POST request so powerapps only retrieves valid values.

 

How could I do this?

  • bkbartje Profile Picture
    2 on at
    Re: dynamic filter on lookup

    Hello Oliver,
    I already came past this post and this actually is how I implemented it at the moment.
    But in my situation there is a challange.
    the example in the article shows 10 results and with 10 results this will work perfectly.

    But in my scenario at the moment there are 30 results and it most likely will grow a lot.

    When I apply the example there is paging,
    the first page will show me 2 results, en 2nd page doesn't show me any results and the 3th page will show me 1 result.

    bkbartje_1-1636105516029.png

     



    what I actually want in this case is to have 1 page with 3 results.
    I think the only way to accomplish this is for some how to inject the filter during the post request.

    bkbartje_0-1636105462929.png

    but I have no idea how to do this.

     

  • oliver.rodrigues Profile Picture
    9,342 Most Valuable Professional on at
    Re: dynamic filter on lookup

    Hi, can you see if this helps: https://oliverrodrigues365.com/2021/01/24/power-apps-portals-custom-lookup-filter/

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35