SharePoint 365 Connector to load multiple files at once

[Jord23Henk]

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! ! ! ! !

[Ricieridm]

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