Get powershell Runbook result with Sharpoint List Workflow

Hi,

Based on the description, I assume that you have working solution that does following:

1. On SharePoint item creation, call Webhook passing GivenName and Surname.
2. Webhook (azure runbook) creates account on-premise and online.

Then, you would like to update the item with userprincipalname of the newly created account.

Updating SharePoint list item will require itemId, hence I can propose following update:

1. On SharePoint item creation, call Webhook passing GivenName, Surname and ItemId.
2. Webhook (azure runbook) creates account on-premise + online, and store the userprincipalname and itemId in Azure storage queue.
3. Add Logic App that monitor Azure storage queue, and update SharePoint list based on itemId. It will update userprincipalname.

Happy coding.

First of all thank you for your kind answer.
I'd never use a logic app, since it's a paid solution

I ended up with having the webhook (azure Runbook triggered by the sharepoint workflow) doing everything I need, both onpremise and online.
The runbook also sends an email with all users parameters and also with the operations log

The logs are also written in the output queue, and I can see the operations progress on Azure

Is there a way to follow the runbook progress in a sharepooint field, or in a powerapp?

Thank you

Hi,

May I know if you are using Power Automate (previously Microsoft Flow) to create the SharePoint's workflow?

Sure.
No I'm not using Power Automate, I usually don't like it very much for many reasons.
It has many limits and "pushes" to much towards Microsoft online direction, in my opinion

Also, the great majority of the connectors of Power automate are "premium".
This means that theycome at a tremendous cost!
They need a not-cheap license for each user will use the flow (or the App).
It can also have a pay-per-run option, but I'm not sure.

Currently I'm using a sharepoint designer 2013 workflow to use the webhook and trigger the powershell runbook

Thanks for clarifying.

I understand that you are planning to use PowerShell runbook for everything. The missing part in your flow is to update SharePoint list item, after account has been created.

Assuming that you modified the original webhook to include ItemId (and other SharePoint relevant info), you can follow this article : https://blog.tyang.org/2014/08/30/sma-runbook-update-sharepoint-2013-list-item/

You may want to read this article to get started with SPO credential : https://practical365.com/how-to-use-azure-automation-with-sharepoint-online-part-one/

Please let me know if it helps.