Answered

CDS : Check for record exist for lookup fields

(0) Share

Report

Posted on by anubhav29

I have a one entity which is Customer having customer Id as field, this Customer Id is part of Customer Attribute having 1 : N relationship.

Now I need to LookUp in the table whether the record with this Customer Id exist or not. How can I achieve this.

Thanks in Advanced

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

GerbenB 13 on at

Like (1)

Report
Copy link

Link copied!
Hi there, please try this snippit

IsBlankOrError(LookUp(Customers, 'Customer Id'= "1001").Name)

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @anubhav29 ,

Firstly, let me explain your issue:

1)entity1 named Customer: CustomerId(number type)

2)entity2 named CustomerAttribute: CustomerId(lookup type)

3)entity1 and entity2 has relationship of 1:N

4)you select one item of entity1, you want to check whether records in entity2 has related CustomerId

Am I right? If I have any mistake, please correct me.

If my assumption is right. Try this:

1)drop down1 for entity1, set drop down1's Items:

Customer

2)insert a label to represent whether there's record in entity has selected CustomerId value. True is yes, false is no.

set the label's Text:

If( !IsEmpty(Filter(CustomerAttribute,drop down1.Selected.Name in CustomerId.Name)), true,false )

Best regards,

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @anubhav29, Are you using model-driven app or canvas app? Thanks

Was this reply helpful? Yes No
Verified answer

Ryan S Newcomb 238 on at

Like (1)

Report
Copy link

Link copied!

You could setup a custom alternate key on the CDS entity. This should prevent duplicates from being created on the server. On a model-driven app, the user would be presented with a somewhat jarring message alert letting them know. On canvas, I’m not sure how that would be presented (probably as a runtime error...).

One thing I’ve done is setup a check in canvas apps. I use a label hidden, and set the visibility property to a Boolean expression that is basically looking in CDS to see if a record exists that matches what the user entered in the form in the app. If there is a match, the Boolean is true and so the label’s visibility property will be set to True and the label will display to the user. I’ve also set the submit button display mode property to be disabled if that label is showing.

Was this reply helpful? Yes No