Ok, so I've been beating my head against the wall on this and it shouldn't be this difficult.
Say I have a general list of Materials used for construction jobs and their associated info (manufacturer, location, etc) and I have another list that assigns specific materials to be available for a job called Job Materials. This contains a lookup to the Materials table, a lookup back to the jobs table, and some other information about the job (location, startdate, etc).
Now I have a power app so that people working the construction job can tell me how much of a material was used for that job. When entering a record, I want them to select a material but only from the materials that have been associated to the job they are currently editing on. I want to do this with a job number that i show in the Job Materials list.
I have tried the following and I this does not work. Filter(Choices('Job Materials'.Materials), Value in Filter('Job Materials', JobNumber = JobNum).Material
Job Num is a variable i have in the app that stores the currently referenced job number. When I do this I get an error stating that I can't convert a text value to a "record". Fine, I get that. How do I make my dropdown just use the filtered Materials lookup column? I try and it just never returns anything.
Thanks in advance!!
