Filter last data and send as excel attachment

[TEACH_BUSINESS]

I need to filter data by column and get Maximum value for the same. I’m enter the following code to the excel sheet.

<<Start:Filter
(“Master DB”,
AND(
[Creare Proposal?]=“Y”,
ANY(
TOP(
SORT(Master DB[Timestamp], TRUE)
, 1)
)
)
)

<<_RowNumber>>

Appsheet had encountered following error.

Failed: Action not performed because 2 errors are present. Error: Workflow rule ‘Prep Proposal data’ action 'Pulling proposal data ’ Attachment template. Expression ‘Filter (“Master DB”,AND([Create Proposal?]=“Y”,ANY(TOP(SORT(Master DB[Timestamp],TRUE),1))))’ is invalid due to: Condition AND(([Create Proposal?] = “Y”), ANY(TOP(SORT(MASTER DB[Timestamp],“TRUE”),1))) has an invalid structure: subexpressions must be Yes/No conditions. Error: Workflow rule ‘Prep Proposal data’ action 'Pulling proposal data ’ Attachment template. Start expression ‘Filter (“Master DB”,AND([Create Proposal?]=“Y”,ANY(TOP(SORT(Master DB[Timestamp],TRUE),1))))’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table…

[Steve]

What is this supposed to do?

ANY(
TOP(
SORT(Master DB[Timestamp], TRUE)
, 1)
)

[TEACH_BUSINESS]

I only need the Last one or current one.

[Steve · Accepted solution]

Try:

<<Start: LIST(
  MAXROW(
    “Master DB”,
    "Timestamp",
    [Create Proposal?]
  )
)>>

[TEACH_BUSINESS]

It is help to solve the problem. Thank you