https://community.qlik.com/t5/Qlik-Automate/Automate-Transformtation-of-Sharepoint-Excel-File-to-pdf-File/m-p/2415496#M3105 <P>I have new excel files in a SharePoint folder that I want to turn into pdf documents weekly. I found multiple solutions for this problem in this forum, however none of them seem to be working, due to the structure of my Sharepoint Folder. For the necessary "Get File Download Url" I need a drive Id and an Item Id. I tried to get there in a loop of List Sites and List Drives From Site, however the folder of my files is not at the top of any of my sites, but deeper down in the folder structure: rootsite/shared documents/my folder</P> <P>Is there another way to access the drive id of my folder and loop through every item in this folder and turn it into a pdf?</P> Fri, 15 Nov 2024 21:07:13 GMT olenedderhoff 2024-11-15T21:07:13Z https://community.qlik.com/t5/Qlik-Automate/Automate-Transformtation-of-Sharepoint-Excel-File-to-pdf-File/m-p/2415496#M3105 <P>I have new excel files in a SharePoint folder that I want to turn into pdf documents weekly. I found multiple solutions for this problem in this forum, however none of them seem to be working, due to the structure of my Sharepoint Folder. For the necessary "Get File Download Url" I need a drive Id and an Item Id. I tried to get there in a loop of List Sites and List Drives From Site, however the folder of my files is not at the top of any of my sites, but deeper down in the folder structure: rootsite/shared documents/my folder</P> <P>Is there another way to access the drive id of my folder and loop through every item in this folder and turn it into a pdf?</P> Fri, 15 Nov 2024 21:07:13 GMT https://community.qlik.com/t5/Qlik-Automate/Automate-Transformtation-of-Sharepoint-Excel-File-to-pdf-File/m-p/2415496#M3105 olenedderhoff 2024-11-15T21:07:13Z https://community.qlik.com/t5/Qlik-Automate/Automate-Transformtation-of-Sharepoint-Excel-File-to-pdf-File/m-p/2415792#M3108 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/260184">@olenedderhoff</a>&nbsp;If you need just Excel to PDF, Why you need Qlik sense rather you can try externally right.&nbsp;<A href="https://www.enjoysharepoint.com/create-pdf-from-excel-using-power-automate/" target="_blank">How to Create PDF from Excel using Power Automate - Enjoy SharePoint</A></P> Wed, 07 Feb 2024 07:21:45 GMT https://community.qlik.com/t5/Qlik-Automate/Automate-Transformtation-of-Sharepoint-Excel-File-to-pdf-File/m-p/2415792#M3108 Anil_Babu_Samineni 2024-02-07T07:21:45Z