How to dynamically 1) remove deleted columns 2) add new columns and 3) update renamed columns?

Question

I'm pretty unfamiliar with power query/M code, so trying my best here.&nbsp;I've found videos that cover how to dynamically remove/add columns in power query. And I've also found videos that show how to dynamically update renamed columns. But is there a way that covers all three options in the M code? Or would I just add in all three options? If so, is there a particular order they need to go in?&nbsp;We want to give users the ability to delete/add columns and rename existing ones without it breaking the refresh. I was trying to see if there's a way to add it dynamically so I don't have to manually make the changes in the code each time.&nbsp;&nbsp;Thank you!

ams1 · Answer

Hi,&nbsp;Given that this is a vibrant community (questions usually get answers quick), imo I think it's safe to say that questions that don't get a quick reply need more details/clarifications.&nbsp;So "dynamically removing, adding, updating columns" is a SOLUTION, but at least I don't understand the PROBLEM -&gt; https://xyproblem.info/&nbsp;True, often revealing the PROBLEM/more details without exposing confidential things is not so easy, but I think we cannot help without more details (ex. the error that "breaks" the query etc.)&nbsp;Shooting in the dark here:&nbsp; IF the refresh breaks when columns are added, removed or updated, one reason for this might be that the column names are hardcoded in the query - right?&nbsp;

lava_ · Answer

Sorry for not providing more details about what the actual problem is. I'm unfamiliar with power query and I'm confused about how to implement possible solutions I've found on youtube.&nbsp;To answer your question, yes, the column names are hardcoded, and I am trying to figure out a way to make them dynamic so the refresh doesn't break. However, the solutions I've found cover the different scenarios (removing, adding, renaming columns) separately. So I'm not sure if I should implement them separately or if there is one solution out there that covers all three scenarios.&nbsp;I hope that provides a little more clarity. Maybe I just need to spend more time learning about power query.&nbsp;

Forum Discussion

Related content

Dynamic Column headers

Dynamic Column Name

column deleted but column exists

Dynamic Variable in Calculated Columns

Dynamic column comparison of last column