Lookup within patch not working

(1) Share

Report

Posted on by biancadevera

I use a gallery with checkboxes:

I have other line item aside from Shift A which are Shift B, Shift C, and Shift D. Whenever I select the checkboxes for the other shifts, it only updates the Shift A line. I'm also using LookUp to find the shift. Here's the code I'm currently using.

All - checkbox

OnCheck

Patch(db,
LookUp(db,lblEmployees.Text = ThisItem.Employee.Value),
{All: true,
EmpA: true,
EmpB: true,
EmpC: true,
EmpD: true
});

OnUnCheck

Patch(db,
LookUp(db,lblEmployees.Text = ThisItem.Employee.Value),
{All: false,
EmpA: false,
EmpB: false,
EmpC: false,
EmpD: false
});

I think I'm missing something on my LookUp function. Please help.

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @biancadevera,

I would expect the LookUp function call to lookup the record in the data source db but the following code may be comparing a control value (lblEmployees.Text) with the record value (ThisItem.Employee.Value):
LookUp(db,lblEmployees.Text = ThisItem.Employee.Value)

Try something similar to the following code, where the control value (lblEmployees.Text) has been replaced by the column in the data source (EmployeeID - change this to the column name required):
LookUp(db,EmployeeID = ThisItem.Employee.Value)
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.