cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaxWendorff
Helper II
Helper II

If Function with Lookup

Hi, I am making an app that scans barcodes and uploads the data to a sharepoint list. Everyday a new pick list is going to be uploaded so only data thats on that list can be scanned. I have a funtion right now that using lookup that references the list and does not display the data if it is not on the list. I want to add an if statement to that funtion so that if the data is not on the list then the app displays an error. My current code is:

 

If(LookUp(Table2_1,Location = BarcodeScanner1.Value), BarcodeScanner1.Value, "Error")

 

I have tried a lot and can not seem to get te syntax down for the IF funtion. 

 

Any Help would be greatly appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions

my bad

 

if you using this one : If(IsBlank(LookUp(Table2_1,Location = BarcodeScanner1.Value, BarcodeScanner1.Value)), "Error")

 

I missed a bracket before ","Error" - try the formula above.

View solution in original post

5 REPLIES 5
myke_deabreu
Resolver III
Resolver III

Try this:

 

If(IsBlank(LookUp(Table2_1,Location = BarcodeScanner1.Value, BarcodeScanner1.Value), "Error")

 

#Basically you checking if the result is blank. if it is show "Error". If your result produces a value like 0 you might want to remove "Isblank" and do something like:

 

If(LookUp(Table2_1,Location = BarcodeScanner1.Value, BarcodeScanner1.Value)=0, "Error")

Thank you so much for your fast response!

 

I tried the funtion and I received this error:

 

"Unexpected charecters, the formula contains 'Paren Close where Eof is expected."

 

Is this just a syntax issue?

my bad

 

if you using this one : If(IsBlank(LookUp(Table2_1,Location = BarcodeScanner1.Value, BarcodeScanner1.Value)), "Error")

 

I missed a bracket before ","Error" - try the formula above.

View solution in original post

Thank you so much!!

Np Max - Glad I could help!

 

Happy Apping

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,615)