If Power Query new files and folders not showing in SharePoint, there can be something off with the permission, cache, or API ...
How-To Geek on MSN
How to use conditional columns in Excel Power Query
Replace broken brackets in Excel with clear, flexible Power Query rules that handle real-world data effortlessly.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results