Power Apps中如何将ThisRecord与LookUp结合实现Gallery动态过滤？

• 需求：根据用户单选控件的选择结果过滤Gallery条目，仅当Visible列的条件满足时显示对应项，用户选择的选项会写入OptionSelected列。
• 数据源结构及示例：

• 初始可行代码（固定依赖项1.1.1）：

Filter(colQuestions,
    Visible = "always" ||
    Visible = 
    Concatenate(
        First(Split(ThisRecord.Visible,",")).Value,
        ",",
        LookUp(colQuestions, Title =  "1.1.1").OptionSelected
    )
)

• 修改尝试：将固定的1.1.1替换为从ThisRecord.Visible拆分出的依赖项标题，修改后所有条目被过滤，代码如下：

Filter(colQuestions,Menu=gblNumMenu,Submenu=gblNumSubmenu, Commission=gblTextCommission,
    Visible = "always" ||
    Visible = 
    Concatenate(
        First(Split(ThisRecord.Visible,",")).Value,
        ",",
        LookUp(colQuestions, Title =  First(Split(ThisRecord.Visible,",")).Value).OptionSelected
    )
)

• 额外尝试：将Visible列拆分为独立的依赖标题列和选项列，同样无效，需确认是否可结合ThisRecord与LookUp实现动态过滤。

问题源于重复调用Split导致的上下文不一致，以及未处理OptionSelected空值情况。可通过临时变量统一上下文，优化逻辑如下：

Filter(
    colQuestions,
    Menu = gblNumMenu,
    Submenu = gblNumSubmenu,
    Commission = gblTextCommission,
    Visible = "always" ||
    With(
        {
            depTitle: First(Split(ThisRecord.Visible, ",")).Value,
            expectedOption: Last(Split(ThisRecord.Visible, ",")).Value
        },
        LookUp(colQuestions, Title = depTitle, OptionSelected) = expectedOption
    )
)

代码说明 #

1. 用With函数将Visible字段拆分结果存入临时变量，避免重复计算，确保上下文统一。
2. 非always条目直接判断依赖项的OptionSelected是否匹配预期选项，逻辑更清晰，规避字符串拼接的格式问题。
3. 保留原有业务过滤条件，保证逻辑完整性。

若依赖项的OptionSelected可能为空，可增加空值判断：

Filter(
    colQuestions,
    Menu = gblNumMenu,
    Submenu = gblNumSubmenu,
    Commission = gblTextCommission,
    Visible = "always" ||
    With(
        {
            depTitle: First(Split(ThisRecord.Visible, ",")).Value,
            expectedOption: Last(Split(ThisRecord.Visible, ",")).Value,
            depSelected: LookUp(colQuestions, Title = depTitle, OptionSelected)
        },
        !IsBlank(depSelected) && depSelected = expectedOption
    )
)

内容的提问来源于stack exchange，提问作者rafa777777