Answered

Filtering a dropdown of a lookup list column with a value from another column

(0) Share

Report

Posted on by discgolferusa

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-albai-msft on at

Like (0)

Report

Hi @discgolferusa ,
I cannot understand your scenario.
Do you have three lists-- Materials list, Job list and Job Materials?
Please provide more screenshots about your SharePoint list(including records and columns) and give me more information based on the data inside your screenshots.

Besides, you can refer to below article, check if the requirement is same as yours:
Solved: Filter choices - Power Platform Community (microsoft.com)
Best Regards,
Allen

Was this reply helpful? Yes No
discgolferusa 12 on at

Like (0)

Report

So when I pull up Job TJ-90432 I want it to list only the Materials associated to that job in Job Materials. Right now, it is pulling back all Materials in the Materials table.

Was this reply helpful? Yes No
discgolferusa 12 on at

Like (0)

Report

Looking at the example you gave a link for, I tried this Filter('Job Materials', 'Job Number and Name:Job Number' = JobNum).Material, but that errors because Materials is a record.

Was this reply helpful? Yes No
Verified answer

v-albai-msft on at

Like (0)

Report
Hi @discgolferusa ,
This is because Material column is still a lookup column in your "Job Materials" list.
You can try lookup() function like below(DataCardValue5 is the control name of my "Job Number" column):
LookUp('Job Materials', 'Job Number and Name:Job Number'.Value=DataCardValue5.Text).Material
Best regards,
Allen

Was this reply helpful? Yes No
discgolferusa 12 on at

Like (0)

Report

That looks like it did it! Thanks!

Was this reply helpful? Yes No