Answered

Patch Lookup Column in Table that is Lookup on Itself

(1) Share

Report

Posted on by IPC_ahaas

1,387 Moderator

I have a table of "Team Members" with a "Supervisor" Column. The "Supervisor" Column is a LookUp on the same "Team Members" table.

In my Power App is "ColReports" Collection of Team Member records from "Team Members".

I am trying to Patch the "Team Members" table to give all records found in the "ColReports" Collection with a specified "Team Member" record, and I keep getting stuck.

Here is the latest version of my code:

ForAll(
    ColReports,
    Patch(
        'Team Members',
        LookUp('Team Members','Team Member ID' = ThisRecord.'Team Member ID'),
        {
            Supervisor: VarSupervisor
        }
    )
)

The "VarSupervisor" Variable stores the full Record also from the "Team Members" table.

The error I on "Team Members" under "Patch" says:

The specified column is not accessible in this context

This is confusing to me as "Team Members" is a table, not a column!

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Dominik Stalzer | p... 71 on at

Like (0)

Report
Copy link

Link copied!
Hi.

Try this:

ForAll( ColReports, Patch( 'Team Members', LookUp('Team Members', 'Team Member ID' = 'Team Member ID'), // Using the direct column reference in LookUp { Supervisor: VarSupervisor // Ensure VarSupervisor is a record type } ) )

Hope this helps

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!

No change, I get the same error. on the line under "Patch".

I don't know why it think it's a column.

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!

So dumb, I created a new collection and it's working (ish)

Figure this out Microsoft, good grief!

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Copy link

Link copied!
Now the error I get is on the LookUp:

Error when trying to retrieve data from the network: The right side of the "Equal" operator must be a constant value.

Was this reply helpful? Yes No
Verified answer

IPC_ahaas 1,387 Moderator on at

Like (1)

Report
Copy link

Link copied!
I solved this:

ForAll( ColSupervisorReports, Patch( 'Team Members', LookUp('Team Members','Team Member ID' = ColSupervisorReports[@'Team Member ID']), { 'Team Member ID': ThisRecord.'Team Member ID', Supervisor: VarSupervisor } ) )

The first fix was that creating a new collection because the Power App completely screwed it up.

The second fix was using a reference to the collection in the lookup with the @.

Was this reply helpful? Yes No