Unanswered

Display related field from native N-N relationship (Products - Knowledge Article)

(1) Share

Report

Posted on by FC-02051025-0

Hello,

I'm building a custom page where I need to create a tree view using data from native Products and Knowledge Articles tables (Customer Service). For this I'm using a primary gallery (Products) and a nested gallery (Knowledge articles).

As there is a relationship between the 2 tables (msdyn_product_knowledgearticle), for the nested gallery I had the intention of using:

ThisItem.'Knowledge Articles'

just like I've done with other tree view (Categories - Knowledge Articles). But for this particular relationship it seems I can't reach the other side.

I would really appreciate some help finding how I can relate these 2 tables.

Thank you for your help!!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

MudassarSZ365 591 on at

Like (2)

Report

Hi @FCLucena ,
Check if there's a direct look-up or related table option in your Power Apps environment that you can use.
If not, you might need to fetch the Knowledge Articles separately and then filter them based on their relationship to the selected Product.
Essentially, you're looking to recreate the relationship logic within your app - showing articles that are tagged with the product you're focusing on.
If this is still confusing or you're stuck, it might be good to look for guidance on forums or ask for more detailed help, maybe even from Microsoft's own support if you think it's a feature that should be there but isn't working.
If this works for you, please mark it as the "Accepted Solution."

Was this reply helpful? Yes No
Ninja_365 99 on at

Like (1)

Report
Hi @FCLucena ,
Retrieve Related Data:
Since ThisItem.'Knowledge Articles' isn't working, it suggests that the direct relationship isn't accessible in this manner.
You may need to use a LookUp or Filter function to manually retrieve the related Knowledge Articles for each Product.
Example Formula:
In the nested gallery's Items property, you could use a formula like:
Filter(KnowledgeArticles, ProductID in ThisItem.RelatedProducts)
I hope this gives you a starting point for connecting your tables! If you find this solution helpful, please feel free to accept it. 😊

Was this reply helpful? Yes No