Trying to patch a sign out time to existing form entry

[Svmotman]

Hello, I am currently making a visitor management application.  My goal is to patch the time out time to an existing form entry by matching the phone number provided at the beginning and end of the process. The function finishes and navigates to home but doesn't record additional data.

Current Code below:

Patch(Table1_1, Coalesce(LookUp(Table1_1, SignOutNumberData = SignInNumberData), Defaults(Table1_1)), {'Time-Out': DateTimeValue(Now(), "mm/dd/yyyy hh:mm:ss")}); Navigate('Signout Completed', ScreenTransition.Fade);NewForm(EnglishSignInForm_1)

[RandyHayes]

@Svmotman 

Is it creating a new record?  According to your formula, if there is no match to the LookUp, then it creates a new one.

Also, important, what type of column is Time-Out in your list?

[Svmotman]

It is not creating a new record after execution. The data does not appear to be added to my data table at all. In power apps I have the data type to be a number. In excel, where my data is being stored, the 'Time-Out' column is set to General.

[RandyHayes]

@Svmotman 

Ah, so Excel is your datasource.  You might consider moving to SharePoint instead at some point so that you have better control over your data.

As for your formula, there is a bit that is missing!  If the record does not exist, then you are attempting to create one.  However, you are then only writing the time and date and not the SignInNumberData.

And speaking of that SignInNumberData - What is that?  I assumed you got this somewhere in your app, but it is suspicious. 

So to troubleshoot what you have, you might want to go with some more specific tests.

Does a record get created?

Change your formula to:

Patch(Table1_1, 
    Defaults(Table1_1), 
   {'Time-Out': DateTimeValue(Now(), "mm/dd/yyyy hh:mm:ss")}
); 
Navigate('Signout Completed', ScreenTransition.Fade);
NewForm(EnglishSignInForm_1)

This will *always* create a record...does it?

Does a record exist?

Add a label to your screen and set the Text property to:

LookUp(Table1_1, SignOutNumberData = SignInNumberData, true)

This should show true if there is a matching record and false if not...what does it show and is it correct?

[Svmotman]

Thank you, this has helped with testing. 

When using that code for the patch function, a new entry is not created nor is it patched to an existing data entry. Likewise, the LookUp function returns true regardless if the number is in the data set.

SignInNumberData is the data card name for the phone number that is used to sign in for the primary data entry in SignInForm1. SignOutNumberData is the data card value for the second data entry in the SignInForm1_1 (a copy of the same form). These forms are on separate sign-in and sign-out pages. My thought process was to match the two separate data cards from the two separate forms using the provided phone number. Both SignInForm1 and SignInForm1_1 are connected to the same Table1_1 data source.

PS - We will eventually be moving over to sharepoint but that is currently going through our cooperate approval process