This is just mind boggling.
I have this query, pulling from a Premium SQL connection-
Filter(
'MytableName',
WorkedDate >= DateAdd(
Now(),
-50
) && Location = varLocation && ValidRecord = true
)
When I plug it into a gallery, it returns all the data.
Then I have this query, which is the EXACT SAME, but shoves the results into a collection on a button press:
Collect(colTest, Filter(
'MyTableName',
WorkedDate >= DateAdd(
Now(),
-50
) && Location = varLocation && ValidRecord = true
)
)
The collection version, for some reason, is missing all the numerical data. It has dates, times, locations, etc, but NONE of numbers i should be pulling. The columns exist, but are seen as all blank.
This is extra wild because this works currently in production. I'm coming back to an app that's been working for over a year+ to add some extra features, but I can't adjust anything and push it because this issue seems to be killing my ability to change anything.
As you can see in the attached images, the gallery on the left shows the date and the total i'm looking for, the gallery on the right is the exact same, but i've changed its Items from the raw query to the colTest variable, and it's missing the data. The variable when explored in powerapps, shows ALL the data columns missing (there are more columns than what's shown, but the important part is showing that all the bill data is blank).
Ignoring that powerapps itself already shows this data, i have triple checked and confirmed that the data 100% exists in SQL. Can we suddenly not put sql data in a collection or something?
