News and Announcements icon

Power Platform CommunityForums Power Automate - Power Automate Mobile App Delete the last row on...

Power Automate - Power Automate Mobile App

Answered

Delete the last row on SP list

Like (0) Share

Report

Report

Posted on 18 Aug 2020 23:48:24 by John_alcan

22

Hi,

I want to delete the last row on SP list.

Is it possible?

Thanks

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Mrmus 11 on 19 Aug 2020 at 12:56:10

Like (1)

Report

Re: Delete the last row on SP list

you can use length property to get length.
i.e length(body('Get_Item')).
this will give length and after we need to minus by -1 form length to get item
i.e item(body('Get_Item')['Value'][length(body('Get_Item'))-1]
Verified answer

manuelstgomes 6,625 on 19 Aug 2020 at 09:44:24

Like (1)

Report
Re: Delete the last row on SP list

HI @John_alcan

There are two ways to do this:

1. If the last is based on something you can sort, then you can use the Order By and then limit to just one record. Then delete it.

2. If not, you can fetch the items and have a condition that checks if the current item is the last one. To do this, define a variable and increment it each time the Loop runs. In each compare, if the variable is lower than the length. If it is continue, if not delete.

length(outputs('Get_items')?['body/value'])

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans