Power Platform Community Forum Thread Details

Hi,

We have a platform where we offer a couple of Trusted Tools. Based on a questionnaire, we're advising which trusted tools are best to use based on the users use case and tool experience. Currently I'm busy with integrating the users' tool experience with the question "What (related) tools or languages are you experienced in?". This question is a multiple-choice ComboBox where users can search and select a lot of tools.

These tools are part of a Sharepoint list and are each related to a Trusted Tool which we offer on our platform. The Sharepoint List (Collection name: Tree) contains among other columns two columns named "Related tools (4.1)" and "Results" with the following content (an extract of the entire dataset):

Related Tools	Results
GNU Octave	MATLAB
Scilab	MATLAB
Maxima	MATLAB
Java	Python
C++	Python
R	Julia
Scilab	Julia

In the ComboBox I let users select the tools which they are experienced in. The ComboBox items are: "Distinct(Tree,'Related tools (4.1)')".

What I can't wrap my head around is how can I create a collection named AnswerCollection with the Tree.Results based on the selected values in the ComboBox? Least I need is an outcome with the results like this:

Results

MATLAB

Python

Julia

This way I can create a calculation based on weights and advise a tool based on a percentage. For example: "Based on the questionnaire, we suggest you to use our Trusted Tool(s): Databricks 90%, Python 60%, MATLAB (40%)."

I've tried a LOT of solutions already but none seem to work, as the ComboBox is a table and I have to compare each value of the table with the strings in the Tree collection and then retrieve the correct Results from the Tree collection.

Categories:

Building Power Apps