Sort( Distinct('SupplierDetails',Title),Value)
!IsBlank(
LookUp(
Filter(
List2,
Title=Dropdown.Selected.Value
),
Category="Aluminium" OR Category= "Fuel"
)
)
If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!
Thanks, and happy building!
Name | Category |
Customer 1 | Aluminium |
Customer 1 | Cold Rolled Steel |
Customer 1 | Fuel |
Customer 1 | Hot Dipped Galvanised |
Customer 1 | Hot Rolled Steel |
Customer 1 | Paint |
Customer 1 | Pallet |
Customer 2 | Carbon Steel |
Customer 2 | Fuel |
Customer 2 | Hot Dipped Galvanised |
Switch(LookUp(List2,Title=Dropdown.Selected.Value).Category,1,true,2,false,3,false,4,true)
If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!
Thanks, and happy building!
ThisItem.Customer = "Customer A"