Forum Discussion
Getting data from sharepoint folder when have new sheet added which doesn't exist in previous files
Hi,
I have monthly files and fetching data from shrepoint folder assigning particular sheet name in query.
The issues is, it used to have e.g. sheet name '2024 5G PO' until last month but from this month file("CT SK_5G Bottom up plan_20240308update_v1.0.xlsx"), it has new sheet '2025 5G PO'.
So it can't be found from original First File of 'Sample File'.
If I forcely filter descending order to get '2025 5G PO' sheet from the latest file "CT SK_5G Bottom up plan_20240308update_v1.0.xlsx" cuz we need to? choose First File as a sample, then got error like below cuz it is not in previous excel files.
'Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The key didn't match'
5 Replies
Anonymous , you need to check all these steps. There are chances the column names are also changed. So you need check rename, datatype change steps for column names.
The folder query creates a folder full of helper objects - one of those objects also has a reference to the source that you'll want to update. If you click through them all and look at the advanced editor or first step you should find it in there somewhere--
Do they have the same column structure? Usually if you're working with multiple tables you want to combine, it's better to put them in separate files and then use the folder connector to combine the files. Not sure if that's an option for you, but if you're, say, adding a tab each month right now you'd instead just drop another file in the folder and it'd auto-grab it when it refreshes.
