It is possible to use Suggested_Values to pul...

[Simon_Robinson]

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

[Lynn]

Hi @Simon_Robinson Did you try it?

[Simon_Robinson]

No, I can’t find a way to combe 2 lists

[Lynn]

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

[pravse]

Yes, that’s a valid way to combine two lists of similar type