Forum Discussion
Expand columns doesn't work after Merging queries
This might be a long shot, but sometimes the issue is simpler than it looks.
Does any of the columns that you are trying to join have trailing spaces?
Try to trim the columns or transform them using Text.Start and check if this resolves the issue that you're having.
This might be a long shot, but sometimes the issue is simpler than it looks.
Does any of the columns that you are trying to join have trailing spaces?
Try to trim the columns or transform them using Text.Start and check if this resolves the issue that you're having.
I noticed this in my solution. What fixed the issue for me was I was trying to use a dataverse lookup column and filtered down to just the display column. It kept going null at the end of all steps. After having both the column and display column, the value no longer reverted to null.
Hope this helps.