Hi @Simon Burbery ,
Thanks for reaching out to Q&A.
The logs (write-host "Successfully did such and such) that you see in the function console is the function execution logs. You can view them in the log stream or in the Monitor section, any logging statement that is present in the powershell script would be visible in the logstream and monitor section that has the function invocation logs.
Clicking on the below invocation would provide more logs
However if you are looking to view the logs that are ingested to the sentinel from the data source via function data connector, then you will have to look into the CustomLogs table under logs in the log analytics workspace linked with the Microsoft sentinel.
Hope this helps! Feel free to reach out to me if you have any queries.
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.