Unanswered

Lookup Record

(0) Share

Report

Posted on by Station1901

209

Hello, I am trying to get a lookup statement to work in my power app however this is proving to be more difficult than I thought.

I have a sharepoint list named 'DriverDetails' which contains a list of our drivers details. I have a text input field in my power app named 'Badge', After the user has entered the badge number into the text input box I need a label to lookup all of the records in my sharepoint list (DriversDetails) and if the 'Badge' value is in the 'BadgeNo' column I need the label to show "Existing" otherwise I need it to stay blank.

I think I may be over thinking this......

Any help would be much appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
Re: Lookup Record

@Station1901

Put this code in the Text property of your label

If(!IsBlank(LookUp(DriverDetails, BadgeNo=Badge.Text)), "Existing", Blank())

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report

Re: Lookup Record

Works perfectly - thankyou

Was this reply helpful? Yes No