Just sharing another TIP from our real-world experience that we have gathered from one of the automation where we are using REST API to perform some operations. On connecting the rest API using Invoke-Restmethod PowerShell we were getting error: The underlying connection was closed – Could not establish trust relationship for the SSL/TLS secure…
We have recently been involved in one of the automations where we must upload the csv file automatically daily to vendor Secure FTP. This time we have utilized Python instead of PowerShell because of project requirements. I am sharing the code samples here to achieve it. Module required: pysftp Download the code samples from git…
Most of the admins and developers working on automation have built hundreds of flows in PowerAutomate but they do not get timely failure alerts so that they can resubmit the flows. We were also facing the same issues with our ever-increasing flows and not getting the flow failure messages until later in the week. After…
We got the new requirement to update the extension attribute on Azure AD devices. Initially we thought that we will update the extension attribute on onpremise and thru AzureAD connect it will replicate back to AzureAD but our assumption was wrong as extension attributes do not replicate for devices, it replicates for user objects. Here…
We have recently written this PowerShell magic by following the Microsoft documentation. How To: Manage stale devices in Azure AD This script has been parameterized to do multiple functions as per your needs. Prerequisites for this solution: vsadmin module Azure AD module Download the solution from below git hub link: (AzureMobileStaleDeviceCleanup.ps1) https://github.com/VikasSukhija/Downloads Download the solution…
As you all are aware about deadline for office 365 exchange online basic authentication closure is approaching so every admin or developer must kill the basic authentication in their exchange environment. Some admins have already closed the gates for basic authentication by closing the pop/imap/smtp at the mailbox or Conditional access policy levels. There are…
There are recent changes to naming for a department, as a result one of our customers contacted us to change the Name of the PowerApps form Title that is displayed at the top. I thought it would be simple and it might be taking name from the embedded list as name on the SharePoint List…
As everyone in Technical Community is aware that MSOnline and AzureAD modules will be depreciated. We have started working on converting our automated solutions to use Microsoft Graph SDK. This is one of the solutions that utilize MSOL where we have extracted AzureAD roles and their assignments. Extract office 365 Role Admins | Tech Wizard…
We have done hundreds of automations during last few years and most of these are based on SharePoint lists. New requirement came into light from management as they want to see the metrics for processed requests from automations. As these all automations are based on SharePoint lists so we have created below PowerShell magic to…
We have encountered a situation while working on an older Powerautomate flow that needs some modification. It requires UserPrincipalName instead of User Email. (People picker) It sounds to be simple but there is no dynamic field to accomplish this.. Now what should we do? On researching we have found a solution to achieve it.. We…
Tech Wizard 