Filtering a datatable with an If > placing results in a label > use label as string for flow

[PPSA]

• Hi all, 
  
  I'm trying to change one of my flows so it sends emails to people dependent on what is selected in the app, it currently sends to the same users regardless.
  
  I've created an initialize variable which i'm hoping i can pull a label from my app in to set them email send to.
  
  The datatable in the app displaying possible users is connected to a SP list.
  
  I want to filter the table so that if the selected item type is 3, then show all with a 2 permission in group 3 column.
  
  Some images attached to try and make this make sense.
  
  The If statement label is just showing that it is indeed returning the correct group for this item.
  
  The filter isn't returning correctly though
  
  Filter(
  PurchaseOrdersUsers,
  If(
  Gallery1.Selected.Supplier_Type = "1",
  "Group1",
  Gallery1.Selected.Supplier_Type = "2",
  "Group2",
  Gallery1.Selected.Supplier_Type = "3",
  "Group3",
  Gallery1.Selected.Supplier_Type = "4",
  "Group4",
  Gallery1.Selected.Supplier_Type = "5",
  "Group5",
  Gallery1.Selected.Supplier_Type = "6",
  "Group6"
  ) = "2"
  )
  
  Hopefully this makes sense and you can advise, thank you.
  
  
  
  
  

[PPSA]

I have tried modifying to the below and now get the attached error

Filter(
PurchaseOrdersUsers,
If(
Gallery1.Selected.Supplier_Type = "1",
"Group1",
Gallery1.Selected.Supplier_Type = "2",
"Group2",
Gallery1.Selected.Supplier_Type = "3",
"Group3",
Gallery1.Selected.Supplier_Type = "4",
"Group4",
Gallery1.Selected.Supplier_Type = "5",
"Group5",
Gallery1.Selected.Supplier_Type = "6",
"Group6"="3"))

[mdevaney · Accepted solution]

@PPSA
Like this...

Filter(
    PurchaseOrdersUsers,
    (Gallery1.Selected.Supplier_Type = "1" And Group1 = "2")
    Or (Gallery1.Selected.Supplier_Type = "2" And Group2 = "2")
    Or (Gallery1.Selected.Supplier_Type = "3" And Group3 = "2")
    Or (Gallery1.Selected.Supplier_Type = "4" And Group4 = "2")
    Or (Gallery1.Selected.Supplier_Type = "5" And Group5 = "2")
    Or (Gallery1.Selected.Supplier_Type = "6" And Group6 = "2")
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[PPSA]

Thank you @mdevaney , that works.

Now to pull the visible entries out into a label