Hi,
I'm having an issue with Excel (2016) is connected to a SharePoint (2013) list using Get & Transform; I'm using the imported data to populate columns in a field via Index(Match()) formulas Table[Field] type references.
The issue I'm having is that modifying the underlying SharePoint List fields (either adding or changing order) is subsequently modifying the order of the columns in the imported Excel table; this is in turn, breaks the Table[Field] references in my Index(Match()) formulas requiring me to edit them all.
Why is this happening?
Is there some option in the Get & Transform process I can mod to prevent the Excel Table being altered i.e. new fields are place at the right side of the table when imported?
Obviously, freezing the design of the SP list would remove the issue, but in reality, this is unlikely to happen.
Appreciate any help, thanks.
I'm having an issue with Excel (2016) is connected to a SharePoint (2013) list using Get & Transform; I'm using the imported data to populate columns in a field via Index(Match()) formulas Table[Field] type references.
The issue I'm having is that modifying the underlying SharePoint List fields (either adding or changing order) is subsequently modifying the order of the columns in the imported Excel table; this is in turn, breaks the Table[Field] references in my Index(Match()) formulas requiring me to edit them all.
Why is this happening?
Is there some option in the Get & Transform process I can mod to prevent the Excel Table being altered i.e. new fields are place at the right side of the table when imported?
Obviously, freezing the design of the SP list would remove the issue, but in reality, this is unlikely to happen.
Appreciate any help, thanks.
