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.
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
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.
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
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.