Power Platform Community Forum Thread Details

Hi! This community has been amazing in helping me workout PowerApps but I can't quite work this one out and have been stuck on it for a while so hoping someone out there can work it out!

A bit of context: I've built a PowerApp to help manage risks within our business and I have a risk matrix with impact on the Y axis and the likelihood along on the X axis (like this video Create A Custom Risk Matrix of your Projects - Project Management with Power Apps - YouTube). I have adjusted it slightly to make the Gallery work as required but to create this matrix I used a 5x5 gallery assigning each square a value (with 1 in the bottom left and working my way up across the gallery so the top right square being 25). In the SharePoint list I have a value of 1-5 assigned to each the Probability and the Likelihood so for example an A1 has a value assigned to it of 5&5 allowing for the co-ordinates to be set as (5,5) or the top right of the gallery.

Now the Problem: I have a textbox that returns the ID of the risk for each square so if I have a risk that has the coordinates of (5,3) it will be populated with that risk's which is in a separate column in the Datasource. I have the code below but as its only a lookup it returns only the first value however I want to return all values that might have the co-ordinates (5,3)!

I can't share the app as it is live already so holds commercial information but I can share the code! Any help would be greatly appreciated! Thank you!

If(
LookUp(Filter(Matrix1,Channel=Dropdown7.Selected.Value,RiskType="Point"),RoundDown(Impact,0)=ThisItem.Impact&&RoundDown(Probability,0)=ThisItem.Probability,Id)>0,

""& LookUp(Filter(Matrix1,Channel=Dropdown7.Selected.Value,RiskType="Point"),RoundDown(Impact,0)=ThisItem.Impact&&RoundDown(Probability,0)=ThisItem.Probability,Id),

"")

Categories:

Building Power Apps