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!