Getting data from sharepoint folder when have new sheet added which doesn't exist in previous files

[jeongkim]

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'

[christinepayton]

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-- 

[jeongkim]

Hi, 

That's my point that manual selection won't help cuz it requires manual inputs every single time.

Sheet A is in file 1, 2, 3 and Sheet B is newly added and only in file 3. 

If I add Sheet B name in advanced editor then other file 1,2 got error cut they dont have Sheet B.

[christinepayton]

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. 

[jeongkim]

Yeah they have exaxt the same column structures but as we know sometiems people don't want to chnage the template. 

I combin all the sheets in Power query using append but I need to allocate newly added sheet name to get the values,, and this is what I need to combine automatically. 

[amitchandak]

@jeongkim , 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.