Power Automate latest SP List appended text update

Good evening, 

I am having problems with the appended text field in SharePoint Lists and using this in PowerBI. 

Is there a way using Power Automate to capture the latest appended text update and duplicate that to a separate list column for this to be used in PowerBI reporting and show the latest update?

Currently I have problems where the appended text update shows as blank in PowerBI when an alternative column is updated as it assumes the lack of an appended text update is the latest (i.e blank)

Hopeful this is a common issue and is solvable somehow, thank you 🙂