Only email the most recent entry

[ae_daniel]

I have a simple data entry log to track donations to our shelter, it has a workflow that sends an email with a donation receipt that is auto populated in a PDF with their information. Their Email is part of the form, but I can’t figure out how to only select the most recent row entry in the email column to send the receipt to. Is it something I would put in the equation in the workflow? or would I have to isolate that email in another table temporarily?

[ae_daniel]

• right now it emails EVERY email in the column

[LeventK]

Is this an ADDS_ONLY/ADDS_AND_UPDATES_ONLY workflow or a scheduled report?

[ae_daniel]

Adds only.

[Steve · Accepted solution]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

[ae_daniel]

I’ll try that here in a minute, last night I had tried something with “MAX” and it kept telling me it was returning a number value not an email value or that the “MAX” function was being used incorrectly. But I will give it another try.

[ae_daniel]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), and SELECT()

LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want.

AHHHH IT WORKED lol thank you so much ❤️