SharePoint 365 Connector to load multiple files at once

Jord23Henk — Mon, 18 Nov 2024 12:55:30 GMT

Hi,

in the regular path from folders I can write in the code * to load all similar files (for this example, to load Targets_2020, Targets_2021, Targets_2022, etc..)

FROM [lib://1_Resources_PROD\Sales\Budget\Targets_20*.xlsx] (ooxml, embedded labels, table is XXX);

in the SharePoint 365 the * is not working. how do I load multiple excels at once to the code?

Thanks! ! ! ! !

Re: SharePoint 365 Connector to load multiple files at once

Ricieridm — Mon, 18 Nov 2024 13:29:29 GMT

Hello,

You can use:

For Each vFile in Filelist('lib://AAA/BBB/')
If WildMatch('$(vFile)','*Targets*.qvd') then
LOAD
*
FROM [$(vFile)](qvd);
End If
Next

topic Re: SharePoint 365 Connector to load multiple files at once in Integration, Extension & APIs

SharePoint 365 Connector to load multiple files at once

Re: SharePoint 365 Connector to load multiple files at once