
Why can't I get the datatable property .RowsCount for the %Datatable% variable? I've tried to get directly from the %ConfigObj['excel'][i]['conteudo']% but it also doesn't work. Does someone know what's happening? Could it be a bug?
According to Microsoft's documentation, RowsCount is a property of datatables (https://docs.microsoft.com/en-us/power-automate/desktop-flows/datatype-properties#datatables ). By double clicking on variable within variables panel we can see that %Datatable% variable is datatable type indeed:
Hi @lvgs
I'm reading an Excel sheet and the resulting output is a datatable and then displaying using .rowscount which works fine.
Probably in your case something else is happening which needs to be taken a detailed look.
Alternatively, can you use "For each" loop which just needs the name of the datatable and it automatically loops till the last row of the datatable.