Composite Key duplicate check

(0) Share

Report

Posted on by Applicable88

254

Hello,

I'm trying to setup a composite key duplicat check on two datacardvalue fields of a sharepoint list. The check happens after I click on the submit button:

If ( IsBlank( Lookup(Table; ProductID = DataCardValue1.Text &&
 'Deparment ID' = DataCardValue2.Text .....

The duplicate check is not working for Department ID. Not even if I just check for duplicates of department ID without ProductID.

The sugguestion the system gives me is in 'Deparment ID' in single quotes. I also tried to change that, but seemingly it needs the quotes because of the space in the middle.

The other difference the Department ID is different vs. the ProductID is that its a dropdown selection and not a free text field.

Whatevery I do, the intellisense always marks the equal sign between 'Department ID' = DataCardValue2.Text with a red unterline.

Thank you very much in advance

Best.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Applicable88 254 on at

Like (0)

Report
Copy link

Link copied!

I now have basically made a double check and can confirm that if (IsBlank( Lookup .....
is not working out on a drop down datacard.
What wonders me is that the lookup function is searching at the underlying content of the sharepoint list and why should a dropdown be different to a free text field?

I hope someone has an solution to this.

Best.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Applicable88

What type of column is department id?

Was this reply helpful? Yes No
Verified answer

Applicable88 254 on at

Like (0)

Report
Copy link

Link copied!

Hello @Drrickryp,
in Sharepoint List Department ID is a "Choice" column. When using a SharepointList as source, PowerApps automatically detect it as Dropdown menu. Here I got an example

Is there a problem using Lookup function of that kind of column type?

Best.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Applicable88

Try 'Department ID'.Value BTW, the screenshot appears to show a different column.

Was this reply helpful? Yes No
Applicable88 254 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp thanks for the quick response. The screenshot is just from a blog page reference, not my actual columm.

Okay, I tried DataCardValue.Text not working.
Now I tried Value, SelectedItems also not working.
What attributes could it else be?

I just did an check with another column type which is a slider like boolean.
In this case using DataCardValue.Value it worked.

So a "choice" column must be classified as something different than .Text and .Value?

Was this reply helpful? Yes No
Verified answer

Applicable88 254 on at

Like (0)

Report
Copy link

Link copied!

I found it its apparently Columnname.Value = DataCardValue.Selected.Value

Was this reply helpful? Yes No