I am having a major issue at the moment with a few logic apps and am unable to find a solution. Here is the scenario:
I have xlsx files in blob storage. I list the files and and then for each create them in a share point folder where I need to list the workbooks in the created file in order to decide which script to use on the file.
This was all working perfectly fine until the 2nd of August when the get workbook connector started failing with the 404 Item not found error. In order to test various things I have created a new app which lists the files in a folder and then attempts to get the workbook but with the same issued although I have found that I get different errors if I use ID versus Identifier i.e.
@items('For_each')?['{Identifier}'] = Item not found
where as
@items('For_each')?['ID'] = The resource could not be found
I have tried using Path, Name etc etc but the only thing that seems to work is if I select the file from the sharepoint directly manually.
