app formula i have the following formula “(select(milk recording[SCC],and([Animal Number]=[_THISROW].[Animal Number],[date]<=[_THISROW].[date])))”
in the data validity i have this formula: “orderby(select(milk recording[MR Animal id],and([Animal Number]=[_THISROW].[Animal Number],[date]<=[_THISROW].[date])),“Date”,true)” where [MR Animal id] is the key for the dataset
The Valid_If expressions only impact the order of dropdown lists used to choose values - they have no effect on the actual chosen values.
You have the expression in the App Formula property. I am not sure why you don’t think you can apply the ORDERBY() function there. Since you are assigning values to the SCC List column by an App Formula, there is no need for a VAlid_If expression. Simply MOVE the expression you have in your Valid_If into the App Formula.
PRO TIP: If the SCC List column is simply showing the values identified in the “Related Milk Recordings” list then you can simplify your expression for the SCC List values column as follows:
ORDERBY([Related Milk Recordings], [Date], true)
This assumes that you have the SCC column set as the Label column in your Milk Recordings table. If for some reason you do not then you will need to use your SELECT() expression.
SCC is not the label so i cant use your solution above, i now have a list in the right order but it is not showing the SCC how do it get it to return the SCC column?
