cancel
Showing results for 
Search instead for 
Did you mean: 

The first record cannot be retrieved in PowerAutomate.

When reading from excel tables in PowerAutomate, if you hide the table header in Excel, the first record cannot be retrieved.

Here's the result:
1,When the search condition (filter area) is not specified in PowerAutomate
  When header is display in Excel: OK
  If you hide headers in Excel: OK

2,When specifying search condition (filter area) in PowerAutomate
  When header is display in Excel: OK
  When header is hidden in Excel: NG (the first record cannot be retrieved. For example, if there are 3 records that apply to the condition, only the back 2 can be obtained.)

Status: New