question

GarethTerblanche-9138 avatar image
0 Votes"
GarethTerblanche-9138 asked GarethTerblanche-9138 commented

Are there currently Sharepoint and excel connection issues for azure logic apps?

I have two apps that were working yesterday but not day and was wondering if anybody else is having an issue of if anybody knows what more I can do to troubleshoot this issue. Here is the problem for one of the apps:
I have xlsx files in blob storage which I then collected and create a sharepoint file based on a a schedule, I then run a script on the file which only has one sheet.

Here is the script:
function main(workbook: ExcelScript.Workbook) {
let worksheet = workbook.getWorksheet("Worksheet");
// Add a new table at range B1:AV2 on worksheet
let newTable = workbook.addTable(worksheet.getRange("B1:AV2"), true);
// Add a new table at range B4:M6 on worksheet
let newTable_1 = workbook.addTable(worksheet.getRange("B4:M15"), true);

(I previously did not name the worksheet in the script but used active which work but read that you should reference the sheet)


The error that I'm getting is a 404 - with this message
{
"message": "We were unable to run the script. Please try again.\nWorkbook not found.\r\nclientRequestId: 1c60b1cc-a05a-4c66-a28d-0992fb6f01e4",
"logs": []
}

I have tried to get workbooks on the file but get the same error. The file is not corrupt and can be opened in excel and as stated before this step was working yesterday with no changes to it.

azure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarethTerblanche-9138 avatar image
1 Vote"
GarethTerblanche-9138 answered GarethTerblanche-9138 commented

I believe that I have found the issue. I compared the code created by the UI to a working action and noticed that the there was a double encodeURIComponent "{encodeURIComponent(encodeURIComponent" I removed one of them and it works now.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I have also found in a separate post of mine, which could have been the issue here, is that these connectors seem to have gotten case sensitive so be sure to convert .XLSX to .xlsx

0 Votes 0 ·
MichaelHan-MSFT avatar image
0 Votes"
MichaelHan-MSFT answered GarethTerblanche-9138 commented

Hi @GarethTerblanche-9138,

Please make sure that you have a worksheet named with Worksheet in the excel file. Per my knowledge, the default worksheet name should called "Sheet1", you could try use that

 workbook.getWorksheet("Sheet1")



If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks Michael, in this case the Worksheet is called Worksheet and is not the default Sheet1. In addition the error states that the the workbook is not found "nWorkbook not found".

0 Votes 0 ·

I'm also now getting this when I open the runs script connector in the logic app.
Please check your account info and/or permissions and try again. Details: Rate limit is exceeded. Try again in 1 seconds. More diagnostic information: x-ms-client-request-id is 'D50ED267-868C-4FDE-BDAC-C61DCE9AABDF'.

0 Votes 0 ·

113276-workingscript.png113321-nonworkingscript.png




I've compared the script to one that worked to one that is not working and have found that the working version seems to have guids whereas the none working version does not have these. See images attached.

0 Votes 0 ·
workingscript.png (19.4 KiB)
PramodValavala-MSFT avatar image
0 Votes"
PramodValavala-MSFT answered GarethTerblanche-9138 commented

@GarethTerblanche-9138 Based on the screenshot that you've shared, it looks like you are using Custom Values instead of selecting one from the designer UI. While the UI will show display names, the underlying API requires internal IDs which are usually what you see in the Code View of the Logic App. These values are filled by the UI based on your selection.

It would be best to select the appropriate values from the UI instead of typing them in manually.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Pramod, I am not using custom values, only those that are available in the UI. and when I view the code the internal ID's are present.


114492-2021-07-14-09-05-20-logic-apps-designer-microsoft.png


0 Votes 0 ·