Hello, I am using Excel Power Query.
I have PowerAutomate process that inserts new rows into a Master Spreadsheet.
In that spreadsheet, I'm using Power Query to transform the table from the newly insert spreadsheet into a separate output table.
The output table needs to be edited by users in addition to there being 2 new columns.
When users change a value in a cell on the output spreadsheet, if the data refreshes, their manually inputted work is deleted and reverts back to what the source spreadsheet had.
The Source spreadsheet CANNOT be modified by users for various reasons. One of them being is in the output spreadsheet is an automatic add column function based on various conditions.
The output spreadsheet is where staff is required to input new data into new columns in addition to changing values on existing rows where columns already exist in the source spreadsheet.
That data needs to stick on refresh. I'm stumped on a solution to this problem.
I have PowerAutomate process that inserts new rows into a Master Spreadsheet.
In that spreadsheet, I'm using Power Query to transform the table from the newly insert spreadsheet into a separate output table.
The output table needs to be edited by users in addition to there being 2 new columns.
When users change a value in a cell on the output spreadsheet, if the data refreshes, their manually inputted work is deleted and reverts back to what the source spreadsheet had.
The Source spreadsheet CANNOT be modified by users for various reasons. One of them being is in the output spreadsheet is an automatic add column function based on various conditions.
The output spreadsheet is where staff is required to input new data into new columns in addition to changing values on existing rows where columns already exist in the source spreadsheet.
That data needs to stick on refresh. I'm stumped on a solution to this problem.