Thank you for reaching out on Microsoft Q&A!
I've tested your outputs in my test lab and came to a very simple but straightforward solution to your problem. The empty lines are recognised bij a double return, whereas the "normal" lines only have one return (before content starts again).
Therefor I think the solution would be to:
- Define a string variable called 'doubleReturn' and enter two returns in it
- Define a string variable called 'singleReturn' and enter one return in it
- Replace all double returns in your CSV output with a single return using the following code:
Please note that even though this solution may solve your issue with the blank lines, it's better to check why the source of this action is returning empty values in the first place. It would be possible to use a 'Filter' action and leave only lines with content in it, before inputting it to the 'Create CSV table' action.
Please click “Accept answer” if you find this helpful. Feel free to drop additional queries in the comments below!