Automate Transformtation of Sharepoint Excel-File to pdf-File

[olenedderhoff]

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

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?

[Anil_Babu_Samineni · Accepted solution]

@olenedderhoff If you need just Excel to PDF, Why you need Qlik sense rather you can try externally right. How to Create PDF from Excel using Power Automate - Enjoy SharePoint