Hey there, I have spent 3+ hours on it so far + read countless topics and blog posts, but I can't get my Patch to work.
I have 2 tables: Table called Orders and a table called Employees.
In the app people can insert orders and the Employees can either approve or decline the order.
I have a field called "Rejected by" which is a LookUp column in my Orders table. It does a LookUp to the Employees table. The tables look like this:
Employees:
| E-mail | Name |
| john.doe@gmail.com | John Doe |
| mike.tyson@outlook.com | Mike Tyson |
Orders:
| Product | Amount | Created Date | Status (Choice) | Rejected by (LookUp) |
| iPhone | 3 | 16/03/2022 | Pending | |
| Samsung Galaxy | 4 | 14/03/2022 | Rejected | John Doe |
I tried the following:
Patch(
Orders,
LookUp(Orders, Id = Value(DataCardValue_ID.Text)),
{
'Rejected by': {
Id: LookUp(Employees, 'E-mail' = User().Email).Id,
Value: LookUp(Employees, 'E-mail' = User().Email).Name
}
}
);
And multiple variations of it, but I can't get it to work. Does someone know how to do this?
I get the following error:
Kind regards
