Filtering by related record on Lookup doesn't work in new PA Editable Grid

(0) Share

Report

Posted on by ArnaudD

Hello everyone,

I have been recently trying my hand around the new Power Apps editable grid and I'm currently facing an issue : I'm trying to filter a lookup based on the selected record on another lookup (Filter by related record), I currently have the following setup :

I have a table Specialisation where each record can be a parent or a child.

The parent field is a Lookup on the table Specialisation as you can see here :

specParent1 has 3 children : specFils1, specFils2 and specFils3

specParent2 has 2 children : specFils4 and specFils5

The thing I wanted to achieve was the filtering by related record that was previously implemented in the old editable grid like this, meaning that if I select a parent in specialisation only its children will be displayed in sous-specialisation :

In the old grid it's working perfectly fine but once I try to replicate this behaviour using the new grid with a rather similar setup, all the content of the Specialisation table gets displayed instead of the filtered values I'm looking to get :

If any of you have any idea how I could fix this, I'm eager to hear your suggestions

It might just be a bug, after all it's still in "preview" but since there's not much documentation available at the moment and since I'm rather new to this environment I want to make sure that the issue isn't coming from my side or if I'm missing some parameters !

Arnaud

All responses (2)

Answers (0)

ArnaudD 5 on at

Like (0)

Report

RE: Filtering by related record on Lookup doesn't work in new PA Editable Grid

Hello Eiken ,

I think there's a little bit of a misunderstanding, I know that the previous editable grid works just fine as I showed in the screenshots at the beginning of my post, the problem I'm facing is with the new grid that's in preview at the moment (see next picture, the Power Apps grid control), which is not working with the exact same setup :

And of course, I made sure to save and publish all of my modifications every time I modified my parameters

Kind regards,

Arnaud
Eiken on at

Like (0)

Report

RE: Filtering by related record on Lookup doesn't work in new PA Editable Grid

Hi,

Firstly, remember to save and publish the change in Advanced setting

Now it works well in my test app.

It is important to note that when you have finished selecting the parent, you need to deselect the record and select it again to save the parent's value.

Just like this: