Why cant I choose from the selected list in the lookup

[MatsGustavsson]

I am trying to use this to get the price for the choosen PC, but it says error on equal to

If(!IsEmpty(Valjdator3.SelectedItems); LookUp('PC-items'; Name = Valjdator3.SelectedItems.Name;ItemNumber))

[RandyHayes · Accepted solution]

@MatsGustavsson 

SelectedItems is a table.  So referring to the .Name value is not valid.

Try this for your formula instead:

If(
   !IsEmpty(Valjdator3.SelectedItems); 
   LookUp('PC-items'; Name = Valjdator3.Selected.Name;ItemNumber)
  )

I hope this is helpful for you.

[Anonymous]

@MatsGustavsson 

Should your If expression have comma instead of semi-colon, or is this a language thing?

Could it not be written Lookup('PC-Items', Name = If(!IsBlank(Valjdator3.SelectedItems), Valjdator.SelectedItems.Name, ItemNumber))

Andrew