idea Connector Sharepoint based on name not uniqueld in Suggest an Idea

Connector Sharepoint based on name not uniqueld

RV2 — Thu, 25 Nov 2021 16:37:04 GMT

It would be interesting to retrieve a file name instead of the uniqueld in Sharepoint. I have file that I receive on a weekly basis (same format and same name) that I upload for our Qlik dashboard. If I drop the file under sharepoint uniqueld is changing, not the file name.

Re: Connector Sharepoint based on name not uniqueld

chrisbrain — Fri, 07 Jan 2022 09:53:19 GMT

@RV2 I think this might be possible already by using the list files table to first find the ID based on the file name, will just require a bit of scripting.

Re: Connector Sharepoint based on name not uniqueld

RV2 — Mon, 10 Jan 2022 13:47:05 GMT

Thank you @chrisbrain I will explore this solution !

Re: Connector Sharepoint based on name not uniqueld - Status changed to: Closed - Already Available

Meghann_MacDonald — Tue, 26 Sep 2023 18:58:06 GMT

This is available already. You can use the sharepoint metadata connector to get listFILES, add filename as a variable, then load FROM sharepoint.com/sldfkajlsdf/(vfile);