web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Powerapp Lookup formul...

Power Apps

Answered

Powerapp Lookup formula is not working when Lookup with Number field ?

(0) Share

Report

Report

Posted on by Vishwa05

17

Hi All,

I have a list name "List1" which has two fields

1. OrderID (Number Type)

2. OrderName (Single Line Text)

I have another list name "List2" which also has two fields

1. GetOrderID (Lookup field) which is Lookup from "List1" column "OrderID"

2. GetOrderName (Single Line)

I have written formula on default property of "GetOrderName (Single Line)". Below is the formula:-

LookUp(List1, OrderID = DataCardValue6.Selected.Value, OrderName) - did not work. then i tried to convert number field into string. below is the formula but it also did not work.

LookUp(List1, Text (OrderID) = DataCardValue6.Selected.Value, OrderName)

Note - If I change OrderID (Number Type) field into Single line then its working fine.

Please help into this.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vishwa05 ,
Try this first
LookUp( List1, OrderID = Value(DataCardValue6.Selected.Value), OrderName )

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.

Join the conversation