Answered

Number Input Object will not return a stable value from Lookup

(0) Share

Report

Posted on by CU14112135-0

I have two fields in the same data card object in a Canvas app and one works and the other never works, even though they are identical formulas (except the conversion to number)

Text Input field: Value formula =

       LookUp( 'WL.WorkOrdersDtl1', Work_Order_Nbr = varItem.Work_Order_Nbr, Confirmed_Count )   //This SUCKS
Number Input field:  Value formula = 
Value( LookUp( 'WL.WorkOrdersDtl1', Work_Order_Nbr = varItem.Work_Order_Nbr, Confirmed_Count ) ) //This SUCKS
 
The Number Input field never works and the Text Input works every time.  - BTW: I tried moving the Value conversion to the confirmed count, within the lookup but that didn't work either.  FYI: I have the same lookup formula in about 20 other fields on this screen, each pulls a single data element and everyone the same lookup based on Work_Order_Nbr, just returning a different field from the record found.
 
Could PowerApps be so lame that I need to build a hidden text field to execute the Lookup function and then copy the result to Number Input field? Please tell me that PowerApps is not this horrible!!!
 
Still not resolved

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CU14112135-0

Assuming the first one works, try
Value( LookUp( 'WL.WorkOrdersDtl1', Work_Order_Nbr = varItem.Work_Order_Nbr ).Confirmed_Count )

Also what exactly is 'WL.WorkOrdersDtl1'

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CU14112135-0 22 on at

Like (0)

Report
Copy link

Link copied!

The sugguestion on this post does not work. I have not received a resolution to this issue. I'm 90% sure that this is a bug in PowerApps on the new control. The formula on text works perfectly, but the formula does not work on the number control.

Was this reply helpful? Yes No