I'm struggling with getting the rows present in an Excel worksheet in my Logic App. Even Google did not give me reasonable answers unfortunately.
I can get the Worksheet(s) with the "Get Worksheets" Action but I have problems with reading the rows from it. Currently I am using the "Excel Online (Business)" connector.
The excel will only contain one single Worksheet and no Table. Otherwise I could have used the "List Rows in a Table" Action but this scenario is actually not possible.
Could one give me some advice on how to read the rows from an Excel-Worksheet?
Any help is highly appreciated.
CodePudding user response:
We must have a table established in our Excel file before using the Excel Online (Business)
connections.
In order to add a table select all the concerned cells and navigate to Insert > Click Table. Now add the Table Name in List rows present in Table
or Get a row
connectors to retrieve the data.
Here are the screenshots for reference:
The outputs of two connectors:
Here are the sample Excel files that are used :
sampleee.xlsx
duplicates.xlsx
CodePudding user response:
Since it is not possible to add a Table-Area in the excel prior the Logic App processing because of the way the Excel file is delivered I have solved the problem by explicitly adding a Table in the Logic App to the incoming Excel file and filter it in "Get Rows present in table" to get only the rows containing data.