I have a SharePoint list that stores visitors that have been approved to come one site. I have a Power App that will allow the Security guard to search for that visitor and return their information for them to verify. What I'm having issues with is that they want to time stamp a check in on to the List Row. I found some FX code that will add the stamp to the cell but create a new row not associated with the visitor.

I found another code that looks to do what I want but the lookup commands are throwing up errors,

The Second bracket is saying invalid number of arguments: Received 1, expecting 2 or 3.

the colon is saying 'unexpected character. The formula contains 'ParenClose' where 'colon is expected

​

Also if we can add who checked them in (typed field) that would be perfect.

Set(lookupRecord, LookUp(List:'SP List'.Title, 'Visitor Name'.Text, 'Employee Name': DataCardValue4.Text, 'Employee Email': DataCardValue12.Text);

​

If(

// if no record exists create a new one

DataCardValue3.Selected.Value = "Checked in" And IsBlank(lookupRecord),

Patch(

'SP List',

Defaults('SP List'),

{

"Visitor Name': DataCardValue7.Text,

'Employee Name': DataCardValue4.Text,

'Employee Email': DataCardValue12.Text,

'Checked In': Now(),

}

),

​

//if the record exists update instead

DataCardValue3.Selected.Value = "Checked in" And IsBlank(lookupRecord),

Patch('SP List', lookupRecord, 'Checked In': Now()

https://preview.redd.it/obm8jx4dapk91.jpg?width=704&format=pjpg&auto=webp&s=e5dfcb03869cfcf7fa229b31d32979d538d33bc0

​

https://preview.redd.it/xcsxcdofapk91.jpg?width=703&format=pjpg&auto=webp&s=24c6d3f9e5aaa986272d27b7a27f11f4a9deb01e