I don’t think it’s a silly question, I just don’t think there is a great solution out there yet (that I’ve seen at least). If you hunt around the forum there are similar questions that have been asked, and the solutions seem to be either (a) try the Web Request node, (b) try the DynaWeb package, or (c) sync the data from SharePoint to a local location (perhaps via OneDirve) so that it can be handled normally.
And regarding this…
The solution I’ve seen is to try a repair on the Office install or reinstall entirely. I had the same problem and reinstalling was the only fix.