Power Platform Community Forum Thread Details

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 :)

Categories:

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