Power Platform Community Forum Thread Details

Hi, everyone

I've been having problems when I charge data from a SQL Server table inside a Gallery, the issue is that the Gallery has problems to show one of the columns. It's showing a different value.

I have a SQL Server like this:

LoadingFiles (idFile [int], name varchar[4] ..... CDRV numeric (18,0)).

So I've transfered the data from "LoadingFiles" into a Collection named "colLoadFiles", but when I put the collection in the Gallery's Datasource the CDRV value which was correct in the collection is different from the showed value in the gallery.

I mean, if in the datatable I have a CDRV value like this: 4235423575762727000 then in "colLoadFiles" I have the same value "4235423575762727000" but when I use "ThisItem.CDRV" the gallery shows the altered/corrupted value like this "423542357576272000" (the last 7 in the ending part ...727000 has dissapeared).

I think it could be a problem related to Overflow because the number is too big, but I don´t know how to solve it.

Categories:

Building Power Apps