Skip to main content

Notifications

Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Announcing Forum Attachment Improvements!
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / When a Excel file is r...
Power Automate - Building Flows
Unanswered

When a Excel file is refreshed via power query. Add new rows and update any changed rows

(0) ShareShare
ReportReport
Posted on by bB-27090143-0 47
HI All
 
I am working off 2 excel sheets on Sharepoint.
 
File 1.xlsx has a table from a power query that refreshes. 
 
When this refreshes. I want to add any new rows and using the id refresh any of the data relating to that id that has changed
 
The excel sheet called Test.xlsx. this file has several worksheets so need to put onto Tab Sales
 
Can someone give me the steps to action this as I am getting lost in whether I need to Get worksheets, get tables - argh.
 
Thanks for any assistance :)
 
ID Date Person Sales Wages
         
         
 
Categories:
Business Process Flows

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

News and Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Announcing Forum Attachment Improvements!

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,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans