Help with an action to put a specific column data into the correct row in another table.

[Natt_Boarer]

I have written the following (and tried a few other iterations) but do not understand why it doesn't work...

This is the value for "Set these columns" inside an action. I want to take CheckInId from the table VisitorDetailsHealthAllergen and put it into the corresponding row in the table BookInAVisitor.

SELECT(VisitorDetailsHealthAllergen[CheckInID],(BookInAVisitor[VisitorName])=[_THISROW].[VisitorName])

Many thanks if anyone can point me in the right direction.

[Tommy62]

Schaue folgendes Erklärvideo für dieses Thema: So aktualisieren Sie eine Tabelle mit Formulareinträgen aus einer anderen Tabelle