News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Retrieving last item i...

Power Automate - Building Flows

Answered

Retrieving last item in excel not working as expected.

(0) Share

Report

Report

Posted on by alexgriffiths

2

Hello,

I am building a flow triggered by the submission of an MS form. The flow creates a new row in an excel table and then some excel formulas work out a score and then the score is emailed to the person who submitted the form.

To get the last row in the excel table I have used the list rows in the present table and ordered them in descending order as shown.

However, when the email comes through it is not picking the score associated with that row it is picking the score based on the previous row.

Any help would be greatly appreciated.

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Retrieving last item in excel not working as expected.

Hi @alexgriffiths,

Do you want to get the last row of your excel table?

I think you could just use the last function to achieve this as below:

last(outputs('List_rows_present_in_a_table')?['body/value'])

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans