Forum Discussion
gancw1
Resolver II
Resolver IILoad Excel file attachment directly from SharePoint online lists
I am trying to do this by extracting the attachment URLs and calling Web.Contents( ) to extract the Excel tables. However PQ does not allow multiple calls to the same API - in this case an API call ...
I managed to overcome the error by using SharePoint.Contents( ) to directly access all the attachments in the list
I can now expand the Attachments table and then use Excel.Workbook( ) to read in the Excel content from all the attachments.
gancw1Resolver II
Resolver III managed to overcome the error by using SharePoint.Contents( ) to directly access all the attachments in the list
I can now expand the Attachments table and then use Excel.Workbook( ) to read in the Excel content from all the attachments.