I have a excel uploaded in Sharepoint online.
As you see i only have one row with value. But when i use 'list rows' action in the flow , it is picking up 2 rows. The one with the value abcd@hotmail and second one that is empty. See pic below.
1st record :
2nd Record :
Empty value is being picked
May i know why it is picking an extra record that is empty . Is there anything wrong with my excel table ?
Accepted Solutions
From your first screen shot of the Excel table it has empty rows so make sure only select the rows with data and format as table.
From your first screen shot of the Excel table it has empty rows so make sure only select the rows with data and format as table.
Helpful resources
Welcome to the User Group Public Preview
Check out new user group experience and if you are a leader please create your group
Community Challenge - Giveaways!
Participate in the Power Virtual Agents Community Challenge
2021 Release Wave 2 Plan
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
