Hello Experts,
We are trying to get all the mailboxes created in Azure AD to our ServiceNow Table via an Import set. For creating these mailboxes, we have a catalog Item which once raised, we have created a custom ServiceNow Flow Designer Action which is successfully creating a mailbox in AzureAD using powershell scripts that runs on Mid Server. Now we want to get these mailboxes imported on our ServiceNow table using Transform Maps on a Scheduled basis. To achieve this, we are using Flow Designer to run PowerShell to pull mailbox data from office365 and place this into an import set. Then we are using Robust Transform to transform the data to our target table.
Issue we are facing is - Once the mailbox is created successfully, while retrieving that mailbox we are getting "PowerShell script execution failed" error. Please see below screenshots :-
Please Note that the service accounts we are using have all the latest modules installed and verified and also the mid-server is properly configured. Another issue we are facing is
Is there any specific permission is required on the mid-server or service accounts. I have checked many resources available but didn't found any help. Please let me know if you need any more information on custom powershell scripts.
Any help will be appreciated 🙂
