Execute PowerShell on Service Portal Request form

Dazler · ‎06-26-2023

Hi,

I have been tasked with creating a form that will execute a PowerShell to return a csv template. I know that I can store templates on the catalog item as an attachment and retrieve it that way, unfortunately, the template changes often. This is why I have to execute a PowerShell to retrieve the data and user script to turn it into a csv.

Does anyone know the best way to achieve this?

Peter Bodelier · ‎06-26-2023

Without knowing the specifics and assuming you want this to be visible on a catalog item in a Service Portal:

You would have to create a portal widget and leverage that in a variable (type custom).

I would personally prefer to call a flow designer flow from that widget to retrieve what is necessary using integration hub, and the use the output to display in the widget, but there may be other ways.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

Dazler · ‎06-26-2023

In Flow I could use the utility action to create the CSV and then figure out how to pass it back to the widget.

Thank you for your help in this.