First, let’s start with the Connected Gateway. The link above goes into a bit of detail on how to configure the connection. Nothing special there.
\nSecond, on the Connected Gateway, run this PowerShell script:<\/p>\n
$FileSystemWatcher = New-Object System.IO.FileSystemWatcher\n$FileSystemWatcher.path = \"C:\\temp\\WatchMe\"\n$FileSystemWatcher.Filter = \"Flow.txt\"\n$FileSystemWatcher.EnableRaisingEvents = $true\n \nRegister-ObjectEvent $FileSystemWatcher \"Changed\" -Action {\n$content = get-content C:\\temp\\WatchMe\\Flow.txt |select-object -last 1\npowershell.exe $content\n}<\/pre>\nThis script sets up a FileSystemWatcher <\/a>on the C:\\temp\\WatchMe\\Flow.txt file. The watcher will only perform an action if the file is changed. There are several options for the “Changed” parameter – Created, Deleted, Renamed, Error, etc… Once created, the watcher will look at the last line of the c:\\temp\\WatchMe\\Flow.txt file, and launch a PowerShell process that takes that last line as the input.<\/p>\nThird – This is the best part. Since we have a FileSystemWatcher, and that watcher is reading the last line of the C:\\temp\\WatchMe\\Flow.txt file and kicking that process off, all we have to do is append a line to that file to start a PowerShell session. Flow has a built-in connection for FileSystem. You can see where this is going. Create a new Flow, and add an input action – I am fond of the Outlook.com Email Arrives action. Supply a suitable trigger in the subject, and add the ‘Append File’ action from the FileSystem service. Here is how mine is configured:
\n![\"\"](\"http:\/\/draith.com\/wp-content\/uploads\/2017\/06\/EmailtoPowerShell.png\")
<\/p>\n
The only catch with this particular setup is that the body of the email needs to be in plain text – Windows 10 Mail app, for example, will not send in plain text. The body of the mail is the PowerShell command we want to run. For example, maybe we want PowerShell to get a list of processes that have a certain name, and dump those to a text file for parsing later. Simply send an email that has the body of “get-process -name chrome|out-file c:\\temp\\ChromeProcesses.txt”. Here is what that results in:
\nBefore we send the email:
\n![\"\"](\"http:\/\/draith.com\/wp-content\/uploads\/2017\/06\/Before.jpg\")
<\/p>\n
The Email:
\n![\"\"](\"http:\/\/draith.com\/wp-content\/uploads\/2017\/06\/EmailtoPowerShell.jpg\")
<\/p>\n
After a few minutes – an new folder appears!:
\n![\"\"](\"http:\/\/draith.com\/wp-content\/uploads\/2017\/06\/TextFile.jpg\")
<\/p>\n
The contents of the text file:<\/p>\n
\nHandles NPM(K) PM(K) WS(K) CPU(s) Id SI ProcessName \n------- ------ ----- ----- ------ -- -- ----------- \n 1956 97 131588 191648 694.98 728 1 chrome \n 249 22 34268 43356 1.63 4264 1 chrome \n 381 81 307592 331312 145.16 6080 1 chrome \n 149 12 2140 10076 0.05 7936 1 chrome \n 632 86 277900 557484 974.00 9972 1 chrome \n 431 31 147956 159404 182.11 10056 1 chrome \n 219 12 2132 9608 0.08 11636 1 chrome \n 283 50 135932 141512 98.05 12224 1 chrome \n 396 54 133912 297432 18.58 12472 1 chrome \n 253 46 107348 106752 50.13 13276 1 chrome \n 381 48 114452 128836 242.89 14328 1 chrome \n<\/pre>\nThink about what you could do with this – Perhaps you want to do an Invoke-WebRequest every time a RSS Feed updates. Maybe start a set of diagnostic commands when an item is added to Sharepoint. Kick off actions with a Tweet. If you want full scripts to run instead of commands, change the Action section of the FileSystemWatcher to “PowerShell.exe -file $content”. Easy as pie.<\/p>\n","protected":false},"excerpt":{"rendered":"
Want to start PowerShell commands from a Tweet? Yeah you do, and you didn’t even know you wanted to. Earlier this month, a great Flow of the Week was posted that highlighted the ability to use a .net filesystemwatcher to kick off local processes. This sparked an idea – I think we can expand on … Continue reading “Run _Anything_ with Flow. PowerShell Triggers”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[8,16,24],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-flow","tag-powershell","tag-why-not"],"_links":{"self":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=210"}],"version-history":[{"count":0,"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions"}],"wp:attachment":[{"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}