You’re offline. This is a read only version of the page.
62
I have a bridge table used to manage Many to Many relationships (DB_Lookups). The Bridge Table has 3 LookUp columns, one to People, one to Groups and One to Orders. This allows me to manage the relationships between People & Groups, Groups & Orders and Orders & People.
If I create a new Order and link it to People, the Groups column is Blank, if I Link People to Groups, the Order column is blank.
I've go a galley on an Order Page where I want to show the People linked to that order and use the LookUp table to do this and all works fine until I also have a Group associated with the Order is that record is also displayed as an entry is included in the LU_Order Column alongside the LU_Group (to make the relationship).
Filter(
DB_Lookups,
LU_Order.ORD_ID = var_OrderRecord.ORD_ID
)
To get around this, I tried the following...
Filter(
DB_Lookups,
LU_Order.ORD_ID = var_OrderRecord.Ord_ID And !IsBlank(LU_Groups)
)
Turned out to be a simple fix / error on my part.
&& IsBlank(ThisRecord.LU_Groups))
I will shift this over to the Dataverse forum - I am a SharePoint user
Unfortunately this doesn't solve the issue - I still get a delegation warning under the And & LU_Groups, but the = also gives an error as they are incompatible types for comparison .
Hi @ThomasRConnor ,
Try
Share
Report
All responses (
Answers (
Filter(
DB_Lookups,
LU_Order.ORD_ID = var_OrderRecord.Ord_ID And LU_Groups = Blank()
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
