It is possible to use Suggested_Values to pul in two columns of unique values from 2 separate tables?
I need to combine
Select(Defect[Location],[Job]=[_ThisRow].[Job])
and
Select(Checks[Location],[Job]=[_ThisRow].[Job])
TIA
Hi @Simon_Robinson Did you try it?
No, I can’t find a way to combe 2 lists
I don’t know if it will work, I don’t have anything to test it with but you could try.
Select(Defect[Location],[Job]=[_ThisRow].[Job]) +Select(Checks[Location],[Job]=[_ThisRow].[Job])
Yes, that’s a valid way to combine two lists of similar type
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |