Yes, this formula returns the last item that matches a search value:
=IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))), "", ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B)))
This is what I use in the Photo Choice example in https://concepts.glideapp.io/
Here is a simplified version with the conversion from ( , ) to ( ; ) for you:
=ARRAYFORMULA(LOOKUP(2; 1/(FormResponseSheet!A$2:A=A3); FormResponseSheet!B$2:B))
If you are not looking for a specific matching value and want the last record only, then =INDEX(A:A,COUNTA(A:A),1) is an option, but it only works if there are no empty cells in a column. You can still use my first suggestion, if you create a column in your sheet with a value that is the same for all form responses. Then the formula can search for that specific value. =ARRAYFORMULA(LOOKUP(2; 1/(FormResponseSheet!A$2:A=A3); "Search Value"))