Check if record existed

[PowerApps11]

Hi,
I want to check if a record existed only when creating new record otherwise no check and it should patch, am using a patch, this how I wanted for example,
I am using a variable to check if the record is new / existing to start, now I need is to wrap the lookup with a variable to hold if existing found so I can reference the existing details in a label also another variable to show popup.  is this possible?
Thanks 

@WarrenBelz 

[AJ_Z]

If my understanding of what you are asking is correct the Yehp this is definitely possible. 

So to check if a record exists I am guessing you a doing a Lookup with relevant filters to find it.

If you wrap the Lookup with IsBlank() you will get a true or false to say if there is a record or not.

you can put some  Logic with an if condition on the trigger of the Patch e.g.

If(IsBlank(Lookup(Datasourcename,ID=test)),Patch(Defaults(),{....}),Patch(Lookup(Datasourcename,ID=test),{....}))

if you need some more help with this, include some examples of the code and scenario. If you have any further questions just let me know 🙂

[PowerApps11]

Hi @AJ_Z 
Yes, please would like some examples of the code and scenario.
Thank you 

[AJ_Z]

Okay just post them here and I can take a look 🙂

[PowerApps11 · Accepted solution]

@AJ_Z 
I needed to check only when new record and I stated will need to put into variable the lookup, but now I have fixed here is the formula used so it may help others if needed. 

// turn the spinner to true
Set( gblShowSpinner,true);

// This to make sure the (txtPhoneNumber) has value to function the save button

If(Not IsBlank(txtPhoneNumber.Text),

// This variable (locSetCustomerToNew) lets know the state of the NEW / UPDATE 
If(locSetCustomerToNew,


// Check if the record existed and (gblCustomerRecord) is a variable to hold the data, so i call data source only at once and reuse in the case found a duplicate.
Set(gblCustomerRecord,

 // I use filter instead lookup due to delegation as filter is delegable
 First(Filter(Customers,'Phone' = txtPhoneNumber.Text)));


// Check if the variable (gblCustomerRecord) has a data
If(IsBlank(gblCustomerRecord.ID),

// if (gblCustomerRecord) has none then create new record 

 Notify("New Record ....",NotificationType.Success),

// if (gblCustomerRecord) has an ID then show popup

 Set(varShowEditTest,true));,

Notify("Update Patched",NotificationType.Success)));

// turn the spinner to false
 Set(gblShowSpinner, false);