web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Formato campo Lookup e...

Power Apps

Answered

Formato campo Lookup en combobox

(0) Share

Report

Report

Posted on by antonella laura sba...

26

Hola, alguien puede ayudarme con lo siguiente: Estoy trabajando con dos listas, en una tengo un lookup a la otra, pero en el combobox en lugar de mostrarme numero de pedido 1, 2,3; me muestra 1.00000000, 2.0000000. Comparto una imagen, alguien me puede ayudar?

Sin título.png

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anto_Sbar ,

I assume that the OrderNo field is a LookUp type field in your SP List, which references values from the OrderNumber in your ' List2'. Please add your 'List2' as data source into your canvas app firstly.

please select the Combo Box Control and apply the following formula on its DefaultSelectedItems property as:
{ Id: LookUp(List2, OrderNumber = Value(ThisItem.OrderNo.Value), ID), Value: Text(Value(ThisItem.OrderNo.Value), "[$-en-US]##,###,###") }
Here are some links that might help you:
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-remove-decimal-in-lookup-field-in-PowerApp-Edit-amp/td-p/531852
https://powerusers.microsoft.com/t5/Building-Power-Apps/Lookup-combo-box-field-too-many-decimals/td-p/890931

Best Regards,
Charlie Choi
antonella laura sba... 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Gracias!!!

Join the conversation