Solved: Suggested Values sorted by most recent entries & n... - Page 2

Jonesy · 06-30-2023 03:51 PM

Hi Guys,

I have an app where by multiple products have a traceability code. I would like the suggested values to list the 10 most recent traceability codes of the table Produce Intake 2023 for that product (In this case Baby Spinach). I have a date column in the form also if this can help with an expression.

This is the formula i have currently, my only issue is it is listing based on alphabetical/numerical, and not by the desired date (Newest to oldest).

TOP(
SORT(
SELECT(Produce Intake 2023[Baby Spinach Traceability Code], TRUE),
TRUE
),
10
)

As always, any help greatly appreciated!

Thanks,

J

AleksiAlkio

It depends what do you need to do with the saved value. If the Timestamp is fine, you could select the code column as a label and use Enum column with the base type of Ref. The app will then show your code value, but the Timestamp will be saved to your data source.

View solution in original post

Suggested Values sorted by most recent entries & not by alphabetical/numerical