web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps filter table with deep...

Power Apps

Answered

filter table with deep relationship dataverse table in power app

(0) Share

Report

Report

Posted on by newcomer

12

hello guys i have a question about how we can filter with deep relationship with power fx in power app

so my data model look like

LOT	POD	PO
LOT NUMBER [PK]	POD ID [PK]	PO ID [PK]
POD ID [LOOKUP]	PO ID [LOOKUP]

so how can i achieve all data from LOT table by select PO ID

I have try filter PODID from PO ID then there is a lot of POD ID and then i cannot continue to get all LOT from selected all POD ID

something that i've try is

Filter('Item LOTS','POD ID'.'POD ID' = Gallery2.AllItems.'POD ID')

*Gallery2 = Filter('POD','PO ID'.'PO ID' = "PO-0150")

I wonder how is it possible to compare all item from table to filter item not filter by only selected item

thanks

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

newcomer 12 on at

Like
a
(0)

Report
Copy link

Link copied!
Filter('Item LOTS','POD ID'.'PO ID'.'PO ID' = "PO-0150")
another try filter in 1 gallery but still not work
newcomer 12 on at

Like
a
(0)

Report
Copy link

Link copied!

for in SQL it be something like this

SELECT *
FROM LOT join POD join PO on LOT.POD ID = POD.POD ID
WHERE POD.PO ID = "PO-0150"
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @newcomer ,

Please try below formula:

With( {Items: Filter('POD','PO ID'.'PO ID' = "PO-0150")}, Filter('Item LOTS','POD ID'.'POD ID' in Items.'POD ID') )

Best regards,

Join the conversation