Forum Discussion
Renaming columns in PQ : We expected a RenameOperations value
Fair enough, looks fine.
The only thing I can think that might cause this particular error would be if your list pairs were not all being formed correctly, i.e. if one of the pair values evaluated to null/integer/special character somehow.
Have you tried clicking on every one of your nested lists in your Navigation step to ensure that each one includes two valid values?
Another issue sometimes occurs when you have more pair values in your lists than columns in the table (or the old names don't match), but I don't think that would throw this error.
Pete
I was getting this error as long as my renames list contained null within some of the pairs, e.g. {"oldNameX",null}. As this was a consequence of List.Zipping two lists of uneqal lenghts, the solution was to trim the lists to same size. After, the error was gone - even though the renames list was in fact shorter than the count of columns to be renamed. The rest simply stayed unrenamed, without any error.