web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to insert the last...
Power Automate
Unanswered

How to insert the last row from excel to another excel in sharepoint

(0) ShareShare
ReportReport
Posted on by 26

I have peculiar issue :

                I wanted to get the "Total points" from the Forms response and based on a condition to send all the responses to some mail users. I've did most of the part like how to download the actual excel with all the responses :https://www.youtube.com/watch?v=4eWGdi_C2hQ

     After this comes the tricky part, I want to recreate that excel file into another but in SP document library(which I did), and from that newly created excel file to always take the last row from the Table and add it as a new row to a "final" excel file.  By "final" I mean that I don't want to always search for the last excel file created and do what I want to do afterwards, I want to create the file, copy the information I need into another excel file and then delete it.

owidiuz_0-1661864613326.png

 

Categories:
I have the same question (0)
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @owidiuz  Pls explain me how you are deciding last row? WHat is your criteria?

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • owidiuz Profile Picture
    26 on at

    Hi Hardesh,

      This would be a method, but I was hoping to hear for another if this is not working :

    owidiuz_0-1661922908172.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 291 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 238 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 109 Super User 2026 Season 1

Last 30 days Overall leaderboard