Forum Discussion

Copper Contributor

Nov 11, 2025

MS Forms If function ignoring new data

Hello, I have a MS form setup collating information, I need to then reformat how this data comes in so it can be copied directly into another bit of software. Currently we have sheet 1 as below whic...

excel

Formulas and Functions

simonbeaumont

Copper Contributor

Nov 12, 2025

I have had a look at Power query but don't understand it. If i go to Get Data..From Table/Range, and then select the source data I get an error that tables cant overlap.

Can I ask regarding editing the source table. For example, if i moved some of the columns into different positions, or inserted new columns where we added other data, would the MS form still map to these moves?

SergeiBaklan

Diamond Contributor

Nov 12, 2025

With Power Query - stay on source table, Data -> From table/Range -> Transform -> do something if necessary -> File -> Close & Load

-> select destinattion

Source table editing. Nope, you have to keep columns as they are, without renaming them or changing position. However, you may add new columns.

I'm not 100% sure you can't change columns position, Microsoft changed sync process dramatically during last year. Perhaps it's enough to keep names. Better to test, it won't take a lot of time.