web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Check if record exist ...

Power Apps

Unanswered

Check if record exist with multiple criteria

(0) Share

Report

Report

Posted on by danielle365

18

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 Img

All responses (2)

Answers Img

Answers (0)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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

Join the conversation