Unanswered

Formula - Lookup with number field is not working when number contain dot (.) ?

(0) Share

Report

Posted on by vishwajitkumar

Hi All,

I have a list Called "A" which I have customized in power app form. I have a lookup field which is lookup with a Number field of list "B". On selection on lookup field's value I am fetching the value of other filed of list "B" and its perfectly working fine for me. because for me, lookup field which is lookup with the number is showing to me with comma (ex-8,212) but for other country its showing with dot (ex- 8.212) and it is not working for them. below is the formula:-

LookUp('Control Master Data', ControlNumber = Value(DataCardValue38.Selected.Value), ControlName)

Control Master Data - is List B

ControlNumber - is number field in list B

ControlName - is text field in list B which I am fetching on selection.

for me in lookup field number is showing with comma and working and for them its showing with dot and not working.

Please help.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @vishwajitkumar

Consider fixing the language format Text(Value(DataCardValue38.Selected.Value),"##.##","en-US")

some reference on global-apps : https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text#global-apps

hope it helps

Was this reply helpful? Yes No
aaaaaaaaaaa 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Rubin,
Thank you so much for your reply. But where to pass column name which I want to fetch?
LookUp('Control Master Data', ControlNumber = Text(Value(DataCardValue38.Selected.Value),"##.##","en-US"), ControlName)
I want to fetch "ControlName" field value.

Thanks,
Vishwajit

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi there @aaaaaaaaaaa you can pass it to a variable. Set(_ControlName, LookUp('Control Master Data', ControlNumber = Text(Value(DataCardValue38.Selected.Value),"##.##","en-US"), ControlName))

Hope it helps

Was this reply helpful? Yes No
aaaaaaaaaaa 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your reply but here there is no "Set" function. Below is the exact formula I am using
LookUp('Profit centers', 'Profit Center ID'= Text(Value(DataCardValue17.Selected.Value),"[$-en-US]##.##","en-US"),'Profit Center Name')
but getting error:- Powerapp encountered internal error data type text.

Was this reply helpful? Yes No