Power Query Function to Replace Text with Wildcard

If text contains a particular string, replace the cell value with the string

replaceTextIfContains = (inputText, old, new) =>
if (inputText is text and Text.Contains(inputText, old)) then
new
else
inputText

Use it in this format:

Table.ReplaceValue(Source,"ValueToFind","ValueToReplaceWith",replaceTextIfContains,{"Representative"})

Advertisements

Powershell – Send Mail through O365

$cred = Get-Credential
$to = "somebody@domain.com"
$from = "me@domain.com"
$smtp = "smtp.office365.com"
$port = "587"
$body = "<p>This can be <bold>HTML formatted</bold> with a bit of creative tagging.</p>"
$subject = "Look! I can send mail from Powershell"
Send-MailMessage -SmtpServer $smtp -Port $port -UseSsl -Credential $cred -From $from -To $to -Subject $subject -Body $body -BodyAsHtml -Verbose

O365 Skype for Business – Import 3rd Party Conference Credentials

Connect to O365

$cred = Get-Credential
$session = NewCsOnlineSession -Credential $cred -Verbose
Import-PSSession $session

Next, assign the CSV containing the user list to a variable

$accts = Import-Csv "C:\temp\users.csv"

Loop through the accounts in the CSV file and assign the credentials to the users


foreach ($user in $accts) { Set-CsUserAcp -Identity $user.Acct -TollNumber $user.TollNumber -TollFreeNumbers $user.TollFreeNumber -ParticipantPasscode $user.Passcode -Domain "lync.pgi.com" -Name "PGi" -URL "http://www.pgi.com/lynconline/localnums.php" }

If you do not know your Domain or URL, compare with an existing assignment

$user = Get-CsUserAcp
$user.AcpInfo