Hello,
I'm looking for the simplest solution that will not impact the live data already sitting on the SharePoint Tasklist.
We need to automatically update a column on a SharePoint Tasklist based on a value on a secondary SharePoint List using a reference column. (similar to vlookups on excel)
There seems to be a number of different ways to do this, power automate etc.
Would you be able to assist?

