Unanswered

Date Sorting Issue

(0) Share

Report

Posted on by WAstarita

I'm trying to use Sort and / or SortbyColumn to sort a gallery coming from a SQL backend. Very strange. When I sort by the date column, I cannot show that columns value in any text box, it comes up blank. I can show other date fields from the row though. Any ideas?

(Update)

Its very strange behavior, as long as I am doing a sort by the column I cannot access that date column. Even if I do a lookup in a text box on a gallery item it will not return anything

LookUp('[dbo].[CAL]', recid = "CQ7V4JJ$IN#VDKA", ONDATE)*
*(Recid is the unique key field, I tried both recid = thisitem.recid and the literal example above).

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WAstarita,

How did you configure the Sort/SortByColumns function?
According to your description, the function worked and can show other date fields from the row, how were these date fields created? Were these fields similar with the date column that cannot show value in TextBox?

Articles below could be a reference for you:
1.Sort and SortByColumns function in PowerApps
https://powerapps.microsoft.com/en-us/tutorials/function-sort/
2. Filter, Search, and LookUp functions in PowerApps
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/
3.”Search and sort the gallery” section in this article about Understanding data forms in Microsoft PowerApps
https://powerapps.microsoft.com/en-us/tutorials/working-with-forms/

Best regards,
Mabel Mao
rgruian Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried specifying Ascending or Descending? This should help ensure that you are not unknowingly seeing rows that really do have those fields blank.

Also, how are you making use of those fields? Have you tried piping their value(s) into Textboxes using the Text function in conjunction with a specific format? For example:

= Text(ONDATE, "mm/dd/yyyy hh:mm:ss a/p")

Also, how large is your data source? If there are lots of rows, you may be running into the 500-row limitation in PowerApps, whereby most of the queries are performed locally on a local cache of the data that is capped to 500 rows. And in that case, the local LookUp() operation, for example, may not find anything in that 500-row cache, which would explain why you get a blank result.