Answered

Javascript works in console but returning blank output in Power Automate desktop

(1) Share

Report

Posted on by tawheed-bscic

I am trying to get rowCount of a HTML table using Javascript. The code works fine in console. but it is not saving the value to power automate. The code is below:

function countTableRows() {
var tbody = document.getElementById('MainTable1512446');
if (!tbody) {
console.log('tbody element not found.');
return 0;
}

var rows = tbody.getElementsByTagName('tr');
var rowCount = rows.length;

console.log('Number of rows:', rowCount);
return rowCount;
}

countTableRows();

The error is thrown when the output is converting to a number and used as a loopindex. i added a display message for debugging it shows blank. What could be the solution?

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Verified answer

NathanAlvares24 1,714 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @tawheed-bscic !

Can you try this instead:

function countTableRows() { var tbody = document.getElementById('MainTable1512446'); if (!tbody) { console.log('tbody element not found.'); return 0; } var rows = tbody.getElementsByTagName('tr'); var rowCount = rows.length; console.log('Number of rows:', rowCount); return rowCount; }

The only thing which I removed is: countTableRows(); at the end.

The reason is that there is no need to call the function when using this action from PAD. This PAD action will automatically call the function and return the result into the PAD variable, 'Result':

It is different from how you normally run JavaScript on a webpage using the console as there you need to insert the function and then call that function (with parameters if any).

So please do check this and let us know.
NathanAlvares24 1,714 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Also I did notice that you have Power Fx enabled. Is that done by mistakenly or are you trying to attempt the use case using Power Fx?

In any case, if you are doing the use case using Power Fx, you can continue doing so. But if done mistakenly, please try to create a new flow with Power Fx disabled as seen in below pic., copy those actions (Ctrl+A) then (Ctrl+C) and then paste (Ctrl+V) those same actions into your new flow which has Power Fx disabled
tawheed-bscic 7 on at

Like
a
(1)

Report
Copy link

Link copied!

My problem is solved by removing the function call. For power FX needed to change some variable syntax. Thank you for your help. I am fairly new to power automate. Previously I used winAutomation. Although the process ran, it was very slow.