Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Extracting Data From a File Received via Email and Appending File on SharePoint

(0) ShareShare
ReportReport
Posted on by
Hello - I'm trying to build a flow that takes the data received in (.xlsx format) from a weekly automated email and appends an existing Excel file to the next available blank row (which has multiple sheets, but only the current FY sheet needs to be appended), that is saved on our SharePoint. I've looked at multiple actions, but none seem to give me the ability to select the specific sheet that needs appending (I want to stress that I do not want to delete any existing data on my SharePoint file, just add the new data to it). I'd prefer not to create a separate file for the current FY as this would require modifications at the close of each FY, but if that's the way I need to proceed, so be it.

Thank you in advance for your time 
  • Suggested answer
    NickWarner Profile Picture
    NickWarner 113 on at
    Extracting Data From a File Received via Email and Appending File on SharePoint
    The excel actions typically depend on a table reference to manipulate rows. you can create a table specifying the range but I don't think this can be achieved dynamically in PA. In a similar use case I fixed it to 1000 rows as that file would never be that long. you would need to save the file to SharePoint or OneDrive to modify it to have a table so you can then iterate through the rows, adding the info to your existing Excel (which also needs a table defined). You would run these actions after saving the file to your OneDrive or SharePoint location from the email.
     
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard