Good morning, I have the following automation that records the summaries of daily meetings.

The problem I am having is that I am getting too many " li " and " ul " tags, and I have blank spaces. How could I solve this?

I attach a capture of my Excel file that I am using, and of my HTML code.



@ppr If you could help me with this problem, it would be very helpful!

I attach my RPA project (50.7 KB)

Hi @Atejera
did u need to generate the html code from the excel data right?

Yes, if you look at the automation code that I sent, I kept each data from my excel and then sent it by mail. The only thing that remains for me is to correct this error, that I have more blank spaces in the part of “IMPORTANT POINTS” (as shown in the image of my mail)

filter out all rows on Sub Points Col which are empty (Assumed you are working further on the other approaches from your other topics, eg. the filling up…)

then there will no empty second level li be triggered

I understand your point, but I couldn’t figure it out. Could you show me in code?

I did not finish understanding the code that you had armed me and that is why I would not know how to add the “Important Sub Points” to it.

I tried to do this but it didn’t work.

I do not quite understand how to relate this information that I get in my code.

As you did in this code, I attach a screenshot for the “IMPORTANT POINTS” part.