Unanswered

Output showing in one instance but not for the rest of them

(0) Share

Report

Posted on by TelmoERF96

170

Hello everyone, I am extracting information from several websites and populating a datatable with it. It has been working fine for most websites but I ran into a problem with this website (https://www.ine.pt/xportal/xmain?xpid=INE&xpgid=ine_destaques).

I am able to extract the information I want to, and am also able to manipulate it to make sure that it's the way it is intended.

The problem comes when I try to create a new line in the datatable to insert the information.

This is my new line action,

And it's happening on loop inside a for each cycle,

The lines are being created but with some output missing,

The only row displaying the intended output is the 4th one with the arrow. Neither of the rest has the date inside the parentheses like the 4th one. I don't know why, because I am sure that the variable INEDate is working as intended since its used as the argument for the 4th column of the row, and I have used this same method for hundreds of lines before.

This is the part in question with the INEDate not showing in the concatenation with the exception of the 4th cycle of the for each, and the INEDate displaying correctly in the column where it is solo.

If anyone could help I would really appreciate it, these forums have been great to learn more of PAD

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Can it possibly be that your descriptions have a newline at the end or possibly span several lines? If they do not span over several lines, can you try using Trim text on it and then use the trimmed text to push it into the table?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your answer Agnius, and I apologize the late reply.
I did as you said and performed those checks and I still get the same outcome, it didn't work. What comes as strange to me is that I have been doing this same process for hundreds of websites and this is the first time I've come across this "error".
If you have any more ideas of what could be happening here I would greatly appreciate.

Thank you once again,
Telmo Ferreira

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Might also just be a bugged preview. What do you do with the table after the loop? Can you try pushing it to a file (such as a CSV file, an Excel file or something) to see if the outputs actually include the dates?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No