I have an External Data column which gets data from a SQL table. And some secondary columns which gets auto-populated based on the external data column value . This column works fine with out any issue. The challenge is to refresh the data in SharePoint list when the SQL data is updated. There is an out of the box "Refresh External Data" icon next to the column which, upon clicking, will refresh the data. But user needs to go and click the icon and refresh values every time, it is too manual.
It would be great to have a nintex workflow action to refresh the external data column.