Bug? Cannot assign record to variable

[PaulD1]

Using CDS as data source.

The following works as expected:

LookUp(  
        'Pre Inspections',
        'Pre Inspection' = GUID(lblStatusPreInspectionId.Text)
    ,'A-Pillars')

'A-Pillars' is an option set.

I need to set the default of many checkboxes based on the fields in the entity, so I assign to a variable as follows, using First(Filter instead of LookUp so I can use a ShowColumns expression to ensure all the desired columns are returned:

Refresh('Pre Inspections');

//Need to specify the columns to be returned as 'Explicit Column Selection' cannot be trusted, but needs to be turned on to avoid App breaking if MS change core entities again
Set(
    varPreInspectionX,
    First(
        Filter(
            ShowColumns(
                'Pre Inspections',
                "dsl_preinspectionid",
                "dsl_apillars",
                "dsl_aftermarketelectronics",
                "dsl_completiontimediscussed",
                "dsl_dashboard",
                "dsl_dashlights",
                "dsl_hoodlining",
                "dsl_repairprocessandexpectationset",
                "dsl_replaceallstickers",
                "dsl_rustdiscussion",
                "dsl_seating",
                "dsl_wipers",
                "dsl_wipewashtested",
                "dsl_adasbreifing",
                "dsl_adassystemcheck",
                "dsl_caltechtaginvehicle",
                "dsl_dynamiccalibrationdiscussed",
                "dsl_enoughfuel",
                "dsl_noexcessrearaxleweight",
                "dsl_rearwheelsdamagefree",
                "dsl_wheelarchinspec"
            ),
            dsl_preinspectionid = GUID(lblStatusPreInspectionId.Text)
        )
    )
);

Earlier this appeared to test OK, but now the returned variable is always empty.

Any thoughts as to why the variable is not being populated? The predicate for the LookUp and the Filter are the same, other than having to use the internal name in the filter and the display name in the LookUp.

[PaulD1]

I have modified the sequence of the formula to put the Filter inside the ShowColumns (rather than the other way around) as shown below. This is the only change made and now this is working again (for the moment at least, previously the other method appeared to work on Friday but was broken on Monday, so who knows?).

I suspect this is more bugs related to 'Explicit Column Selection'

Refresh('Pre Inspections');
//Need to specify the columns to be returned as 'Explicit Column Selection' cannot be trusted, but needs to be turned on to avoid App breaking if MS change core entities again
Set(
    varPreInspectionX,
    First(
        ShowColumns(
            Filter(
                'Pre Inspections',
                dsl_preinspectionid = GUID(lblStatusPreInspectionId.Text)
            ),
            "dsl_preinspectionid",
            "dsl_apillars",
            "dsl_aftermarketelectronics",
            "dsl_completiontimediscussed",
            "dsl_dashboard",
            "dsl_dashlights",
            "dsl_hoodlining",
            "dsl_repairprocessandexpectationset",
            "dsl_replaceallstickers",
            "dsl_rustdiscussion",
            "dsl_seating",
            "dsl_wipers",
            "dsl_wipewashtested",
            "dsl_adasbreifing",
            "dsl_adassystemcheck",
            "dsl_caltechtaginvehicle",
            "dsl_dynamiccalibrationdiscussed",
            "dsl_enoughfuel",
            "dsl_noexcessrearaxleweight",
            "dsl_rearwheelsdamagefree",
            "dsl_wheelarchinspec"
        )
    )
);

[v-xida-msft]

Hi @PaulD1 ,

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

As an alternative solution, I agree with your second formula you provided.

Best regards,

[PaulD1]

Did you try with 'Explicit Column Selection' turned On?

[v-xida-msft]

Hi @PaulD1 ,

Yeah, I have tried to turn on the "Explicit Column Selection" option within Advanced settings of App settings of your app. The formula works well on my side.

Best regards,

[PaulD1]

Thanks for checking @v-xida-msft 

Can only say that variations of this same formula appear in multiple places in my App. On Friday we did a test and they worked, on Monday they did not and I had to alter as per my earlier post to get them functioning again (i.e. put the filter inside the ShowColumns command rather than vice-versa)

[v-xida-msft]

Hi @PaulD1 ,

Yeah, I agree with your solution almost. I think this issue may be a temporary issue within PowerApps app, and this issue may be fixed at next updates.

As an alternative solution, please apply the Filter function to your CDS Entity data source firstly, then add ShowColumns function to expose these columns you want to display within your canvas app.

If this alternative solution could achieve your needs, please consider go ahead to click "Accept as Solution" to identify this thread as Solved.

Best regards,