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