I am trying to create an automation that will use the information on a Qlik table and save it as excel file on a SharePoint shared site.
So I used a block 'List Drives From Site' to get the list of all the drives on the site. Then I use block
'List Items On Drive By Site' to connect to specific drive id .
Then I use the block 'Create Binary File (Sharepoint Site)' but there is a requirements to select Parent id and the parentReference id is aways the same does not matter what drive id I choose and therefore it creates the file on the default document library instead of the one I have selected.
Any thought how to fix that and if there is any other approach I should take?
