Unanswered

dynamic filter on lookup

(0) Share

Report

Posted on by bkbartje

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)

All responses (2)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
bkbartje 2 on at

Like (0)

Report

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.

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.
but I have no idea how to do this.

Was this reply helpful? Yes No