I am downloading a listing of transactions from a database via a custom connector, and I need to find a way to populate a comments field next to each transaction, so that users of the report can add comments against individual lines.
I intend to create a SQL table which can hold the comments, stored against the unique transaction reference code so that they are displayed for reporting each time the visual is opened.
Any suggestions as to the best method for doing this please? I have seen a couple of tutorials that suggest creating a PowerApp visual for this, but not sure if this would be the best option.
