Unanswered

Check if record exist with multiple criteria

(0) Share

Report

Posted on by danielle365

Hi All,

I'm trying to create an app where a user can populate these textboxes and search a Sharepoint list if such record exist. (As long as there are at least 1 identifier).

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi,
Yes you can check this using LookUp function
On select of Validate button
If(IsBlank(LookUp(ListName, Lower(FirstName)=Lower(TextInput1.Text) && Lower(LastName) = Lower(TextInput2.Text) && ContactNumber = TextInput3.Text && Lower(EmailAddress) = Lower(TextInput4.Text)), Set(varMsg, "Record does not exist in Sharepoint"), Set(varMsg, "Record is there in SharePoint"))
Replace TextInput fields with respective datacard values and you can your column names instead of FirstName, LastName, etc

The above is used to check if exact record exists. You can replace && with || if you want to check for any column

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@danielle365

Yes, you can use all the criteria from your text input controls and look up that record.

The formula would be similar to the following:

LookUp(yourList, FirstNameColumn = FirstNameInput.Text && LastNameColumn = LastNameInput.Text && ContactNumber = ContactNumberInput.Text && EmailAddress = EmailInput.Text, true )

You can use this in a Visible property for a label as it is to show that it exists.

Or you can use the formula in a Text property for a label to display the existence or not.

Ex:

$"Record { If(LookUp(yourList, FirstNameColumn = FirstNameInput.Text && LastNameColumn = LastNameInput.Text && ContactNumber = ContactNumberInput.Text && EmailAddress = EmailInput.Text, true ), "exists", "does not exist" )} in SharePoint List"

I hope this is helpful for you.

Was this reply helpful? Yes No