I have problem to solve simple formula. Custom form has many inputs, but I need check three of them if aren't this combination saved in the list already. If yes, need to show text with warning.

first input is a text value, second is one select from lookup dropdown input and last one is number

I created a label and I want add my formula to visible attribute:

If(LookUp(List, 'invoiceNumber:' = DataCardValue11.Text && 'supplierName' 
= DataCardValue26.Selected.Value && 'numberOfItems' = Value(DataCardValue21.text) ),true,false) 


invalid argument type Record

Is it even possible to check three different inputs from the saved data in the list?

1 Answer 1


Try using this formula:

CountRows(Filter(List, 'invoiceNumber:' = DataCardValue11.Text && 'supplierName'.Value = DataCardValue26.Selected.Value && 'numberOfItems' = Value(DataCardValue21.text))) > 0

OR something like this:

If(IsBlank(Lookup(List, 'invoiceNumber:' = DataCardValue11.Text && 'supplierName'.Value = DataCardValue26.Selected.Value && 'numberOfItems' = Value(DataCardValue21.text)).'invoiceNumber:'), false, true)

Where Lookup(...).'invoiceNumber:' should be non blank column value.

  • 1
    second formula works. thank you
    – Novice
    Commented Oct 4, 2022 at 6:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.