ERPIT Register - Functional Area based on operating segement

powerapps-interview-q1.yaml

If(
    drpOperating.Selected.Value = "Building Solutions",
    Filter(
        Choices([@'ERPIT Register'].'Functional Area'),
        Value = "General" || Value = "Sales & Marketing" || Value = "Operations VIC" || Value = "Operations SA" || Value = "Operations WA" ||Value = "Operations QLD" || Value = "Operations NSW" || Value = "HR" || Value = "HSEQ" || Value = "Design"
    ),
    If(
        drpOperating.Selected.Value = "RV Solutions",
        Filter(
            Choices([@'ERPIT Register'].'Functional Area'),
            Value = "General" || Value = "NRV" || Value = "Sales & Marketing" || Value = "Camec"
        ),
        If(
            drpOperating.Selected.Value = "Accommodation Solutions",
            Filter(
                Choices([@'ERPIT Register'].'Functional Area'),
                Value = "General"
            ),
            If(
                drpOperating.Selected.Value = "Corporate",
                Filter(
                    Choices([@'ERPIT Register'].'Functional Area'),
                    Value = "General"
                )
            )
        )
    )
)