cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tundaka
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.

 

tundaka_0-1648042828137.png

 

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)}
)
)

 

 

 

 

tundaka_2-1648042990979.png

 

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.

32 REPLIES 32

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
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.

@RandyHayes 

Helpful resources

Announcements
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 (2,078)