"Add a row into a table" by power automate to excel but it changed the whole column

[fitrikzaman]

Hello guys.

I'm having problems where I used "Add a row into a table" function with formula "=COUNTIF(D:D, \"*input number*\")". It changed the whole column having the same value from the latest row updated by power automate.

 this thing happen to whole column for every new data updated from power automate.