Answered

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

(0) Share

Report

Posted on by Rob_G

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.

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.

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.

I hope you can help me.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

SteveYao on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rob_G 55 on at

Like (0)

Report
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-PowerApp-Edit-amp/m-p/532973#M163552

Was this reply helpful? Yes No
Rob_G 55 on at

Like (0)

Report

@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")
}

Was this reply helpful? Yes No
SteveYao on at

Like (0)

Report

Hi Rob

What's your error on the UI?

Was this reply helpful? Yes No