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))
Solved! Go to Solution.
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.
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.
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
User | Count |
---|---|
183 | |
124 | |
88 | |
45 | |
43 |
User | Count |
---|---|
248 | |
157 | |
127 | |
78 | |
73 |