Forum Discussion
PowerQuery not reflecting changes to filenames in Sharepoint Library
Hi All. I've got a simple SPO library with files that I need to query within Excel via PowerQuery, I'm using the Query Type SharePoint List rather than SharePoint Folder because I need other metadat...
See whether below can help:
- Check SharePoint Metadata Refresh:
Try manually refreshing the query and ensuring metadata updates are enabled.
- Use SharePoint Folder Instead:
While you prefer SharePoint List for metadata, switching to SharePoint Folder might help capture filename changes more reliably.
- Modify Query Steps:
Ensure filename not locking in old names. Try adding a step to dynamically pull the latest filenames.
Thanks for responding... on the points..
- I've recreated simple queries from scratch, in new spreadsheets..
- Sharepoint Folder is better, HOWEVER, there is nothing in the Folder query that means I can connect the data to the Sharepoint List query, i.e. it doesn't return any other metadata, namely ID would help!!
- Can you explain this more please?