Lookup Inside If Statement inside Patch Function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I maybe about to lose my mind so hopefully you can help me.

I was trying to write a dynamic form. The information was placed in a collection that looks like this:

I was trying to pass data into a dataverse table using a patch function and building it piece by piece.

Initially I wrote the following:

LookUp(colFinal,crfa1_name="Machine Number").Data

This returns "G4-33" as expected.

I nested this in an IF statement, which returned an unexpected false value.

IF(LookUp(colFinal,crfa1_name="Machine Number").Data="G4-33","Yes","No")

This returns "NO" for some reason.

I have no idea what I am doing wrong within the If statement that would cause it to return a negative given that the Lookup returns the same text as the comparison?

What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 155,565 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You are correct in your confusion (you should be based on your posted content). If your data looks like this

then you certainly should get a "Yes" response unless there is another record with the crfa_1_name as 'Machine Number' with a different value in the Data field.

Try this (another "degree of separation"), but your original code certainly should work.

With( { wData: LookUp( colFinal, crfa1_name = "Machine Number" ).Data }, If( wData = "G4-33", "Yes", "No" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I appreicate the resposne, but alas, it didn't work... and I am even more confused.

So the lookup statement in the above still returned "G4-33" as expected. Even then the If statement returned "NO" rather than "Yes".

Not sure where to go with this, it looks like it should be simple...

Was this reply helpful? Yes No
WarrenBelz 155,565 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous ,

Sorry, lost me as well - this is a bit left-field (and really something I avoid), but for debugging, put this on a Label

LookUp( colFinal, crfa1_name = "Machine Number" ).Data

then your Text

If( YourLabelName.Text = "G4-33", "Yes", "No" )

Was this reply helpful? Yes No