Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.