Making the Image column in a SharePoint more useful [to me]

Say you want to build a “call-to-action” type functionality with Audience Targeting to your SharePoint intranet utilizing PnP Modern Search – maybe something like this:

A natural place to store the text and publishing values in a list. And since we now have the Image column, it seems like a natural place to place an image we can call up, right? No. Because Microsoft.

How do we solve this?
We use the Power Platform!

Below is a Logic App that reads the list for changes, fetches the image url from the list column and writes that back to the list.

Remember to add a hidden StopRun column with “Append Changes to Existing Text” to avoid a feedback loop in your automation!

Hope that this will bring you joy to your solution!