With(
{
_Data:
Filter(
BCPStatus,
Status = "Yes"
)
},
If(
!IsBlank(
LookUp(
_Data,
DDMarket_1.Selected.Value in MarketsImpacted.Value
)
),
"Do some stuff",
"Do some other stuff"
)
)
With(
{
_Data:
Filter(
BCPStatus,
Status.Value = "Yes"
)
},
If(
DDMarket_1.Selected.Value in _Data.MarketsImpacted.Value,
"Do some stuff",
"Do some other stuff"
)
)