Unanswered

Named formulas issues : blank result lookup

(1) Share

Report

Posted on by DamienL

In App Forumals, when the lookup function returns no result, the variable does not become blank and main contains the last result that was not blank.

varAppCurrentORT = LookUp(ORTs, sqlID = varAppCurrentORTsqlID);
varAppCurrentPoS = LookUp(PoS, PoSID = varAppCurrentORTPoSID);
varAppCurrentCLLeft = LookUp(CLsDataSLO, SNNumber = varAppCurrentORTCLLeftSN);
varAppCurrentCLRight = LookUp(CLsDataSLO, SNNumber = varAppCurrentORTCLRightSN);
varAppCurrentCLLeftPrec = LookUp(CLsDataSLO, SNNumber = varAppCurrentORTCLLeftPrecSN);
varAppCurrentCLRightPrec = LookUp(CLsDataSLO, SNNumber = varAppCurrentORTCLRightPrecSN);
varAppCurrentPatient = LookUp(Patient, PatientID = varAppCurrentORTPatientID);

I've tried this formula, but the variable doesn't become blank and still contains the last non-blank result

varAppCurrentComments = If(varAppCurrentORTCommentsID>0, LookUp(ORT_Comments, sqlID = varAppCurrentORTCommentsID), Blank());

To test the behaviour I tried forcing the IDs to -1, which should return blank results, without success...

Do you know how to fix this bug? Should I stop using named formulas?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DamienL ,

Where do you put this code?
If you want to update variable, I think you should use the Set or Update function and put the code on a behavioral property like OnSelect.
Please try this:
OnSelect of a button: Set(varAppCurrentComments,If(varAppCurrentORTCommentsID>0, LookUp(ORT_Comments, sqlID = varAppCurrentORTCommentsID), Blank()))

Best regards,
Rimmon

Was this reply helpful? Yes No
DamienL 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft

I put this code in Formulas from App because these variables are used from several screens in the application and are therefore always up to date, no matter how the id changes.

Thanks for your help
Damien

Was this reply helpful? Yes No
DamienL 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft ,

Do you have any ideas about the source of the problem?

I think this bug is recent because our application has been in production for a year and given the major consequences of this bug on our application, the problem would have been reported to me much earlier...

Was this reply helpful? Yes No
Hong Xian Zheng 16 on at

Like (1)

Report
Copy link

Link copied!

Hello, just want to share that we also experienced this problem and have reported it to Microsoft. This is definitely a bug...

The problem started when publishing version changed from 3.23105.xx to 3.23113.xx

Blank lookups in Named Formulas were working fine before this. Last week we could still rollback the publishing version as a temporary fix. But now we are unable to do so as 3.23105 is no longer available.

Was this reply helpful? Yes No
DamienL 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply @HongXianZheng I feel less alone!

@v-mengmli-msft Is Microsoft planning to fix this bug quickly? The impact is considerable for us, as the application manages orders that send false information to production machines...

Was this reply helpful? Yes No
Hong Xian Zheng 16 on at

Like (0)

Report
Copy link

Link copied!

Hello @DamienL ,
Just to update this issue has been resolved for me in publishing version 3.24 (This was released to my region somewhere in early-mid Jan this year)

Was this reply helpful? Yes No