Answered

Create record if it doesn't exist with lookup column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I need a form to Check if a record exists, and if not create a new record while setting a lookup column of that new record. HE is the code I have OnVisible for my form.

If(IsBlank(LookUp('In-Depth Review', CRUCaseID.Id = Value(BrowseGallery1.Selected.ID))), Patch('In-Depth Review', Defaults('In-Depth Review'), {CRUCaseID: {Id:BrowseGallery1.Selected.ID, Value: BrowseGallery1.Selected.ID}}));

It isn't throwing any errors but it also doesn't seem to do anything.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,686 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

As much as I wonder why Lookup fields are used at all (I have never found the need and they can cause you unwanted and unnecessary grief), there are two issues here

If( IsBlank( LookUp( 'In-Depth Review', CRUCaseID.Id = Value(BrowseGallery1.Selected.ID) ) ), Patch( 'In-Depth Review', Defaults('In-Depth Review'), { CRUCaseID: { Id:BrowseGallery1.Selected.ID, Value: BrowseGallery1.Selected.YourFieldName } } ) );

This line

CRUCaseID.Id = Value(BrowseGallery1.Selected.ID)

is not Delegable (it is a Relational query and SharePoint is not a Relational database) and therefore you will have issues on larger data sets and this part

Value: BrowseGallery1.Selected.ID

as per my main code above needs to be the field name (not the ID) being looked up in the list contained in the gallery.
You can solve the Delegation issue with

If( IsBlank( LookUp( 'In-Depth Review', CRUCaseID.Value = BrowseGallery1.Selected.YourFieldName ) ), Patch( 'In-Depth Review', Defaults('In-Depth Review'), { CRUCaseID: { Id:BrowseGallery1.Selected.ID, Value: BrowseGallery1.Selected.YourFieldName } } ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Awesome, thanks for the help.

Two additional questions for you if thats alright.

1. Should I replace the Lookup column with a simple int? I really just need to use the ID to link list data together so if a lookup column is unnecessary i'm fine with just getting rid of it.
2. Should I do away with multiple lists? I separated the needed fields into various appropriate lists in order to keep the data more organized (which may have been self-defeating). Would it be better if I had the 200+ fields in one list to simplify the project?

I'm very new to Powerapps so learning how to properly build an app with list data is a must.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I am also getting the error:
"Behavior Function in a non-behavior property. You can't use this property to change values elsewhere."

Was this reply helpful? Yes No
WarrenBelz 155,686 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Firstly what is your Data source - I assumed SharePoint. If so, the answer to #1 is to use a text field. #2 depends on your data structure, but if the lists are identical in field names, certainly make one list.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This fixed it for me. Needed to put the CRUCaseID: In the brackets.

If(
IsBlank(
LookUp(
'In-Depth Review',
CRUCaseID = Value(BrowseGallery1.Selected.ID)
)
),
Patch(
'In-Depth Review',
Defaults('In-Depth Review'),
{
CRUCaseID: BrowseGallery1.Selected.ID
}
))

Was this reply helpful? Yes No