cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_G
Helper I
Helper I

View data from a list with Sharepoint Lookup Fields in Powerapps Gallery

Hello,
I have two lists in Sharepoint:
LicBr_01
LicBr_02

 

The two lists have different fields, but there is a related field between both lists with the name "LEGAJO". The field is unique and does not repeat itself, it does the function of an ID.

 

Imagen02.jpg
In the LicBr_02 List, the "LEGAJO" field is of the "Lookup" type and brings information about 7 other fields of the LicBr_01 list.

 

Imagen04.jpg

 

When creating a gallery in powerapps, the information in these fields that are of type number or date in the LicBr_01 list, shows the numbers with many decimals and the dates with the time and other strange data.

 

Imagen01.jpgImagen03.jpg

I hope you can help me.

1 ACCEPTED SOLUTION

Accepted Solutions
SteveYao
Community Support
Community Support

Seems the data are all correct, just the format to display not match?

View solution in original post

4 REPLIES 4
SteveYao
Community Support
Community Support

Seems the data are all correct, just the format to display not match?

View solution in original post

It is correct, I was reviewing other posts and managed to get something for fields with numbers:

Set the DefaultSelectedItems property of the LookUp field (CurrencyLookUp) ComboBox to following:

{
    Id: LookUp('Referenced List', ReferencedNumberField = Value(ThisItem.LegalID.Value), ID),
    Value: Text(Value(ThisItem.LegalID.Value), "[$-en-US]##,###,###")
}
  • But I have no way to apply it to the date field

 

More reference, link here:

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-remove-decimal-in-lookup-field-in-Pow...

 

@SteveYao 

Please Steve, 

 

I tried use this option, but i have error....

 

{
Id: LookUp(LicBr_01, Apertura = Value(ThisItem.Legajo.Value), ID),
Value: Text(Value(ThisItem.'Legajo:Apertura'.Value), "[$-en-US]dd/mm/yyyy")
}

SteveYao
Community Support
Community Support

Hi Rob

What's your error on the UI?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,935)