It’s been quiet from us for a while now, but that doesn’t mean we haven’t been working. Behind the scenes, the solution is slowly starting to take shape.

We’ve set up an agent for automatically generating reports based on soil types, rocks, and minerals.
To store the report in SharePoint, we’ve created an Azure Function (provisioned using Bicep templates) that transforms the agent’s output into a format that the somewhat picky SharePoint connector in Power Automate will accept.

Bicep template for Azure function deployment

Azure function, PowerShell flavoured

In-agent flow