Unanswered

Excel reading issue in Pentaho workflow

(0) Share

Report

Posted on by jurunas2023

102

I have a workflow that works perfectly, saving an Excel file to a SharePoint folder. However, my colleague who works with ETL, using Pentaho, is unable to read the file and encounters an error. Strangely, when he enters the folder, opens the Excel file, closes it, and then runs the script in Pentaho, it works. Does anyone know what could be added to the Power Automate workflow so that he doesn't have to always go to the folder, open and close the file for it to run in Pentaho?

Flow

Pentaho Problem

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report

Re: Excel reading issue in Pentaho workflow

Dear J,
I do not know Pentaho and my Spanish/Portugese/... is not any good, but I believe I do see you are using the flow to create a new file.
Just a thought ... do you leave some delay between creating the new file and trying to read it with Pentaho? Sharepoint usually needs some time to 'settle' on new file. Try a few minutes later and see if you have the same results.

Hope this helps,
Happy flowing,
Koen

Was this reply helpful? Yes No
jurunas2023 102 on at

Like (0)

Report

Re: Excel reading issue in Pentaho workflow

Yes, I have a 2 minutes and I have the same results. I also tried to perform check-in and check-out in the file, but even so, some columns are not read by the Pentaho application.

Was this reply helpful? Yes No