Forum Discussion
Getting data from sharepoint folder when have new sheet added which doesn't exist in previous files
Most Valuable ProfessionalThe 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--
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.
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.