Lookup Question - text with list error

[antproberts]

I am building a proof of presence application that uses NFC tags.

I have two tables Tags and Scans.  

Tags table lists all of the tags attributed to a site and contains tag name (text) and location (Lat Long)

The Scans table also contains tag name and location with the same column types.  Basically when a tag is scanned the tag name is populated into the form, I then need an expression to pull the location for that tag over to the location column in the Scans table.  I have tried lookup however this presents errors as I it says I am comparing text with list.

Please can someone help with an expression for this?

[Steve]

Scan Record[Tag Name] is a table-column reference and produces a list value, even if there is only one value in the list. LOOKUP() expects a singular value as the first argument. To get only the first item in a list, use ANY(): ANY(Scan Record[Tag Name])

[antproberts]

Managed to fix this by using the this row reference instead of any.  

LOOKUP(Scan Record[_THISROW].[Tag Name],"Patrol Tags","Tag Name","Location")

[antproberts]

Thanks for this it seems to pull a fixed value through the first one in the list.

This is what I used?  LOOKUP(ANY(Scan Record[Tag Name]),"Patrol Tags","Tag Name","Location")

When scan the tag it does not update?

[scott192 · Accepted solution]

LOOKUP([_THISROW].[Tag Name],"Patrol Tags","Tag Name","Location") is all that is required.