Answered

Blank line written in Flow

(0) Share

Report

Posted on by Stephmeta

I have created a flow that takes data from a webpage and writes the data to a network file. (note that the data is in a table from https://www.bloomberg.com/professional/product/indices/bsby/) I have several issues 1. the data is extracted as a list and adds a blank 1. from the data I have selected. (see example) which then get written in the file. How do I remove the blank data? Next PAD writes the data down in a active column when I would like it to write the data across a specific a column and row.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please share your Extract step by selecting it and copy-pasting it here.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

If it always grabs the blank one, remove from list %List[0]% where the list is 0 based index, so 0 is the first item.

After that, I would put it on a loop starting at 0 ending at %List.Count% increment of 1. Then write each item from the list as needed. Example:

Loop

Set variable %ExcelRow% to %LoopIndex +1%

Write %List[LoopIndex]% to Excel A & %ExcelRow% 'so in the first loop (loopindex 0), it goes to row 1

End Loop

Good luck!

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Michael is 95% correct. One-column extractions like this are always datatables and not lists anymore. So you would have to Delete row from datatable.

Another method is to edit the extraction selector like so. Syntax is kinda quirky, but it works...

td:eq(2):not(:empty))

Was this reply helpful? Yes No
Stephmeta 51 on at

Like (0)

Report
Copy link

Link copied!

As requested. I select the data, right click and extract element value as a text.

Was this reply helpful? Yes No
Stephmeta 51 on at

Like (0)

Report
Copy link

Link copied!

I followed your steps as illustrated entered td:eq(2):not(:eq) yet the no change.

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like (0)

Report
Copy link

Link copied!

Even easier way of getting rid of any blanks no matter what inside a list / 1 column data table:
Use "Remove item from list" as such:

where %""% is any null value.
this finds any null value in your data and removes it from the list.
if the blank value is a space instead use %" "% with a space in-between the quotations.

Was this reply helpful? Yes No
Verified answer

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You have to put this selector:

td:eq(2):not(:empty))

Was this reply helpful? Yes No
Stephmeta 51 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately it did not work. see error.

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like (0)

Report
Copy link

Link copied!

That's fine it means it didn't find any blanks that are spaces, try %""% instead, note that you also have to create an On Error command if you ever don't get blanks, this will prevent this error from being in the way of the automation (do that last)

Was this reply helpful? Yes No
Stephmeta 51 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I enter td:eq(2):not(:empty)

Was this reply helpful? Yes No