Lookup not working properly in ForAll?

[tundaka]

Hello everyone, I am fairly new in PowerApps so now, I don't know it's limitation or I just haven't found the solution.

I have a simple app that I want to do, basically it's a bulk upload tool of salary. My idea was to put it in a delimited text, and then delimit it in a gallery.

Here's my code in the upload button :

ForAll(
Gallery2.AllItems,
Patch(
'Salary Series',
Defaults('Salary Series'),
{'Employee ID':
LookUp(
Employees,
'Employee ID' = txt_employeeID.Text
)
},
{Value: Value(txt_Value.Text)}
)
)

it works, but it doesn't lookup the employee id, it only does it in the first row. (Employee ID is a Lookup column to Employees table). Hopefully someone could help me.

[tundaka]

This actually did the trick! It was a phantom string! When i tried manually typing the employee id in the gallery, it does the lookup for all, and I tried wrapping around with trim and it works perfectly!

Thank you so much @TheRobRush and @RandyHayes for helping me out ! I'm really really grateful! I can now finally sleep in peace! 🙂

[TheRobRush]

Excellent I am so glad it all worked out

[Gelos]

thank you randy.

@RandyHayes