Issue
When using Office 365 query user profile action with connection manager, this error might occur:
Unable to reach destination server
Unable to reach destination server
Resolution
- Ensure that "workflows can use app permission" feature has been activated via site settings >> Manage site features
- If MFA (Multi-factor authentication) has been enabled in tenant then execute the cmdlet Set-SPOTenant -LegacyAuthProtocolsEnabled $true
Additional Information
Set-SPOTenant - https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/Set-SPOTenant?view=sharepoint-ps