Showing results for 
Search instead for 
Did you mean: 
New Member

Lookup not working properly in ForAll?

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 :




'Salary Series',
Defaults('Salary Series'),
{'Employee ID':
'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.


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! 🙂

Super User
Super User

Excellent I am so glad it all worked out

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

thank you randy.


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,419)