Flow/Power Automate Issues Populating a SharePoint List with Blank Item At End

Question

Hi,

I have a flow I created that clears a list I have in SharePoint, re-populates the list, then deletes the 1st item (header).
This list is then used in another flow that uses "Send an Email (V2)", and populates the recipient's emails from this list.
Looks the last time it populated, there was a blank row on the bottom.
The blank row is now preventing the "Get Items" action?
How can I check for and remove this blank item on the bottom of the list?

Thanks,

• Chris

Here is the SharePoint list with blank item at bottom:

The actions on my flow:

Answer 1

Hi @Christopher Chung ，

Welcome to Q&A Forum!

Please following steps:

1.Create a excel file named "IRMUserList.xlsx" and format as table. Upload the .xlsx file to OneDrive for Business.

2.Create list named "EchoList"

3.Create a Microsoft Flow

4.Save and Test flow

Thanks,
Echo Du

=================================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.