I thik this is pretty simple detail. I'm just trying to get a value out of one column from the input column in an SQL table. I thought this was simple and this would work:
Anyone know where I went wrong?
Go to Solution.
I suspect this is what you're looking for....
View solution in original post
You're almost correct, but you have to provide a formula how to pick a record, and in your code there is none.
I think you might mean something like this:
LookUp('[dbo].[tbl_Drawings]', DrawingNumber = ThisItem.Part_x0020_Number,Title)
This means that you from the Drawing table you look up the title, and you pick the correct record by comparing the DrawingNumber (which I hope is a field in the tbl_Drawings) with the current record's PartNumber.
Here is a link to the documentation for Lookup: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021