Answered

Compare Collection Titles to Column Text and Display Result Column

(0) Share

Report

Posted on by samdean332

Hello,

I am trying to create an app that allow users to input some selections of things they would like to do, and then the app displays some potential technologies. The users would make their selections here:

I created a large table in Python that contains all possible combinations of choices pre-scored and the technologies associated:

(I can remove commas and stuff if needed)

Now, where I am getting confused is how to compare a given set of selections to the Choices and subsequently display the technologies associated with that Choice. From looking around, it looks like this should be a simple If statement like:

I could see that it could be a Match or MatchAll function as well. But, how do you use Collections as a reference to a table? Can you use a collection as a single set? And, equally as importantly, how do you display output in PowerApps? Is there a show/print type function, or do you have to send results to an Object to display?

Thank you and let me know if you need more info

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @samdean332 ,

Try below formula OnVisible of the screen:

Clear(colTemp); ForAll(_categorySelections As C, Collect(colTemp, {Choice: C.Value, Tech:LookUp(Table1,Choice = C.Value).Tech}))

Then the colTemp table will contain all Choices and all Techs associated with the choice base on the table1.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
samdean332 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni Thank you for the help. I am not getting any errors with the formula, but how can I display the result to check if it correct? Overall, I really do not understand how to view variables, results, or debug in PowerApps. Monitor tells me success, and shows the function/data, but I do not see any of my custom "inputs"

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @samdean332 ,

Sorry for the delay.

You could add a Gallery with its Items property set to the collection, display column set to ThisItem.Choice.Value and ThisItem.Tech

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No