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?

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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