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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / dynamic filter on lookup
Power Pages
Unanswered

dynamic filter on lookup

(0) ShareShare
ReportReport
Posted on by bkbartje 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?

Categories:
Power Apps portals
I have the same question (0)
  • oliver.rodrigues Profile Picture
    oliver.rodrigues 9,471 Most Valuable Professional on at

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

     

  • bkbartje Profile Picture
    bkbartje 2 on at

    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.

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 56

#2
Valantis Profile Picture

Valantis 46

#3
rezarizvii Profile Picture

rezarizvii 25

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans