web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Building a decision tr...
Power Apps
Answered

Building a decision tree in Powerapps

(0) ShareShare
ReportReport
Posted on by 2

Hello,

 

I am very new to powerapps. I have been trying to make a decision tree based on a sharepoint online list. The idea is that people are able to add items to the list so extra option become available in the application. It will be a troubleshooting application that determines the issue, possible cause, and then a solution. The idea is that people are able to add items to the sharepoint list so extra options become available in the application. The list looks something like this:

 

Head Cat.Head Cat. Desc.Sub Cat.Sub Cat. Desc. SolutionPictures
Head Cat. AHead Cat. Desc. ASub. Cat. ASub. Cat. Desc. ASolution Apic1,pic2,pic3
Head Cat. AHead Cat. Desc. ASub. Cat. BSub. Cat. Desc. BSolution Bpic1,pic2,pic3
Head Cat. BHead Cat. Desc. BSub. Cat. ASub. Cat. Desc. ASolution Apic1,pic2,pic3
Head Cat. BHead Cat. Desc. BSub. Cat. CSub. Cat. Desc. CSolution Cpic1,pic2,pic3

 

There are few steps in the decision tree:

1. Main categories

2. Subcategories

3. Possible causes

4. Solutions

 

It looks a little bit like this.

 

Formulatie - Dennis - Frame 1 (1).jpg

 

 

 

 

 

 

 

 

I am using a gallery to show the main categories. However, I only want to show the distinct values. I have managed to only show the distinct values by using distinct or group by, however, I am not able to show the main category description or the pictures. 

Screen 1 shows the main categories with:

- Picture 1

- ThisItem.Head Cat.

- ThisItem. Head Cat. Desc. 

 

Is there a way to filter for the distinct values and still show the corresponding data? Any other advice is welcome as well. 

 

Regards,

Dennis

 

Categories:
I have the same question (0)
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Hi @DennisJumped 

    This is a design issue.  You should examine your table to find One to Many relationships and separate them out as separate lists.  You then link them using the ID column of a One side in the Many side of the table.  For the rationale and how to do this in PowerApps please see my blog post here https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 519 Most Valuable Professional

#2
11manish Profile Picture

11manish 489

#3
Haque Profile Picture

Haque 327

Last 30 days Overall leaderboard