Please help me figure out the origins of the blank rows of my Microsoft List.
I have been testing a Microsoft Automated Flow that reads data from a CSV. To begin with, the flow is supposed to try to find a corresponding match in the "Title" column (so that the Title in a row in the List matches the Title in a row in the CSV file). When this happens, the corresponding row in the List is updated with the row information in the CSV file.
Now, here is the problem, there are now blank rows in the LIST. I do not understand how this could happen. I have seen in the past a situation where a CSV file can have a blank row from a edit mistake in EXCEL. When this happens, if you edit the CSV file in a text editor, you will see a row of commas depicting a row of blank cells. But I checked each CSV file I have used in my tests and none of them have one of these rows.
So what is going on here and how can I fix it? What could be causing these blank rows in my List?
