Power Platform Community Forum Thread Details

Anyone else see either a change of behaviour or a bug with how Offline-Enabled Clients handle patching Look Up columns since around mid-August? Before mid-august, we had the same logic (below) for patching for both offline enabled and non-enabled clients which worked without issue:

Patch(
            'Review Findings',
            ForAll(
                colReviewLinesOriginal,
                {
                    'Review Line': LookUp(
                        'Review Lines',
                        'Review Line - ID' = colReviewLinesOriginal[@'Review Line - ID']
                    ),
                    Visit: LookUp(
                        'Visit Overview',
                        'Visit Overview' = gblVisitOverview
                    )
                }
            )

Then after mid-August we got the error below when attempting to run the above on an offline-enabled client:

message": "Prepare statement failed: SQL logic error (1) - no such column: new_reviewline0.new_ReviewArea"

We tried multiple things to resolve, but the only resolution we found for offline-enabled clients was to change the LookUp elements to items in a collection:

ClearCollect(
            colReviewLinesTemplate,
            //This filter isn't required from a process perspective, but without it the patch below will still fail.
            Filter(
                'Review Lines',
                Status = 'Status (Review Lines)'.Active
            )
        );
        ForAll(
            colReviewLinesTemplate,
            Collect(
                colReviewLinesPlaceholders,
                {
                    reviewLine: ThisRecord,
                    reviewLineVisit: First(colVisitOverview)
                }
            )
        );
        Patch(
            'Review Findings',
            ForAll(
                colReviewLinesPlaceholders,
                {
                    'Review Line': reviewLine,
                    Visit: reviewLineVisit
                }
            )
        )

We’ve had a support ticket open with Microsoft for a couple of weeks but it’s yet to make any real progress. The issue above has impacted multiple of our apps and all been resolved in the same way.

Categories:

Building Power Apps