Microsoft Power Automate Desktopã§RPAãå®çŸããŠã¿ã
èªåèªèº«ã®å人çæèŠãšããŠã¯ããšã³ããŠãŒã¶ã³ã³ãã¥ãŒãã£ã³ã°ã¯å€§ãã«çµæ§ã ãšæã£ãŠãããã©ãäžæ¹ã§æ¥æ¬ã§ãžãªãžãªãšç±ããæ¶ãã€ã€ããåœå ã®æ象ç¡è±¡ã®RPAã«ã€ããŠã¯æ» ãã ã»ããè¯ããšãæã£ãŠããçç±ã¯åŸè¿°ãããšããŠãæ¬æ¥è¯ããã¥ãŒã¹ãçºè¡šãããŸãããPower Automate Desktopã«ã€ããŠè¿œå è²»çšç¡ãç¡åã§å©çšå¯èœã«ãªããšã®ããšãããã¯æ¢ã«ããMicrosoft365ã®Enterpriseãã©ã³ãªã©ã«æšæºã§å©çšã§ããŠãPower Automateã®ãã¹ã¯ãããçã®ããã§ãWindows10ã«æšæºã§ã€ããŠããããã«ãªããšã®ããšã
ãšããããšã§ãçŸæç¹ã®Microsoft365ã§äœ¿ããŠãPower Automate Desktopã䜿ã£ãŠã¿ãŠãã©ããªæããªã®ãïŒãŸããªãªãŒã¹åŸã«ãã®éããªã©ãããã«èšè¿°ããŠãããããªãšæã£ãŠããŸãããŸããSeleniumããŒã¹ã®ãŠã§ãèªååã«ã€ããŠãåãäžããŠã¿ãããšæããŸãã
â»Connpassã«ãŠç¡åã®Power Automate Desktopå匷äŒãYoutubeã©ã€ãã§éãããŸãããã¢ãŒã«ã€ããããŠãã®ã§ããã€ã§ãé²èŠ§å¯èœã§ãã
â»2021/04/07 Peaceful Morning瀟ããPower Automate Desktopã®ç¡åã®åŠç¿ããã¹ããå ¬éãããŸããã
å³ïŒMS謹補ãšããã€ã³ãã¯ãã¯å€§ãã
ç®æ¬¡
- 1 ãŸããã
- 2 ã¢ããæ å ±
- 3 Power Automate Desktopã䜿ã£ãŠã¿ã
- 3.1 ã€ã³ã¹ããŒã«
- 3.2 å®éã«èµ·åããŠã¿ã
- 3.3 æ§ã ãªã¢ã¯ã·ã§ã³ã®æ°ã
- 3.4 ã¬ã³ãŒãã£ã³ã°æ©èœ
- 3.5 ã¡ãã£ãšãããã¯ããã¯
- 3.5.1 ã¢ã¯ã·ã§ã³ã¯ã³ããããŠããã¹ãä¿åãã§ãã
- 3.5.2 äœæãããããŒã¯OneDriveã«ä¿åãããŠã
- 3.5.3 ãã£ãã·ã¥ããããã¡ã€ã«ã«ã€ããŠ
- 3.5.4 çŽæ¥ä»ã®EXEãå®è¡ãããã¯ããã¯
- 3.5.5 ãããŒã®äžããä»ã®ãããŒãå®è¡
- 3.5.6 PowerShellã䜿ã£ãŠååæå®ã§ãããŒãå®è¡
- 3.5.7 UWSCã䜿ã£ãŠãããŒãå®è¡
- 3.5.8 Robin.exeã§Power Automate Desktopã®ãããŒãå®è¡
- 3.5.9 ããªã»ã«ã³ãã®ãŠã§ã€ããå ¥ããã
- 3.5.10 ããã¹ã眮æã§ç©ºçœã䜿ããã
- 3.5.11 ã·ã§ãŒãã«ããããŒãéä¿¡ããã
- 3.5.12 URL Schemeã掻çšãã
- 3.5.13 Python3ã¹ã¯ãªãããå®è¡
- 3.5.14 åã€ã³ã¹ããŒã«åŸã«ãšã©ãŒé »çº
- 3.5.15 ZIP解åã§æ¥æ¬èªæååã
- 3.6 æåã®ãã©ã³ã§äœ¿ã£ãŠã¿ã
- 4 æ°ã«ãªãæ©èœã§RPAãäœã£ãŠã¿ã
- 5 ãã©ãã«ã·ã¥ãŒãã£ã³ã°
- 6 åèåç»
- 7 é¢é£ãªã³ã¯
ãŸããã
æ象ç¡è±¡ã®RPAã¯æ» ã¶ã¹ã
èªåãåœå ã®RPA補å矀ã«å¯ŸããŠè¯ãå°è±¡ãæããªãçç±ã¯æ§ã ã§ããæ¢ã«RPAå°å ¥ã«æŒãã泚æç¹ã§ãèšè¿°ããŠãããšã§ããããã®äžãã補åãã®ãã®ã«å¯ŸããŠãã©ãŒã«ã¹ãããšä»¥äžã®æ°ç¹ã«ãŸãšããããŸãã
- ä»ç€Ÿè£œåãšäºææ§ãå šããªãïŒMSã®ããã«ããã¡ã¯ãã¹ã¿ã³ããŒããåãããªã話ã¯å¥ïŒ
- ã©ã€ã»ã³ã¹æéãéåžžã«é«é¡ã§ãæ ã«å°çšæ©ãçšæããŠïŒå°ã ãã§éçšãªã©ãšãããªã«ã·ã䜿ãæ¹ã暪è¡
- ã»ãšãã©åœå ã§ããå©çšãããŠããªãã®ã§ãéçºè³æãæ®ã©ååšããªã
- 1.ã«é¢é£ããäºãšããŠãä»ã®äŒç€Ÿã«è¡ã£ãŠããã®ã¹ãã«ã掻ãããªããæ ã«äŒç€Ÿã«ç¹å®ã®è£œåã«åè¶ãã人æãåŸã«ããã
- é«ãã©ã€ã»ã³ã¹æéã®å²ã«ãµããŒãããŽãã¬ãã«
- 誰ã§ãç°¡åã«ããã°ã©ãã³ã°ãªãã§äœãããšããã»ãŒã«ã¹ããŒã¯ã§è©æ¬ºãŸããã®è²©å£²ãããŠã
- ãã®è£œåã®ç¶ç¶æ§ãéåžžã«çåïŒäŒç€Ÿã補åããªããªãå¯èœæ§ãé«ãïŒ
- äžè¬ã«æ®åããŠãã補åã§ãªãçºãåŠç¿æ©äŒãäŒç€Ÿä»¥å€ã§ååšããªããçµæãã·ããªãªäœæãå€æ³šããŠããšããæ¬æ«è»¢åãªäºäŸãã
ãªã©ãªã©ã§ãããä»çŸåšãRPAã¯äžææã®çãäžããããçŸå®ãç¥ããåæ»ã§ã¯ãªãè¡°éãå¹»æ» ãããŠã³ããçŠãšãã®åŸã«åŸ ã£ãŠãäžæ³ã«ããITæè³ãæ¿æžããããšãèãããšãä»ããåœå RPAã«æãåºãã®ã¯æ£çŽãªã¹ã¹ã¡ããŸããããšããããä»åã®RPAéšåã¯é£ãã£ã±ãããSIeré£äžã®ããŒãã¹ã¹ããŒãžãåŠãé«é¡ã®æéã§å©çšè ããæŸåããŠãäºäŸãå€ããšããã®ãèªåã®å°è±¡ã§ããã¡ãªã¿ã«ãGoogle Trendsã«ããRPAååã¯ä»¥äžã®ãããªæããèŠäºã«èœã¡ãŠãã£ãŠããŸãã
Power Automate Desktopç¡åæäŸã®æå³
2021幎3æ3æ¥ã²ãªç¥ã - MicrosoftãããããŸã§Microsoft365ã®Power AutomateïŒæ§Microsoft FlowïŒã®è£œåã®ïŒã€ãšããŠååšããŠããPower Automate DesktopãWindows10ã«æšæºæèŒãããè¿œå è²»çšãªãã§å©çšã§ããããã«ãªããšçºè¡šã誰ã§ãèªç±ã«èªèº«ã®ãã·ã³ã§RPAãæ§ç¯ããç°å¢ãæã«å ¥ãããšã«ãªããŸããããã®è£œåã®å®æ床ã¯å¥ãšããŠããããã¯éåžžã«åã°ãããã¥ãŒã¹ãGoogle Workspaceã«ã¯ãã¹ã¯ãããRPAãšåŒã¹ã補åã¯ç¡ãããŸãWebèªååã§ã¯Puppeteerããããã®ã®ãèŠããã°ã©ãã³ã°ã®ã©ã€ãã©ãªãªã®ã§è£œåãšã¯åŒã¹ãªããAppSheetã¯Enterpriseã§ããå©çšã§ããªããšããææ§ãªã®ã§ããã®åéã¯Microsoftã«è»é ãããããŸããã
ãã®ãªãªãŒã¹ã¯éåžžã«ã€ã³ãã¯ãã倧ãããåœå ã®æ象ç¡è±¡ã®RPAã®å€ãã¯ããã§æ·æ±°ãããŠæ¶ããããšã«ãªãã§ããããæ ã«ä»ãåœå RPAã«æãåºãã¹ããããªãã®ã§ããåè¿°ã®æ» ã¶ã¹ãã§èšè¿°ããé ç®ã«å¯Ÿå¿ãããŠã¿ããš
- Windows10ããã³Microsoftãšããããã¡ã¯ãã¹ã¿ã³ããŒããåã£ãŠãäŒæ¥ã«ãã補åã§ãã
- ã©ã€ã»ã³ã¹ã¯ç¡åãå°çšæ©ãçšæããŠå ±çšãªã©äžèŠããã€ã§ãèªåã®ãã·ã³ã§RPAãå®è¡ã§ããïŒå·šå€§ãªãããåŠçã¯å°çšæ©çšæããã»ããããããã©ãïŒ
- äžçäŒæ¥ã®MSã«ãããã®ãªã®ã§ãéçºè³æã¯æåŸ ã§ããããŸããäžè¬ãŠãŒã¶ã«ããããŠããŠå ¬éã倧ãã«æåŸ ã§ããã
- ããã¡ã¯ãã¹ã¿ã³ããŒããªã®ã§ãä»ç€Ÿã«è¡ã£ãŠããã®ã¹ãã«ã¯æŽ»ããäºãå¯èœïŒä»ç€Ÿã§ããã®è£œåã¯æ®éã«ååšããã§ããããæšæºæèŒãªã®ã§ïŒãäŒç€ŸåŽãåè¶ãã人æãåŸãããã
- ãµããŒãã¯äžæããããã次第ãVBAã®ããã«äžè¬ãŠãŒã¶ã«åºããã°ãµããŒãèªäœèŠããªããªããããããªãã
- ãããããRPAã¯èª°ã§ãç°¡åã«åºæ¥ããã®ã§ã¯ãªããããã¯Power Automateãåãããã éçºç°å¢ã§é·ãæŽå²ã®ããMSã®æè¡åãèãããšåœå ã®RPAããã¯ãã£ãšæåŸ ã§ãã
- MicrosoftããªãªãŒã¹ãµããŒãããŠããã®ã§ããã®ã§ãåœå ã®åãç¥ãã¬äŒæ¥ã®è£œåããããç¶ç¶æ§ã§ã¯é¥ãã«æå©ã
- Windows10ã«æšæºæèŒã§ç¡åã§å©çšå¯èœãªã®ã§ãåŠç¿æ©äŒã¯èªå® ã§ãã«ãã§ã§ããã€ã§ãã©ãã§ãå匷åºæ¥ãã
- ãŸããPADç¹æã§ãããææã¢ã«ãŠã³ãã ãšPower Automateãšé£æºåºæ¥ãã®ã§ãMicrosoft365ã®åçš®ãµãŒãã¹ä»ã«åŠçãç¹ããäºãå¯èœ
äœãããäŒæ¥ã§ãã¹ãå°å ¥ããã«ããããã³ã¹ãäžèŠã§åºæ¥ãããŸãåãã°ãã®ãŸãŸç¶ç¶ããã°è¯ããšããç¹ã§éåžžã«è¯ãéžæè¢ã«ãªãã§ããããä»ç€Ÿã®RPAå°å ¥ããã¯ãããã®ã®ãçµå±äœ¿ããç¡é§ãªåºè²»ããããããæã¡æšãŠãããå°çšæ©ãšãã£ãæ²ããçµæ«ã¯èŠãã«æžã¿ãŸãã
â»ããªã¬ãŒæ©èœããã³ã¯ã©ãŠããããŒé£æºæ©èœã¯æåã§ãããMS謹補ãèãããåœå RPAã«ãéæãããã¯äŸ¡å€ãããã®ã§ã¯ïŒ
å³ïŒMicrosoft365ã®Enterpriseãªã©ãããã°äœ¿ããæ©èœããã
Power Automate Desktopã«ã€ããŠ
Power Automate Desktopã¯Power Automateãã¡ããªãŒã«è¿œå ãããŠãŸã éããªã補åã§ããSoftoMotive瀟ã®WinAutomationãè²·åãããŒã¹ãšããŠããŸãããã®å 容ã¯Robinãšããèªååã®èšèªã«å¯ŸããŠUIãçšæãããã®ãšãªã£ãŠããŸãããã£ãŠãRobinã§èšè¿°ããå 容ãã³ããã§Power Automateã«è²Œãä»ãããšã¢ã¯ã·ã§ã³ãçæããããããŸãã
ãŸã ããã®ãŒãªé¢ããããå€ãªãšãããã¯ãªãã¯ãããšããããããªããšã©ãŒãåºãã·ãŒã³ããããŸãããæŠãçŽæçãªã€ã³ã¿ãŒãã§ãŒã¹ã§äœããããã«ãªã£ãŠããŸãã
ãªããã·ã¹ãã èŠä»¶ãã®ä»ã¯ãã¡ãã®ããŒãžã«èšèŒãããŠããŸãã䜿ã£ãŠããOSã®ãšãã£ã·ã§ã³ããã°ã€ã³ããŠãã¢ã«ãŠã³ãã®çš®é¡ã«ãã£ãŠãå®è¡ã§ããå 容ã«å·®ããããŸããäž»ãªå·®ç°ã¯
- Windows10 Homeã®å ŽåãWindows Recorder v1ã¯äœ¿ããŸããã
- Windows10 Homeã®å ŽåãSelenium IDEã¯äœ¿ããŸãã
- Windows10 Homeã®å Žåãã¯ã©ãŠãé£æºã¯å®è¡åºæ¥ãŸããã
- Windows10 Homeã®å Žåããã¬ãã¢ã ã¢ã«ãŠã³ãã®æ©èœã䜿ããŸããã
- Microsoftã¢ã«ãŠã³ãã®å ŽåOneDriveã«ãããŒã¯ä¿åãäŒæ¥ã¢ã«ãŠã³ãã®å ŽåDataverseã«ä¿åããã
- ãã¬ãã¢ã ã¢ã«ãŠã³ãã®ã¿ãã¯ã©ãŠããããŒé£æºãããªã¬ãŒèµ·åãã¹ã±ãžã¥ãŒãªã³ã°ãããŒãå©çšããäºãã§ãã
- ãã¬ãã¢ã ã¢ã«ãŠã³ãã®ã¿ãäœæãããããŒãçµç¹ã®ã¡ã³ããŒãšå ±æå¯èœ
- ãã¬ãã¢ã ã¢ã«ãŠã³ãã®ã¿ãäžå 管çãšã¬ããŒããå©çšã§ãã
- ãã¬ãã¢ã ã¢ã«ãŠã³ãã®ã¿ãAIãã«ããŒãã«ã¹ã¿ã ã³ãã¯ã¿ãå©çšããäºãå¯èœ
PADãæ±ãäžã§ã®ãã¯ããã¯
Power Automate DesktopãRPAããã£ããæ±ãäžã§ã®ãããããªãã¯ããã¯ããŸãšããŠã¿ãŸããã以äžã®ãšã³ããªãŒãåèã«ããŠã¿ãŠãã ããã
ã¢ããæ å ±
2021幎3æã®ã¢ããããŒã
ãªãªãŒã¹çŽåŸã¯è²ã ãã®ãŒã§ããªãã䜿ããªããšãã£ããã®ããã£ãããããã®ã§ããã以äžã®ã¢ããããŒããæœãããŠããŸãã
- ãã¬ãã¢ã ã¢ã«ãŠã³ãã®å Žåãå ±æã¢ã€ãã ã«èª°ããšå ±æããŠããããŒã衚瀺ãããããã«ãªã£ãã
- èšå®ã«å®è¡ãããŒã®ãããããŒã«ããåæ¢ãããã°ã°ã©ãŠã³ãå®è¡ãªã©ãè¿œå
- äŒæ¥ã¢ã«ãŠã³ãã«æŒããŠãããŠããåé¡ã ã£ããDataverseããŒã¿ããŒã¹ããPADããäœæå¯èœã«ãªã£ãã
- å€æ°äžã®å€ãå®è¡äžã«ç¢ºèªã§ããããã«ãªã£ãã
- æåŸã®ãšã©ãŒãååŸã¢ã¯ã·ã§ã³ãè¿œå ãä»ã«ãè¿œå ãããŠãã¿ããã
- ããŠã¹ã«ãŒãœã«åº§æšãã¢ã¯ã·ã§ã³äœæäžã«è¿œããããã«ãªã£ã
- Windowsç°å¢å€æ°ãååŸã«æŒããŠããªã¹ããããéžã¹ãããã«ãªã£ãã
- ã¬ã³ãŒããŒèšé²äžã«å€æ°ãå©çšå¯èœã«ãªã£ã
- ã¬ã³ãŒããŒã§ã®UIèŠçŽ è¿œå æã®ã¡ãã»ãŒãžã誀蚳ã§Ctrl + â + ã¯ãªãã¯ããã¡ããšãCtrl+ã¯ãªãã¯ã«èšæ£ãããã
ããšããªãªãŒã¹çŽåŸäœ¿ããªãã£ãFTPæ¥ç¶ã§ããã䜿ããããã«ãªã£ãŠãŸãããã¹ããããŒãããŠãŒã¶åããã¹ã¯ãŒãã®èšå®ã ãã§ãã¡ããšãèªåã®å¥çŽãµãŒãã«æ¥ç¶ãããã¡ã€ã«ã®FTPã«ã¢ããããŒããããŒã«ãŠããªã¢ãŒãã®å Žæãæå®ããŠããã°ãèªåã¢ããããŒããã§ããããã«ãªã£ãã®ã§ããŠã§ããµã€ãã®ãã¡ã€ã«ã®æŽæ°ãªã©ããPADã§ããããªã§ããããã«ãªããŸããã
å³ïŒFTPã䜿ããããã«ãªã£ãã®ãäžçªããããã
2021幎4æã®ã¢ããããŒã
çµæ§æ©ãããŒã¹ã§è²ã ã¢ããããŒããå®æœãããŠãPADã§ãããä»åã®ã¢ããã«ãŠå²ãšéèŠãªå 容ããããŸããã
- ãã¬ãã¢ã ã¢ãªçµç¹ã¢ã«ãŠã³ãã«ãŠãæŽæ°ãã¿ã³ãè¿œå ãPower Automateäžã®ãã€ãããŒãšå ±æãããŒã®äž¡æ¹ã®ãªãã¬ãã·ã¥æŽæ°ãå¯èœã«ãªããŸããã
- æ¢åã®ãããŒã®è€è£œãååãä»ããŠä¿åã«ãŠã³ããŒãäœãäºãã§ããããã«ãªããŸããã
- ãã¹ã¯ãããã¬ã³ãŒããŒã«ãŠãç»åãèªèããŠOCRã䜿ã£ãåŠçãã§ããããã«ãªããŸããã
- ã¢ã¯ã·ã§ã³ã³ããŒã«ãŠãUIèŠçŽ ãã³ããŒãããããã«ãªã£ã
- Javaã¢ãã¬ãããªã©ã®æäœãã§ãããããªã£ããšã
- robinèšèªã®ãµã€ããæ¶æ» ããŸãã
ç¹ã«ã2.ååãä»ããŠä¿åã§ç°¡åã«æ¢åã®ãããŒãã³ããŒã§ããããã«ãªã£ãç¹ããããŸã§ã¯ããªãªãžãã«ã®å 容ãã³ããŒããŠãæ°ãã«ãããŒãäœã£ãŠè²Œãä»ããšãã£ãé¢åã ã£ãæé ãç°¡åã«ã§ããããã«ãªã£ãç¹ã
ãããŠããããŸã§ã®ãããŒã®ã³ããŒã¯ãUIèŠçŽ ïŒappmaskéšåïŒãã«ã€ããŠã¯ã³ããŒåºæ¥ãªãã£ãã®ããä»åã®ã¢ããã§ãã®éšåããŸãšããŠã³ããŒã§ããããã«ãªã£ãã®ã§ãã³ããã®ã³ãŒãã§å®å šãªè€è£œãé åžããããåã£ãŠããäºãå¯èœã«ãªããŸããïŒåçŽãªUIæäœã§ããããªãã®è¡æ°ã®ã³ãŒãã«ãªãã®ã§ããŠã§ãäžã§ã®é åžã§ã¯ãã¡ã€ã«ã§ã®é åžãå¿ èŠããïŒ
å³ïŒãããŒã®ã³ãŒãã®åŸåã«UIèŠçŽ ãå«ãŸããããã«ãªã£ã
å³ïŒãããŒã®è€è£œãç°¡åã«
2021幎6æã®ã¢ããããŒã
ä»åã®ã¢ããã§ã倧ããªæ©èœè¿œå ããããŸããããããŸã§ããããŒã®äžã§ãµããããŒãåŒã³åºãäºã¯åºæ¥ãŠããŸãããããµãã§ã¯ãªãã¡ã€ã³ã®å¥ã®ãããŒããããŒã®äžããåŒã³åºããŠé£ç¶ããŠRPAãå®è¡ãããšããæ©èœãè£ åãããŸãããåã®ãããŒããã®çµæãåãåã£ãŠãããŒå®è¡ãªã©ãåºæ¥ãŸãã
æé ãšããŠã¯
- å ã«åŒã³åºãå ã®ãããŒãéã
- å³ãµã€ãããŒã«ãããå ¥åºåå€æ°ãã®ïŒãã¿ã³ãã¯ãªãã¯ããŠãå ¥åãéžã¶
- å€æ°åãšå€éšè¡šç€ºåãæ¢å®å€ãªã©ãã»ããããŠä¿åãã
- ãããçµæãåŒã³åºãå ã«è¿ãããå Žåã¯ããå ¥åºåå€æ°ãã®ïŒãã¿ã³ãã¯ãªãã¯ããŠãåºåãéžã¶
- 4.ã«ç¶ããŠãå€éšè¡šç€ºåãšè¿ãå€ãã»ãããã
- åŒã³åºãå ã¯ããããŒã³ã³ãããŒã«ããDesktopãããŒãå®è¡ãè¿œå
- DesktopãããŒã§ã¯å çšã®åŒã³åºãå ã®ãããŒãæå®
- å ¥åå€æ°ãšããŠ3.ã§ã»ããããååãåºãŠããã®ã§ããã®ããã¹ãããã¯ã¹ã«æž¡ãããå€æ°ãå€ãå ¥åïŒãªãå Žåã¯æ¢å®å€ãå©çšãããïŒ
- åããè¿ãå€ãåãåãããå Žåã¯ãçæãããå€æ°ã®äžã«ããã¹ã€ããããªã³ã«ããïŒãã§ã«4.ã§ã®ååãåºãŠãã¯ãïŒ
- å¥ã®ãããŒå®è¡äžã¯ãåŒã³åºãå ã®ãããŒã¯äžæåæ¢ã®ç¶æ ã«ãªããè¿ãå€ãåãåããšåéããŸãã
ãŸããåçŽãªãããŒãéšååããŠããäºã§ãåå©çšæ§ãé«ãŸãããããŒã®åçŽåã«ãè²¢ç®ãããšæããŸãã
å³ïŒãããŒã³ã³ãããŒã«ã«è¿œå ãããŠããŸã
å³ïŒåŒã³åºãããåŽã¯å€æ°åãåããçšæããŠãã
ä»ã«å®è£ ããããã®ãšããŠ
- RDPãCitrixã®æäœã®éã®ã¬ã³ãŒããŒã¯ç»åèªèããŒã¹ã«èªåã§åãæ¿ãã
- Windowsã®ç°å¢å€æ°ã®ååŸãåé€ãå¯èœã«ãªã£ã
- Windowsã®ãµãŒãã¹ã®éå§ãªã©ãåºæ¥ãããã«ãªã£ã
- MODI OCRãå»æ¢
Power Automate Desktopã®ã¢ããé ä¿¡éç¥ããªãªãŒã¹ãã7æ¥åŸã«éãããããã«ãªã£ãã®ã倧ããã§ããã
Power Automate Desktopã䜿ã£ãŠã¿ã
ã€ã³ã¹ããŒã«
Windows10ã«æšæºæèŒãšãªããšæ¬¡åã®å€§åã¢ããããŒã以éã«ä¹ã£ãã£ãŠãããšæããŸãããçŸåšã§ãæ¢ã«ã€ã³ã¹ããŒã©ã¯å©çšåºæ¥ãã®ã§ä»¥äžã®æé ã§å©çšããäºãå¯èœã§ããä»åã¯ãVMware Workstation 14ã®Windows10(Build 1803ïŒã«ã€ã³ã¹ããŒã«ããŠæ€èšŒããŠã¿ãŸãã
- MSã®ãµã€ãã«ã¢ã¯ã»ã¹ããŠãç¡æDownloadãã¯ãªãã¯ãã
- ããŠã³ããŒããããSetup.Microsoft.PowerAutomateDesktop.exeãå®è¡ãã
- 次ãžãã¯ãªãã¯ããã€ã³ã¹ããŒã«å ãæå®ãæåŸã®ãã§ãã¯ããã¯ã¹ããã§ãã¯ããŠãã€ã³ã¹ããŒã«ãã¯ãªãã¯
- ã€ã³ã¹ããŒã«ãå®äºãããéãã
- ã€ã³ã¹ããŒã«åŸã¯ãã¹ã¿ãŒãã¡ãã¥ãŒãšãã¹ã¯ãããã«Power Automate DesktopãšããŠç»é²ãããŸã
â»èªèšŒãããã·ã®å ¥ã£ãŠãç°å¢ã ãšã€ã³ã¹ããŒã«ã«å€±æããã±ãŒã¹ããããŸã
â»äžéšã®äŒæ¥ã¢ã«ãŠã³ãã§Microsoft DataverseïŒCommon Data ServiceïŒãäœæãããŠããªããããå©çšã§ããªããšãããšã©ãŒãåºãŠããŸãã管çè ã«ãã管çã»ã³ã¿ãŒã§ã®ããŒã¿ããŒã¹ã®è¿œå ãå¿ èŠãšã®ããšã
å³ïŒãªã¢ãŒãã¯æåãã©ã³çšã®èšå®ã§ã
å®éã«èµ·åããŠã¿ã
ä»åã¯ãŸããéåžžã®Microsoftã¢ã«ãŠã³ãã§ãã°ã€ã³ããŠã¿ãããšæããŸããèµ·åæã«ãã°ã€ã³ãå¿ èŠã§ãããã°ã€ã³åŸã«åœã®éžæããããŸãããäžçªäžã®æ¹ã«ãããæ¥æ¬ããéžæããéå§ãããã¯ãªãã¯ããŸããèµ·åçŽåŸã®ç»é¢ã¯ç°¡çŽ ã§ãæ°ãããããŒã®ãã¿ã³ãã¯ãªãã¯ãããäœæéå§ã«ãªããŸãã
ä»åã¯ãŸããExcel2019ãèµ·åããŠé©åœã«ãªã«ãããŠä¿åãŸã§ãèªååããŠã¿ããããšæããŸãããã çŸåšã¯äœæãããããŒã誰ããšå ±æããæ©èœã¯æåã®ãã©ã³ãå¿ èŠã
- ãããŒåã¯é©åœã«ç®çã«å¿ããŠä»ããŸããäœæãã¿ã³ãã¯ãªãã¯
- ãããŒäžèŠ§ã«åºæ¥äžããã®ã§ãéçã¢ã€ã³ã³ãã¯ãªãã¯ããŠç·šéããŸãã
- å·Šãµã€ãããŒãåçš®ã¢ã¯ã·ã§ã³ã®é¡ãçãäžããããŒäœæç»é¢ãå³ãµã€ãããŒãå€æ°ã®åŠçãªã©ãæ åœããŠãããã§ãã
å³ïŒèšå€§ãªã¢ã¯ã·ã§ã³ã®æ°ã
æ§ã ãªã¢ã¯ã·ã§ã³ã®æ°ã
å·Šãµã€ãããŒã®æ°ã ã®ã¢ã¯ã·ã§ã³ã®æ°ã ãããããããŒäœæç»é¢ã«ãã©ãã°ã¢ã³ãããããããŠãäžé£ã®èªååã®æµããäœããããªã®ã§ãããéåžžã«èšå€§ã«ããã ãã§ãªãããªã«ããããã¢ãã¯ãªã¢ã¯ã·ã§ã³ãããããã§ã»ã»ã»ãèŠãŠã¿ããšããããããã¹ã¯ãããRPAãšSeleniumã䜿ã£ãWebèªååã¯çµ±åãããŠããŠäžã€ã«ãªã£ãŠããããã§ãã
- å€æ° - å€æ°é¢ä¿ã®åŠçãJSONãªããžã§ã¯ãã«å€æãããªã¹ãã®åŠçãªã©ããã
- æ¡ä»¶ - æ¡ä»¶åå²é¢ä¿ã®åŠçãifãswitchãªã©ãªã©
- ã«ãŒã - ç¹°ãè¿ãåŠçãfor eachãšloopã®äºçš®é¡ãjavascriptã§ããcontinueãbreakåŠçããã
- é 延 - ãããããŠã§ã€ãåŠçããŠã§ãã®ç¶æ åŸ ã¡ãããã»ã¹ããã¡ã€ã«ã®åŸ æ©ãªã©
- ã·ã¹ãã - ã³ãã³ãã©ã€ã³å®è¡ãVBScriptãJavaScriptãPowerShellãPythonã®å®è¡ãã·ã£ããããŠã³ãå°å·ãªã©ãæ åœããŠãããã ãPythonã2.xç³»ã ããšãããã»ã»ã»
- ãã¡ã€ã« - ãã¡ã€ã«ã®ç§»åãã³ããŒãCSVãã¡ã€ã«ã®èªã¿åããªã©ã®åŠç
- ãã©ã«ã - ãã©ã«ãã®äœæãã³ããŒã移åãªã©ã®åŠç
- å§çž® - ZIPå§çž®åŠç
- UIãªãŒãã¡ãŒã·ã§ã³ - ãã¹ã¯ãããã¢ããªã®ãŠã£ã³ããŠã®ææããã©ãŒã ãžã®å ¥åãäœæãã
- Web - ããŠã³ããŒããWebãµãŒãã¹ïŒREST APIãå©ãïŒåŠçãäœã
- WebãªãŒãã¡ãŒã·ã§ã³ - ããããChromeã®èªååãããŒã¿ã®æœåºããã©ãŒã ã®èªåå ¥åãªã©ãè¡ã
- Excel - Excelæäœãæ åœãã¯ãŒã¯ã·ãŒãèªã¿åããä¿åãæžã蟌ã¿ããã¯ãã®å®è¡ãã·ãŒãã®æäœãªã©å€çš®å€æ§ã«å¯èœ
- ããŒã¿ããŒã¹ - SQLã®å®è¡ãODBCãã©ã€ãã䜿ã£ãŠã®å®è¡ãªã®ã§ãAccessãMySQLããã©ã€ããå ¥ã£ãŠããã°å©ãã
- ã¡ãŒã« - ã¡ãŒã«éä¿¡ãã¡ãŒã«ã®åŠçãªã©ãè¡ã
- Exchange - äŒæ¥å©çšã§ã®Exchange Serverã®ã¡ãŒã«åŠçãè¡ã
- Outlook - Outlookã䜿ã£ãŠã®ã¡ãŒã«éä¿¡ãã¡ãŒã«ã®åŠçãè¡ã
- ã¡ãã»ãŒãžããã¯ã¹ - msgboxãåºããŠã¡ãã»ãŒãžã衚瀺
- ããŠã¹ãšããŒããŒã - ã«ãŒãœã«ããžã·ã§ã³ã®ååŸãšãã¿ã³ã®ã¯ãªãã¯ãªã©ã¬ã¬ã·ãŒãªã¢ããªèªååã§å¿ é ã®æ©èœ
- ã¯ãªããããŒã - ã¯ãªããããŒãã«äžæã³ããŒã貌ä»ããªã©ãè¡ã
- ããã¹ã - ããã¹ãã®åŠçå šè¬ãæ åœãåå²ãçµåã眮æãæ£èŠè¡šçŸãããªãã³ã°ãªã©
- æ¥æ - å ç®ãæžç®ãçŸåšã®æ¥ä»ã®ååŸãè¡ã
- PDF - PDFãã¡ã€ã«ããæåãç»åã®æœåºãããŒãžã®åå²ãçµ±åãè¡ã
- CMDã»ãã·ã§ã³ - cmdã©ã€ã³ã®ã»ãã·ã§ã³åŠçïŒ
- ã¿ãŒããã«ãšãã¥ã¬ãŒã·ã§ã³ - AS400ãšãã«ã¢ã¯ã»ã¹ããŠãªã«ããããšãïŒ
- OCR - TesseractãMODI OCRã䜿ã£ãŠã®OCRãšã³ãžã³ãå©çšããããããã¹ãæœåºãè¡ã
- æå·å - AESã§æå·åãããã·ã¥åãªã©ãæ åœããŸã
- ãµãŒãã¹ - WindowsãµãŒãã¹ã®éå§åæ¢ãªã©ã®ã³ã³ãããŒã«ãæ åœ
- XML - XMLãã¡ã€ã«ã®ããŒã¹ããå€ã®ååŸãªã©ãè¡ããŸã
- Active Directory - ADã®æäœå šè¬ãè¡ããŸã
- AWS - Amazon Web Service EC2ã®ã€ã³ã¹ã¿ã³ã¹æäœããªããè¡ãã
- Azure - Microsoft Azureã®ä»®æ³ãã·ã³ã®æäœããªãœãŒã¹ã°ã«ãŒãã®æäœãè¡ãã
- ã³ã°ããã£ã - IBM, Google, Microsoftã®æã€AIé¢ä¿ã®APIåŠçãå©çšåºæ¥ãŸãã
- FTP - FTPé¢ä¿ã®åŠçå šè¬ãè¡ããŸãã
- ãããŒã³ã³ãããŒã« - æ¬ãããŒå šäœã«æŒããŠãµããããŒããšã©ãŒãã©ãããã³ã¡ã³ããåæ¢ãªã©ã®æ±çšçãªåŠç
èµ€:ãã䜿ããé:䜿ãããšäŸ¿å©ãç·ïŒå¿ èŠãªã·ãŒã³ã¯ããããããšããäºã§è²åãããŠã¿ãŸããããªãããAWSã«å¯Ÿå¿ããŠããããGoogleã®Vision APIç³»ã®ç»åèªèåŠçã翻蚳ãªã©ããŸãJavaScriptãVBSãPythonãExcelãã¯ããå©ãããªã©ãRPAãªã³ãªãŒã§ã¯ãªãã¹ã¯ãªããèšèªãšã®é£æºãšããçµæ§ããããšããã«æãå±ãæãã§çšæãããŠãã®ãGoodã§ãã
ãŸãããŠã§ãã®èªååã¯Seleniumã䜿ããããªã®ã§ããããã¡ãã®åŠçã«é¢ããŠã¯äžèšã®ãµã€ãããŒãã以å€ã«å¥ã«çšæãããŠããŸãã
ã¬ã³ãŒãã£ã³ã°æ©èœ
åè¿°ã®ã¢ã¯ã·ã§ã³ã䜿ã£ãŠããã¥ã¢ã«æäœã§ã¬ãªã¬ãªäœã蟌ãã§ããã®ãå®ç³ãªã®ã§ããããã以å€ã«ãWebã¬ã³ãŒããŒããã³ãã¹ã¯ãããã¬ã³ãŒããŒã®2ã€ã®å€§ããªæ©èœããããŸããããã¯Excelã®ãã¯ãã®ããã«ãŠãŒã¶ã®æäœãèšé²ãããããŒãšããŠèµ·ãããŠãããæ©èœãåè ã¯Seleniumã䜿ã£ãããšããã人ãªãã°çµæ§ããªãã¿ã®æ©èœã§ãããåŸè ã¯ããŠã¹ã«ãŒãœã«ãããŒããŒããªã©ã®äººéã®æäœããããŒãšããŠèšé²ããŠãããŸãã
ãã ããExcelã®ãã¯ãã§ãèšããããšãªã®ã§ãããã¬ã³ãŒãã£ã³ã°æ©èœã¯è²ã ãªèŠä»¶ã§å®ç§ã«åäœã¯åçŸããŸããããããŸã§ãæåã§ãããŒãäœããããæ軜ã«äœããã®ã§ã¢ã·ã¹ãæ©èœãšããŠæããã¬ã³ãŒãããå 容ãåè¿°ã®ã¢ã¯ã·ã§ã³ã§åŸ®èª¿æŽããªããå®æãç®æãããã«ãããŸãããªããWebã¬ã³ãŒããŒã¯Selenium IDEãã®ãã®ãªã®ã§ãChromeã®æ¡åŒµæ©èœã®Selenium IDEã§ãèšé²ããŠå©çšãå¯èœãããããªãã
Webã¬ã³ãŒããŒ
ãããŒäœæç»é¢äžéšã«ãããã¿ã³ã§å®è¡ãããæŒããŠèŠããšã©ã®ãã©ãŠã¶ãèªååãããïŒãéžæã§ãããéžæããããšèªååã®èšé²ãå§ãŸããè©Šãã«ChromeãéžæããŠãèªåã®ãµã€ãã®åãåãããã©ãŒã ã«å ¥åããŠéä¿¡ããŠã¿ã
ãã ããWebã¬ã³ãŒããŒã¯iframeå ã®æäœã¯èšé²åºæ¥ãªãïŒPuppeteerã¯ã§ããã®ã§ããïŒããŸããreCaptchaã¯å¯Ÿå¿ããŠããªãã®ã§ãããèšé²ãããªãã®ã§ãããã¯ç¡ããšããããšãåæã§ãã
- ã€ã³ã¹ã¿ã³ã¹ãæå®ã§Chromeãéžæããã次ãžãã¯ãªãã¯
- ååã¯Power Automate Desktopæ¡åŒµæ©èœã®ã€ã³ã¹ããŒã«ãæ±ããããã®ã§ãGet Extensionãã¯ãªãã¯
- æ¡åŒµæ©èœãæå¹ã«ãããã¯ãªãã¯
- äžåºŠããã§åŠçããã£ã³ã»ã«ããŠããäžåºŠ1.ããå®è¡ãã
- Chromeãšåæã«Webã¬ã³ãŒããŒãèµ·åãã
- èšé²ã®éå§ãã¯ãªãã¯ãããšã¬ã³ãŒãã£ã³ã°éå§ãããããã¯æ éã«æäœãè¡ã
- æåŸã«çµäºãã¯ãªãã¯ãããšãããŒãäœæãããŠãã
- Chromeãéãã
- äžèšã®ããŒã«ããŒã®å®è¡ãã¿ã³ãã¯ãªãã¯ããŠã¿ããšåçŸããã
- äžæžãä¿åãã¿ã³ãæŒããŠããããŒãä¿åããããšãå¿ããã«ã
ãŠã§ã€ãåŠçãã现ãã調æŽãå¿ èŠããªããšæã£ãŠããã®ã§ããããããããã®åŠçãªãã°åŸ®èª¿æŽã¯å šãå¿ èŠããªãããã©ãŠã¶ã®èªã¿èŸŒã¿å®äºãŸã§åŸ ã£ãŠãããããããŒããŒãå ¥åã®ã¹ããŒããéåžžã«é«éã§æ£ç¢ºã§ãããçµæ§äœ¿ãããããããŸããããããã¢ãããã€ã¢ãã°ãåºãå Žåã®åŠçã现ããªãããŒã®ããããã£ã«ãèšèŒãããŠãããããã®ã§ããã®èŸºã¯ãã«ã¹ã¿ãã¯ã§äœããªããšè¡ããªãPuppeteerãããæ軜ãªã®ã¯ééããããŸããã
å³ïŒäž»èŠãª4çš®é¡ã®Webãã©ãŠã¶ã«å¯Ÿå¿
å³ïŒæäœã®èšé²äžã®æ§å
å³ïŒèªåäœæããããããŒ
å³ïŒçŽ°ããªãªãã·ã§ã³ã¯åãããŒãããã«ã¯ãªãã¯ã§èšå®å¯èœ
ãã¹ã¯ãããã¬ã³ãŒããŒ
å®ã¯ä»¥åãMicrosoft Flowæ代ã«äžåºŠäœ¿ã£ãäºãããã®ã§ãããã¡ãã£ãšç²ŸåºŠãæªããŠãã¡ãã®æ©èœã¯ãŸã ãŸã ã ãªãšæã£ãŠããæ©èœã§ãããããããã±ããããŠã¹ããmacOSã®Automatorãªã©ãè¡ã£ãŠããžã£ã³ã«ã§ãããéåžžã®ã¢ããªãèµ·åããããŠã¹ãããŒããŒãã§ã®æäœãèšé²ããåçŸããæ©èœãªã®ã§ãããã¢ãã¿ãŒè§£å床ãããŠã¹åº§æšããŸãäŸå€åŠçãªã©è²ã èæ ®ããªããã°ãªããªãé ç®ãå€ãã®ã§ãWebèªååãããé£æ床ã¯é«ãã§ãã
ãããŒäžéšã«ãããã¹ã¯ãããã¬ã³ãŒããŒãã¯ãªãã¯ããŠèšé²ããŸããä»åã¯èªäœã®ãšããããŒã«ã§2ã€ã®ãã¡ã€ã«ãèªã¿èŸŒãŸããŠãä»èŸŒãã§ããããã¯ããå®è¡ãããšããåçŽãªãã®ããã£ãŠã¿ãããšæããŸãã
- ãã¹ã¯ãããã¬ã³ãŒããã¯ãªãã¯ãã
- ãã¹ã¯ãããã¬ã³ãŒããèµ·åããã®ã§ãèšé²ã®éå§ãã¯ãªãã¯ãã
- èªåã®ãã¯ãã®å ¥ã£ãxlsmãã¡ã€ã«ãèµ·åãã
- èªäœã®ãªãã³ã®ã³ãã³ãã䜿ã£ãŠãã·ãŒãã2æèªã¿èŸŒãã§ãåŠçãå®è¡ãæåŸã«çµäºã¡ãã»ãŒãžãã¯ãªãã¯ããŠéãã
- æåŸã«ãã¹ã¯ãããã¬ã³ãŒãã®çµäºãã¯ãªãã¯ãã
éåžžã«åçŽãªåŠçã§ãããExcelã«ã¯ãã¯ããå ¥ã£ãŠãããã¡ãã§è€éãªåŠçã¯ããããŠããŸããäœã£ãŠã¿ãææ³ã§ãããçµæ§ã¯ã»ã匷ããããããŸãããããã®åçŽãªåŠçã§ã¯ä»¥äžã®2ç¹ã«æ³šæããã°ãã¡ããšå®è¡ããŠæ£ç¢ºã«å®äºããããšãåºæ¥ãŸããã
- æäœèšé²äžã«å¥ã®ãŠã£ã³ããŠãªã©ãã¯ãªãã¯ãããããŠåŠçãéã«æãŸãªã
- èšé²ããæã¯ããã€ãã€æ¬¡ã®ããŠã¹æäœãããã®ã§ã¯ãªããèµ€ãæ ããã¡ããšãã®ã¢ã€ã³ã³ããã¿ã³ãææãããŸã§åŸ ã£ãŠããã¯ãªãã¯ããããšïŒCtrl+ã¯ãªãã¯ã§ãïŒ
- èªäœã®ãªãã³ã¿ãã¯ãã¡ããšææããŠãããŸããã
- ã¿ãã®ã¢ã€ã³ã³ãã¯ãªãã¯ãããšããã¡ã€ã«éžæãã€ã¢ãã°ãåºãŸããããã¡ãã2.ããã¡ããšæèããŠäžåãã€äžå¯§ã«åäœããããŠèšé²ããŸãã
- ãã¹ã¯ãããã«é 眮ãã2ã€ã®ãã¡ã€ã«ãéžæåŸãã·ãŒãã«åã蟌ãŸããæåŸã«ã¡ãã»ãŒãžããã¯ã¹ãåºãã®ã§ãããããã2.ãæèããŠãã¿ã³ãã¯ãªãã¯ããã°ãã¡ããšãããã¢ããã¡ãã»ãŒãžãéããäºãå¯èœã§ã
ç¹ã«åŸ®èª¿æŽãæœãããšãªããExcelãã¯ããå®è¡ããŠãã¡ã€ã«ãåã蟌ã¿åŠçãŸã§è¡ãããäºãã§ããŸããã以å䜿ã£ãæãããé¥ãã«ç²ŸåºŠã¯äžãã£ãŠãããšèšãããšæããŸãã
ãŸããPower Automate Desktopã¯JavaScriptãPythonãVBSãããã«ã¯Excelã®ãã¯ããçŽæ¥å®è¡ã§ããç¹ãããè€éãªåŠçã¯ãRPAã§ã¯ãªããããã¹ã¯ãªããã«ããããŠãå šäœã®å€§ããªåŠçã®ãããŒãRPAãšããŠæ§ç¯ããã®ãæ£ãã䜿ãæ¹ãšãããŸããå šãŠãRPAã§è¡ãããã®ã¯ãã¡ã³ããã³ã¹é¢ãå®è¡ç¢ºå®æ§ã®èŠ³ç¹ãããæçã§ããç°¡åãªåŠçã ã£ããåé¡ãªãã§ãããExcelã®æäœã¯VBAãäžçªç¢ºå®ã«åŠçãè¡ã£ãŠãããŸãã
ïŒä»åã®2ã·ãŒãåã蟌ã¿ãšãã®åŸã®åŠçã¯RPAã§çµãã«ã¯æ¡ä»¶åå²ãé ååŠçãã«ãŒãåŠçãããã®ã§ãäœã蟌ããšåŸã倧å€ã§ãïŒ
â»VMware Fusionå ã§Power Automate Desktopã§UIFlowã®ã¯ãªãã¯ææã¯ãControl+Command+ã¯ãªãã¯ã«ãªãã®ã§æ³šæ
å³ïŒãã¹ã¯ãããèšé²ãåºæ¬ã¯åã
å³ïŒçŽ°ããªèª¿æŽããã¡ããå¯èœ
ã¡ãã£ãšãããã¯ããã¯
Power Automate Desktopã¯ãŸã äžè¬ã«ç¡åå ¬éãããŠããéããªãçºãããã€ããããã¯ã©ããããè¯ãã®ãïŒããšããã·ãŒã³ããããŸãããããŸã§Twitterãªã©ã§ãã€ãŒããããŠãããã®ãªã©ãå ã«æ€èšŒãããŠã¿ãŸããã
ã¢ã¯ã·ã§ã³ã¯ã³ããããŠããã¹ãä¿åãã§ãã
Power Automate Desktopã«æ§ç¯ããåã ã®ã¢ã¯ã·ã§ã³ã§ãããä»ã§ãæµçšããããšæã£ãŠãã©ããããè¯ãã®ãïŒåããããŒå ãªãã°å³ã¯ãªãã¯ã§ã³ãããåºæ¥ãŸãããå®ã¯ããã³ããŒãããšãããã®ã§ãããRobinèšèªãã®ãã®ãã³ããŒãããŠããŸãã以äžã®ãããªãã®ãã³ããŒãããŠããããã§ãã
CtrlããŒã§è€æ°ãŸãšããŠã³ããŒããŠãããŸããããããã¹ããšãã£ã¿ãªã©ã§ãããŒãä¿åããŠããäºãå¯èœã§ãããã£ãŠãä»ã®ãããŒã«å¯ŸããŠã³ããŒãããã®ãæã£ãŠããããšãå¯èœã§ãããªãããPower Automate Desktopäžã§ã¯ãã®ãããŒèªäœãè€è£œããæ段ããªãã®ã§ããããããŒã¯Webçã®ã»ããããå šãåããããŒãè€è£œããããšãå¯èœã§ãïŒæåãã©ã³ã®ã¿ïŒã
1 2 3 4 5 6 |
@@timestamp: '2021-03-03T02:35:46.6377841Z' WebAutomation.FormFilling.PopulateTextField BrowserInstance: Browser Control: appmask['Recording']['input 3'] Text: 'ãã¹ã' @@timestamp: '2021-03-03T02:35:52.8587063Z' WebAutomation.FormFilling.PopulateTextField BrowserInstance: Browser Control: appmask['Recording']['textarea'] Text: 'ãã¹ãã ã' @@timestamp: '2021-03-03T02:36:13.0894470Z' WebAutomation.FormFilling.PressButton BrowserInstance: Browser Control: appmask['Recording']['input 4'] |
çŸåšãç¡åçã§ã¯ä»äººãšå ±æããããšæã£ãŠããã®ãŸãŸã§ã¯å ±æã¯åºæ¥ãªãã®ã§ãããäžèšã®ããã«ã³ãŒãã§åã£ãŠãããã®ã§ãäžè¬å ¬éãããå Žåããä»äººã«é åžãããå Žåã¯ãããã¹ãã®åœ¢ã§é åžããå©çšè ã¯ã³ãããããã°ã¢ã¯ã·ã§ã³ã埩å ããäºãå¯èœã§ããGithubãªã©ã䜿ãã°ãã³ãŒãã®ä¿ç®¡ãå·®å管çãåºæ¥ãã®ã§ã¯ãªãããšæããŸãã
Power Automate Desktopãžã®è²Œãä»ãã¯æ®éã«äžèšã®ã³ãŒããCtrl+Vãå®è¡ããã ãã
â»äœãã³ããã§ããã®ã¯ããããŒã ããUIèŠçŽ (Ctrl+ã¯ãªãã¯ãªã©ã§ã¢ããªã®ããã¹ãããã¯ã¹ãªã©ã®å Žæã®æ
å ±ïŒãªã©ã¯ããããŒå
ã«ã¯ãªããappmaskã®ã»ãã«å
¥ã£ãŠããŸã£ãŠãã®ã§ãã³ããåºæ¥ãŸããããªãã¹ããUIèŠçŽ ã«é ŒããªããããŒãäœããŸããããïŒ2021/04ã®ã¢ããã§ãUIèŠçŽ ã®ã³ãããã§ããããã«ãªããŸããïŒ
äœãããããã®ã¯ #Robin ã§èšè¿°ãããœãŒã¹ã³ãŒãããã®ãŸãŸPower Automate Desktopã«è²Œãä»ããã¢ã¯ã·ã§ã³ãšãªãå®è¡ã§ããããšã§ãã
ããã«ãã #PowerAutomateDesktop ã®éçºã¯ã³ãŒãã£ã³ã°ã§è¡ããå¯èœæ§ãããããŸããã³ãŒãã§ã®ç®¡çãå·®åãã§ãã¯ãè¡ãããšãã§ããã®ããªãšæåŸ ããŠããŸãã https://t.co/zEgFZbiwaS pic.twitter.com/STNmbY7q6qâ Maekawa (@HiMaekawaSan) September 30, 2020
äœæãããããŒã¯OneDriveã«ä¿åãããŠã
éåžžã®Microsoftã¢ã«ãŠã³ãã®å ŽåãäœæãããããŒã¯OneDriveã®äžã®ãã¢ããªãâãPower Automate for Windowsãã®ãã©ã«ãã®äžã«ä¿åãããŠããããã§ãããã ããã¡ã€ã«åã¯ã©ã³ãã ãªæ°åã§ããã¡ã€ã«ã®äžèº«ã¯Base64ã§ãšã³ã³ãŒããããŠæåååãããŠãããã¡ã€ã«ã§å ±æãããããã¯ã¢ããïŒãšããã®ã¯é£ããã¿ããã
æåã®Microsoft365ã¢ã«ãŠã³ãã®å ŽåãDataverseãšããPower Platformã®ããŒã¿ããŒã¹å ã«åæ§ã«ä¿åãããŠããããã§ãããã®ãã¡ã€ã«ã¯ããããRobinãšããèšèªã§æžããããããŒã®ã³ãŒããæ ŒçŽãããŠããã®ã§ã¯ãªãããšè©±ãå®è¡æã«Power Automate Desktopã«ãã£ãã·ã¥ãããŠå®è¡ãããŠãããã§ãã
å³ïŒãã¡ã€ã«ã§ããåãã§ãããããã®ã«ã
ãã£ãã·ã¥ããããã¡ã€ã«ã«ã€ããŠ
Power Automate Desktopã§äœæãããããŒãå®è¡ãããšã以äžã®ãã©ã«ãã«ãã£ãã·ã¥ãããŠå®è¡ãããŠãããã§ããããã«ã¯æ¡åŒµårobinãšãããã¡ã€ã«ãçæãããŠãããããã¯robin editorã«ãŠéããããã«ãªã£ãŠããŸãã
1 2 |
//ãã£ãã·ã¥ãããŠããã©ã«ãã®å Žæ %USERPROFILE%\AppData\Local\Microsoft\Power Automate Desktop\Console\Workspace |
ãã ããRobin Editorã§å®è¡ããŠãåãã±ãŒã¹ãšãPower Automate Desktopã§ãªããšåããªãã±ãŒã¹ãããã100%äºæã§ã¯ãªããããŒã¹ãšããŠæ¡åŒµãããŠããããšããäºã§ã察å¿ããŠããªãå Žåã倧ãã«ãããŸãïŒOCRé¢ä¿ãªã©ç¹ã«ïŒ
å³ïŒå®è¡æã«ãœãŒã¹ã³ãŒãããã£ãã·ã¥ããã
å³ïŒRobin Editorã§éããŠã¿ã
çŽæ¥ä»ã®EXEãå®è¡ãããã¯ããã¯
Power Automate Desktopã®ã¢ã¯ã·ã§ã³ã®äžã«ã¯ãEXEããã«ãã¹æå®ã§å®è¡ãããšãã£ããããªã¢ã¯ã·ã§ã³ã¯ãããŸãããçšæãããŠãæ段ã§äœ¿ããããªã®ããVBSå®è¡ãPowerShellå®è¡ãDOSã³ãã³ãå®è¡ã®3ã€ã
VBSã§å®è¡ã¯ããã¡ãã®ã³ãŒãã䜿ã£ãŠãã£ãŠã¿ããšãã
- ããã¥ã¡ã³ããã©ã«ã以äžã®EXEã§ããã°èµ·åããäºãã§ãã
- ããããProgramãã©ã«ã以äžã®EXEã¯èµ·åã«å€±æããïŒç®¡çè æš©éãå¿ èŠïŒïŒ
DOSã³ãã³ãå®è¡ã®å Žåããã®ãŸãŸã§ã¯åãçµæã ã£ãã®ã§ããã察象ã®EXEã®ã·ã§ãŒãã«ããããã¹ã¯ãããã«äœã£ãŠãããDOSã³ãã³ãã®å®è¡ã§ä»¥äžã®ããã«ãããšèµ·åãããããšãåºæ¥ãŸããã
- start "dummytitle" "ãã¹ã¯ãããã®lnkãžã®ãã«ãã¹"
ãã®å ŽåãDOSçªã§startã³ãã³ãã«ãŠlnkãå©ããŠãã ããªã®ã§ãç¡äºã«Programãã©ã«ã以äžã®ããã°ã©ã ã§ãèµ·ååºæ¥ãŸããã
ãããŒã®äžããä»ã®ãããŒãå®è¡
䜿ãéããããã©ããããããŸããããPower Automate Desktopã®ãããŒã®äžãããå¥ã«äœã£ãŠãããããŒãåŒã³åºãäºãå¯èœã§ããæé ã¯ä»¥äžã®éãã
- ãŠã£ã³ããŠå ã®ãã¿ã³ãæŒãã¢ã¯ã·ã§ã³ãè¿œå ãã
- ããã«ã¯ãªãã¯ã§ç·šéãã
- UIèŠçŽ ãã®ããããããŠã³ãã¯ãªãã¯ãã
- æ°ããUIèŠçŽ ã®è¿œå ãã¯ãªãã¯
- Power Automate Desktopã®ãããŒäžèŠ§ç»é¢ãåºããCtrlããŒãæŒããªããããã®ãããŒã®å®è¡ãã¿ã³ãã¯ãªãã¯
- å®äºãã¯ãªãã¯
- 3.ã®äžèŠ§ãã5.ã§è¿œå ããèŠçŽ ãæå®ãã
- ãããŒãå®è¡ãããšãPower Automate Desktopã®5.ã§æå®ãããããŒãå®è¡ããŠããã
å³ïŒUIèŠçŽ ã®è¿œå ã§ãããŒäžèŠ§ã®ãã¿ã³ãè¿œå
PowerShellã䜿ã£ãŠååæå®ã§ãããŒãå®è¡
ãã¬ããæ°ãPowerShell + UI Automationãå©çšããŠãååãæå®ããŠç¹å®ã®ãããŒãå®è¡ããæ段ãéçºãããŸãããps1ãå©ãã ãã§å®è¡åºæ¥ãã®ã§ãã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©çãå©çšããã°ãæéå®è¡ãå¯èœãªã®ã§ã¯ãªãããšæããŸãã
[Power Automate Desktop]ååãæå®ããŠãããŒãå®è¡ããPowerShellã¹ã¯ãªãã
UWSCã䜿ã£ãŠãããŒãå®è¡
次é ã«ããRobin.exeãšäŒŒãŠããã®ã®ããã£ãšæ軜ã«ä»ã®EXEãããããŒãå®è¡ãããïŒãšãªã£ãå Žåãå€ãã䜿ãããŠããUWSCã䜿ã£ãŠãPower Automate Desktopèªäœãæäœããäºãå¯èœã§ããä»åãç¹å®ã®ãããŒãæå®ããŠUWSCã§äœæãããEXEã䜿ã£ãŠå®è¡ã®ã§ããPadFlowRun.exeãè©ŠããŠã¿ãŸããã
䜿çšæé ã¯ä»¥äžã®éãã§ãã
- ãã¡ãã®ãµã€ãããPadFlowRunãããŠã³ããŒããã
- 解åããããšãEXEãå ¥ã£ãŠãã®ã§ãå®è¡ããŠã¿ãã
- ã¡ãã»ãŒãžãã§ãã®ã§ãã¯ãããã¯ãªãã¯ãããšåŒã³åºãã³ãã³ãã©ã€ã³ãã¯ãªããããŒãã«ã³ããŒããã
- äŸãã°ãããã¹ããšãã£ã¿ã«è²Œãä»ããŠããããŒåã ããèªåã®PADã®ãããŒåã«æžãæããŠãæ¡åŒµåBATã§ä¿åãã
- å®è¡ãããšPadFlowRunãPADäžã§æ€çŽ¢ãã該åœã®ãããŒãèªåå®è¡ããŠãããŸãã
ä»ã®ããã°ã©ã ããç°¡åã«PADãåŒã³åºããŠå®è¡ãã§ããã®ã§ãäŸãã°ã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ã«ç»é²ããŠåŒã³åºããšãã£ãäºãå¯èœã§ãã
- Windows10ã®æ€çŽ¢çªããã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ãå®è¡ãã
- ã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ã©ã€ãã©ãªãã¯ãªãã¯ãã
- å³åŽã®ãåºæ¬ã¿ã¹ã¯ã®äœæããã¯ãªãã¯ãã
- ååãé©åœã«ã€ããŠã次ãžé²ã
- ããªã¬ãŒã¯ä»åãæ¯æ¥ããæå®ããŠã¿ãŸãã次ãžé²ã¿ãŸãã
- éå§ããæ¥æãæå®ãééã¯1æ¥ã次ãžé²ã¿ãŸãã
- æäœã§ã¯ãããã°ã©ã ã®éå§ãæå®ããŸãã
- ããã°ã©ã /ã¹ã¯ãªãããæå®ããŸããäŸãã°åé ã§äœã£ãBATãæå®ããããPadFlowRun.exeãæå®ããŠãåŒæ°ã«ãããŒåãæå®ãããããŸãã次ãžé²ã¿ãŸãã
- å®äºãã¯ãªãã¯ããŸãã
- ããã§ãã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ã§å®è¡ãããŸãã
现ããã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ã®çºç«ã¿ã€ãã³ã°ãæå®ããã°ãPADã極ããŠçŽ°ããæè»ã«å®è¡ãããäºãå¯èœã«ãªããŸãã
å³ïŒEXEãäžåã®ã·ã³ãã«ãªããã°ã©ã ã§ã
Robin.exeã§Power Automate Desktopã®ãããŒãå®è¡
Power Automate Desktopããªãããã®æ段ã§çŽæ¥å¯Ÿè±¡ã®ãããŒãä»ããå®è¡ããããªãšæããšãåœç¶Power Automate Desktopã§ã¯äœããŸãããããããRobin Editorã§äœã£ããããŒããã¯åŒã³åºããã®ã§ã以äžã®ãããªåœ¢ã§ãRobin Editorã§ãããŒãäœã£ãŠãPower Automate Desktopã®ç¹å®ã®ãããŒãå®è¡ã§ããããã«ããŠã¿ãŸããã
â»äœããPower Automate Desktopã®æ£åŒãªãªãŒã¹ã«äŒŽããµã€ãã¯æ¶æ» ããŸãã
- Robin UI Spyãèµ·åãã
- Add Controlãã¯ãªãã¯
- CtrlããŒãæŒããªããPower Automate Desktopã®ç¹å®ãããŒã®å®è¡ãã¿ã³ãã¯ãªãã¯
- å³äžã®ååãä»åã¯calcmanãšããŠä»ããŠãwinman.appmaskãšããŠä¿å
- Robin Editorãèµ·åãã
- 以äžã®ãããªã³ãŒããèšè¿°ããŠãscript.robinãšããŠä¿åãã
- Power Automate Desktopãèµ·åããŠãã
- DOSçªãéããŠãrobin.exe run script.robinãå®è¡ãã
å®è¡ãããšãèµ·åããŠãPower Automate Desktopã®ç¹å®ã®ãããŒã®å®è¡ãã¿ã³ãæŒãããŠãPADåŽã§ã®ãããŒãçºç«ããŸãã
â»ã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ãªã©ã§ãã®8.ã®DOSçªã³ãã³ããBATãã¡ã€ã«ã«ã§ãããŠããã°ãRobinããPADã®ãããŒãæéçºç«ãããäºãã§ããã®ã§ã¯ãªãããªããšæåŸ
1 2 3 |
IMPORT 'winman.appmask' AS appmask UIAutomation.Click Element:appmask.calcman.Button ClickType: UIAutomation.ClickType.DoubleClick OffsetX: -15 OffsetY: -10 MousePositionRelativeToElement: UIAutomation.RectangleEdgePoint.MiddleCenter |
å³ïŒappmaskãäœæããŠãæ§å
å³ïŒRobinã§ãããŒãæåã§æ§ç¯ãã
å³ïŒrobin.exeã§å®è¡ããŠãããŒãå®è¡
ãããªæãã«ã³ãã³ãã©ã€ã³ããå®è¡ãã
ããªã»ã«ã³ãã®ãŠã§ã€ããå ¥ããã
Power Automate Desktopã§ããåŠçã®åã«ãŠã§ã€ããå ¥ãããå ŽåãçŸåšã¯æå®ã§ããã®ããç§ãåäœã§ããç°å¢ã«ãã£ãŠã¯ããã ãšã¡ãã£ãšé ããªããšæãã·ãŒã³ãããã§ãããã
ãã®å¯Ÿçã§ãããæå³ã®ãªãããŒã®éä¿¡ã¢ã¯ã·ã§ã³ãå ¥ããäºã§ãæšæºã®ãŠã§ã€ãã®ä»£ããã«ããªã»ã«ã³ãåäœã§ã®ãŠã§ã€ããå®çŸå¯èœã§ããæå³ã®ããããŒã ãšããã¹ããå ¥åãããããã³ãã³ããå®è¡ãããŠããŸãã®ã§æ³šæã
ãã®ãã¯ããã¯ã䜿ãäºã§0.5ç§ã®ãŠã§ã€ãçãå®çŸã§ããã°æšæºãããæ©ãã¢ã¯ã·ã§ã³ãå®è¡ã§ããã®ã§åŠçæéã®ççž®ãåºæ¥ãŸãã
å³ïŒæå³ã®ãªãããŒã§ãŠã§ã€ãã代æ¿
ããã¹ã眮æã§ç©ºçœã䜿ããã
ãããããªããã°ã©ã ã®ã³ãŒãã£ã³ã°ã§ããå€ãäžæžãã§ã¯ãªãã空çœãã§çœ®ãæããããšã¯çµæ§ãããŸããå ¥ã£ãŠãå€ã空ã«ããããããªã®ã§ãããPower Automate Desktopã ãšç©ºã®ãŸãŸã ãšãããŒãä¿ååºæ¥ãŸããã
眮ãæãå ã®ããã¹ãã«ã¯ã%''%ããšã·ã³ã°ã«ã³ãŒããŒã·ã§ã³ã®ç©ºæåã%%ã§æ¬ã£ããã®ãæå®ããããšã§ã空ã§çœ®ãæããããŸãã
以äžã®ãããªãããŒã®å Žåãå ã®å€æ°ã®ããšãããããçå Žããšããå€ã¯ãçå Žéšåã空ã§çœ®ãæããã®ã§ãã¡ãã»ãŒãžã«ã¯ããšããããããã ãã衚瀺ãããŸãã
å³ïŒç°¡åãªçœ®æã®ãããŒ
å³ïŒçœ®ãæããã«ã¯ç©ºã®å€æ°ã䜿ã
ã·ã§ãŒãã«ããããŒãéä¿¡ããã
RPAãšèšã£ãŠããããããããŠã¹æäœããŽãªãŽãªèšæ¶ããæ¹æ³ã ãšéåžžã«ã¡ã³ããã³ã¹æ§ãæªãã ãã§ãªãã確å®æ§ã«å£ãããŸãã¹ããŒããé ããªããŸãããã®å ŽåãããŠã¹æäœã§ã¯ãªãããŒããŒãæäœãçµã¿åãããããšã§ããã€ã¬ã¯ãã«ãã®æ©èœãåŒã³åºãããå®è¡ãã§ããã®ã§ãææ°ã®åæžã«ãªããŸãã
éåžžããŒã®éä¿¡ã§ã¯ãããã¹ãå ¥åæ¬ã«å ¥åãããå 容ãéããã®ã§ãããããŒã³ãŒãã®éä¿¡ãå¯èœã§ãããŸããè€æ°ã®çµã¿åãããããŒã§ãããã·ã§ãŒãã«ããããŒããéããã®ã§ãå°å·ã§ãã£ããããã°ã©ã ã®çµäºãªã©ã®Ctrl+PããAlt+F4ãªã©ã®ããŒãéãäºãå¯èœã§ããAlt+F4ãéã蟌ã¿ããã®ã§ããã°ã以äžã®ãããªã³ãŒããéä¿¡ããããã¹ãã«èšå ¥ããŸãã
{Alt}({F4})
èŠããŸãŸãªã®ã§ããã@ããŒã¯ãªã©ã®ç¹æ®æåã¯ãã®ãŸãŸã§ã¯å ¥ããããã{Oem3}ã@ããŒã¯ã«ãªããŸããEnterãªã©ã¯ãã®ãŸãŸ{Enter}ã§ããæŒãããŸãŸå¥ã®ããŒãšãªã£ãå Žåãäºåç®ã®ããŒãïŒïŒã§æ¬ãã°ãããã§ã·ã§ãŒãã«ããããŒãšãªããŸãã
ç¹æ®ãªããŒã¯ãã¡ãã®ä»®æ³ããŒäžèŠ§ãåèã«ãããšçµã¿ç«ãŠããããªãã®ã§ã¯ãªãããšæããŸãã
å³ïŒããŠã¹æäœãèšé²ããã°è¯ãã£ãŠãããããªã
URL Schemeã掻çšãã
äžèšã®ããŒã³ãŒãéä¿¡åæ§ããŠã§ããªã©ã®ã¢ããªïŒããŒã«ã«ã¢ããªãã ããã©ïŒã«ã¯URL SchemeãšåŒã°ãããã®ãååšããŸããäŸãã°Teamsãèµ·åããŠæäœãããå Žåãé·ã ãšãããããŒãäœæããŠäººãæ¢ããŠãªããŠãã£ãŠãããéåžžã«é¢åãããã®ã§ããã§ãURL Schemeã掻èºããŸããä»åã¯ãã¹ã¯ãããçã®Teamsãèµ·åãã察象ã®ã¢ãã¬ã¹ã®äººãåŒã³åºããã¡ãã»ãŒãžã®å ¥åãŸã§ããã£ãŠã¿ãŸãããéåžžã«ç°¡åã§ãã
- Power Automate Desktopã§ãããŒãäœæãã
- ãããŒã«ãVBScriptã®å®è¡ãè¿œå ããã
- ããã«ã¯ãªãã¯ããŠã以äžã®ã¹ã¯ãªãããèšè¿°ãã
- å®è¡ãããšããã€ã¬ã¯ãã«ãã®äººãšã®ãã£ããç»é¢ãç«ã¡äžãããã¡ãã»ãŒãžãå ¥ã£ãç¶æ ã«ãªããŸãã
ãã®1ã¿ãŒã³ã ãã§ãTeamsã®å¯Ÿè±¡è ã®ãã£ããå ¥åæ¬ã衚瀺ããŠã¡ãã»ãŒãžãŸã§å ¥ããç¶æ ã«é·ç§»åºæ¥ãŸããããŠã¹ã§ãã£ãŠãã倧å€ãªäºã§ããåŸã¯éä¿¡ãã¯ãªãã¯ããã¢ã¯ã·ã§ã³ãå ¥ããã°ããã§ãTeamsã§ã¡ãã»ãŒãžãéä¿¡åºæ¥ãŸããèªäœã®ã¢ããªã«URL SchemeãæèŒããã°ãåæ§ã®äºãå®çŸå¯èœã§ãã
ãã¡ãããhttps://ããå§ãŸãURLã§ãåæ§ã®äºãå¯èœã§ãã
1 2 3 |
Dim ws Set ws = WScript.CreateObject("WScript.Shell") ws.Run "msteams:/l/chat/0/0?users=ããã«ã¡ã¢ã&message=ããã«ã¡ãã»ãŒãž" |
å³ïŒãããŒã®äžã€ãšããŠäœ¿ããŸã
Python3ã¹ã¯ãªãããå®è¡
çŸåšãPower Automate Desktopã¯ãªãããPython 2.xç³»ã®ã¹ã¯ãªããããå®è¡ããäºãåºæ¥ãŸããããã§ã«ããPython 2.xã¯é·ãæŽå²ã«çµæ¢ç¬Šãæã£ãŠãµããŒãçµäºæžã¿ãªã®ã§ããããã®ãããçŸåšäž»æµã®Python 3.xç³»ã¯ã¢ã¯ã·ã§ã³ããåŒã³åºãã«ã¯ãã³ãã³ãã©ã€ã³ãPowerShellãªã©ã䜿ã£ãŠåŒã³åºãããšã«ãªããŸãã
以äžã®ãããªPython3ã¹ã¯ãªãããå®è¡ããŠã¿ãŸãã
â»Pythonã¯æ§ã ãªã©ã€ãã©ãªã®ãããã§åŒ·åãªèªååãå®çŸã§ããã¹ã¯ãªããèšèªãªã®ã§ãRPAã§ç¡çã«äœããPythonã§åŠçãããããŠä»ãžã®æ©æž¡ãã«Power Automate Desktopã掻çšãããšæå¹æŽ»çšã§ããã§ãããã
1 2 3 4 5 6 7 8 9 |
from tkinter import messagebox def world(): messagebox.showinfo("test", "æ¹è¶ã飲ã¿ãã") strings = 'Hello, World!' print(strings) return world() |
test.pyãšããŠãã¹ã¯ãããã«é 眮ãããã®ã¹ã¯ãªããã®å®è¡çµæã¯ãstringsãšããŠprintããããã®ãè¿ãå€ãšããŠåãåããŸããã³ãŒããšããŠã¯ä»¥äžã®ãããªã³ãŒãã«ãªããŸãã
1 2 3 4 |
Folder.GetSpecialFolder SpecialFolder: Folder.SpecialFolder.DesktopDirectory SpecialFolderPath=> SpecialFolderPath SET NewVar TO $'''%SpecialFolderPath%\\test.py''' System.RunPowershellScript Script: $'''python %NewVar%''' ScriptOutput=> PowershellOutput ScriptError=> ScriptError Display.ShowMessageWithTimeout Title: $'''è¿ãå€''' Message: PowershellOutput Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: True Timeout: 3 ButtonPressed=> ButtonPressed |
å³ïŒãããªæãã§åŒã³åºããŠåºåãåãåã
åã€ã³ã¹ããŒã«åŸã«ãšã©ãŒé »çº
åã€ã³ã¹ããŒã«åŸã«äœåºŠãããŒãäœã£ãŠä¿åããããšããŠãããThe cache contains multiple tokens satisfying the requirements. Try to clear token cacheããšãã£ããããªãšã©ãŒãåºãŠä¿ååºæ¥ãªãã±ãŒã¹ããããŸãããã£ããäœã£ãã®ã«ä¿åã§ããåç¶ãšããŸããèªåã®å Žåãå çšã§ãŸããããå床äœã£ãå Žåãã¡ããšä¿ååºæ¥ãŸããããã¡ãã£ãšå ·åãæªãã§ããã
ã³ãã¥ããã£ã®å ±åã«ãããšãããã¯åã€ã³ã¹ããŒã«ãããã¯æ°çã§äžæžãã€ã³ã¹ããŒã«ããå Žåã«ãLocalAppData以äžã®PADãã©ã«ãå ã«ãŽããæ®ã£ãŠãã®ãåå ã®ãããªã®ã§ãã¢ã³ã€ã³ã¹ããŒã«ã該åœã®ãã©ã«ããåé€åŸã«åã€ã³ã¹ããŒã«ã§è§£æ¶ããããã§ãã
該åœã®ãã©ã«ãã§ãããã¢ã³ã€ã³ã¹ããŒã«åŸã«
- ãšã¯ã¹ãããŒã©ãèµ·åãã
- ãã¹ã®æã«ã%LocalAppData%\Microsoft\Power Automate Desktopããå ¥å
- ãã®äžã«ãããã¡ã€ã«ãåé€ããŠãåã€ã³ã¹ããŒã«
- ãã°ã€ã³ãçŽã
ããŒã¿ãã®ãã®ã¯ã¯ã©ãŠãäžã«æ®ãããŠãã®ã§ããã°ã€ã³ã§ããã°åŸ©å ãããŸãããã®ãšã©ãŒä»¥å€ã§ããObject reference not set to an instance of an object.Errorãšãã£ããšã©ãŒã§ãåæ§ã®å¹æãããããã§ãã
å³ïŒå€ãªãšã©ãŒãçµæ§åºã
ZIP解åã§æ¥æ¬èªæååã
PADã«ãã¡ã€ã«ã®è§£åãšããã¢ã¯ã·ã§ã³ããããŸããããããZIP解åã®ã¢ã¯ã·ã§ã³ã«ãªããŸããããããå®éã«ããããŠã¿ããšæ¥æ¬èªãã¡ã€ã«ãæååãããŸããããããå éšçã«æåã³ãŒãã®åŠçããªã«ã·ã€ãšããããŒã«ã©ã€ãºäžã®ããããåé¡ããšããããããã§ã¯å©çšè åŽã¯å°ãã®ã§ã7zipã®ã³ãã³ãã©ã€ã³çã䜿ã£ãŠè§£åã§ããããã«çµãã§ã¿ãã
äºãã7zipã³ãã³ãã©ã€ã³çãããã¥ã¡ã³ãçŽäžã®7zãã©ã«ãå ã«é 眮ããŠã7za.exeãžã®ãã«ãã¹ãååŸããŠãããŸãã
- ç¹å¥ãªãã©ã«ããŒååŸã§ããã¹ã¯ããããååŸãããããŒãè¿œå ïŒdesktoppathã§èšå®ïŒ
- å€æ°ãèšå®ã§ããã¹ã¯ãããã«ããzipãã¡ã€ã«ã®ãã«ãã¹ã1.ãšçµã¿åãããŠè¿œå ïŒzipfileã§èšå®ïŒ
- DOSã³ãã³ãã®å®è¡ã«ãŠãã7za.exeãžã®ãã«ãã¹ x -y -o%desktoppath%\zipman %zipfile%ããšãã£ãã³ãã³ãã©ã€ã³ãè¿œå ïŒzipmanãã©ã«ãã«åŒ·å¶è§£åïŒ
- IFæãè¿œå ããCommandErrorOutputã空ã®å Žåã¯æåããã¡ãã»ãŒãžã衚瀺ããããã§ãªãå Žåã¯CommandErrorOutputã®å 容ãã¡ãã»ãŒãžã§è¡šç€ºãããšã©ãŒãã©ãããè¿œå
ãœãŒã¹ã³ãŒããšããŠã¯ä»¥äžã®ããã«ãªããŸãããã¡ãããã¹ã¯ãŒãä»ãã解ååºæ¥ãŸããã7z圢åŒãè¡ããŸãã
1 2 3 4 5 6 7 8 |
Folder.GetSpecialFolder SpecialFolder: Folder.SpecialFolder.DesktopDirectory SpecialFolderPath=> desktoppath SET zipfile TO $'''%desktoppath%\\nodepj.zip''' System.RunDOSCommand DOSCommandOrApplication: $'''ããã«7za.exeãžã®ãã«ãã¹ x -y -o%desktoppath%\\zipman %zipfile%''' StandardOutput=> CommandOutput StandardError=> CommandErrorOutput ExitCode=> CommandExitCode IF IsEmpty(CommandErrorOutput) THEN Display.ShowMessage Title: $'''ã¡ãã»ãŒãž''' Message: $'''解åãå®äºããŸãããâ€''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed ELSE Display.ShowMessage Title: $'''ãšã©ãŒ''' Message: CommandErrorOutput Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2 END |
å³ïŒexcelãã¡ã€ã«åãæååããŠã
å³ïŒ7zipã¯ããããªè§£åã§ãã
æåã®ãã©ã³ã§äœ¿ã£ãŠã¿ã
ä»åã®ç¡ååã§Power Automate Desktopã®äž»èŠãªæ©èœã¯èª°ã§ãä»ããå©çšå¯èœã«ãªããŸããããæåã®ãã©ã³ïŒMicrosoft365ã®Enterpriseãåç¬ã§Power Automateãå¥çŽããŠãæ¹ã ïŒã«ã ãå©çšã§ããæ©èœãšãããã®ããããŸãããµã©ã£ãšã ãã§ãã調ã¹ãŠã¿ãŸãããMicrosoft365ã®ã¢ã«ãŠã³ãã§ãã°ã€ã³ãè¡ããŸããèªåã®ãã©ã³ã§ã¯ããã«äžäœã®ãã¬ãã¢ã ã¯äœ¿ããªãã®ã§ããããã¬ãã¢ã å¥çŽãè¡ããšããã¬ãã¢ã ã¯ã©ãŠãã³ãã¯ã¿ããããŒã®èªåå®è¡ãç£èŠæ©èœãªã©ãããã«äœ¿ããããã«ãªãã¿ããã§ãã
â»äœããã¬ãã¢ã å¥çŽã®æ®ã©ã¯ä»åã®ãã¹ã¯ããããããŒã®çºã§ã¯ãªããéåžžã®Power Automateã®çºã®æ©èœãªã®ã§ããã¹ã¯ãããå©çšã®å Žåã¯ããŸãå¥çŽããæå³ã¯ãªããããããŸããã
DataverseããŒã¿ããŒã¹ãèŠã€ãããŸãã
Microsoft365ã¢ã«ãŠã³ã(æ³äººã¢ã«ãŠã³ãïŒã䜿ã£ãŠãæ©éè©ŠããŠã¿ãŸããããèªåã®å ŽåäŒç€Ÿã®æ¹ã§ãã§ã«PowerAppsãªã©ã掻çšããŠãããšããã£ãŠãäœäºããªãåäœããŠããŸãããtwitterãèŠãŠããšããã€ãã®äººããMicrosoft DataverseããŒã¿ããŒã¹ãèŠã€ãããŸããã§ããããšãããšã©ãŒã§ãPower Automate Desktopãåããªã人ãããããã§ãã
ããã¯ããã®æ³äººã®Microsoft365ã®ç®¡çè ããã¡ããšèšå®ãããŠããªãã®ãåå ã§ãã以äžã®èšå®ãå¿ èŠã«ãªããŸãã
- 管çã»ã³ã¿ãŒã«å ¥ãïŒç®¡çè ã¢ã«ãŠã³ãã®ã¿ïŒ
- å·Šãµã€ãããŒã®ç°å¢ãã¯ãªãã¯ãããšãäžã®æ¹ã«ããŒã¿ããŒã¹ã®è¿œå ããã
- ããŒã¿ããŒã¹ã®è¿œå ãã¯ãªãã¯ãããšãèšèªã¯æ¥æ¬èªãæå®ããé貚ã¯JPYãæå®ããã
- é©åœã«ãŠãŒã¶ãšã¢ã¯ã»ã¹èš±å¯ãèšå®ããŠãã
- ä¿åããŠãã10åãããã§åæ ããã¿ã¹ã¯ãã¬ã€ã«ããPower Automate DesktopãäžæŠçµäºãå床ãç«ã¡äžãçŽã
- ãããšããšã©ãŒã解æ¶ãäœããããã«ãªãã
以äžã¯ãTwitterããã®æ å ±ã§ããããã®èšå®é¢ä¿ã®ããã¥ã¡ã³ãã¯MSå ¬åŒããŒãžã«ãèšèŒããããŠããŸãããŸãã以äžã®æé ã§ãåæ§ã«dataverseãäœæãããŠå©çšå¯èœã«ãªãããã§ãã
- Teamsã«ãã°ã€ã³ãã
- å·Šäžã«ããã¢ããªãéãããæ¿èªããæ€çŽ¢ããŠã¯ãªãã¯ããã
- æ¿èªè æ¬ã¯èªåèªèº«ãå ¥ãã
- éä¿¡ãã
- ãªãããPower Automate Desktopã§ã®ãšã©ãŒããªããªã
â ããã® (@imksoo) March 3, 2021
å³ïŒãã®ãšã©ãŒãåºããèšå®ãå¿ èŠ
å³ïŒTeamsã§æ¿èªãããŒãäœããšäœ¿ããããã«ãªãã¿ãã
AzureADã¢ã«ãŠã³ãã§ãµã€ã³ã€ã³æ
èªåãActive Directoryã®ã¢ã«ãŠã³ãã§ãµã€ã³ã€ã³ããŠããã®ã§ãããèªåã®ã±ãŒã¹ã§ã¯ééããŠããªããã®ã®ãäžéšã®äŒæ¥ã§ã®æ§æäžã®åé¡ïŒãªã®ããAzure ADã¢ã«ãŠã³ãã§ãµã€ã³ã€ã³ããããšãããšãµã€ã³ã€ã³ã«å€±æããäºäŸãããããã§ãã
ãã®è§£æ±ºæ³ã§ããååãµã€ã³ã€ã³æã«ä»¥äžã®æé ã§å ¥ãããšãåºæ¥ããšã®å ±åããã
- å人ã®Microsoftã¢ã«ãŠã³ãã§å ¥åãã
- ãããšãã¢ã«ãŠã³ãéžæç»é¢ãåºãŠãã
- ããã§Azure ADã¢ã«ãŠã³ããéžæããŠãµã€ã³ã€ã³
ããã§å ¥ããããã§ãçç±ã¯äžæã§ãããäœåºŠãã£ãŠãå ¥ããªã人ã¯ãè©Šãããããã©ãŠã¶ã®ãã£ãã·ã¥åé€ã§ãã£ãããè³æ Œæ å ±ãããŒãžã£ã«ç»é²ãããŠãAzure ADã®æ å ±ãåé€ããã®ãå¹æã¯ãããããããŸããããã¡ãã£ãšãªã¹ããŒãªã®ã§ã管çè ã«ãªããããªãã®ãïŒãåãåããããã®ãäžçªè¯ãã§ãããã
äœææžã¿ãããŒã®å ±æ
æåãã©ã³ã®äººã¯ãäœæãããã¹ã¯ããããããŒãçµç¹ã®äººéãšå ±æããããšãå¯èœã§ãããã ãããã°ã©ã ã®äžå ·åïŒãªã®ããPower Automate Desktopäžã§ã¯å ±æããæ©èœããªãïŒå ±æã¢ã€ãã ã¯ããã®ã ããã©åºãŠããïŒããŠã§ãã®Power Automateã«ãã°ã€ã³ããŠäœæ¥ãããŸããã
- ãŠã§ãã®Power Automateã«ãã°ã€ã³ãã
- å·Šãµã€ãããŒã®ãã€ãããŒãã¯ãªãã¯ããã¡ã€ã³ç»é¢ã®ããã¹ã¯ããããããŒããã¯ãªãã¯ãã
- Power Automate DesktopåŽã§äœæãããããŒäžèŠ§ãåºãŠãã
- å ±æãã¿ã³ãããã®ã§ããããã¯ãªãã¯ãã
- ãã€ã¢ãã°ããã¯ã¹ã®ãŠãŒã¶ãè¿œå ã«ãã¡ã¢ããå ¥ãã
- ã¢ã¯ã»ã¹èš±å¯ã¯ããŠãŒã¶ïŒå®è¡ã®ã¿ïŒãããã¯å ±åææè ïŒç·šéå¯èœïŒãå²ãåœãŠã
- å ±æãã¯ãªãã¯ãããšãå ±æãã人éããããŒãå©çšããããšãåºæ¥ãããã«ãªããŸãã
ç¡åçã§ãåè¿°ã®ããã«ããããŒãããã¹ãã«ã³ããããŠæž¡ãäºãã§ããã®ã§ããã®éå£ã§çžæãšå ±æããã°è¯ãã§ãããã
å³ïŒäœæã·ããªãªã暪å±éåºæ¥ãŸã
æå®æå»ã«ãããŒãå®è¡
Power Automate Desktopèªäœã«æå®æå»ã«äœæãããããŒãèªåå®è¡ãããããªä»çµã¿ã¯ååšããŸãããããããPower Automateãã®ãã®ã«ãã¹ã±ãžã¥ãŒã«æžã¿ã¯ã©ãŠããããŒããšãããã®ãããããã¡ããå©çšããŠãã¯ã©ãŠãåŽããæå®ã®ãã¹ã¯ããããã·ã³ã®Power Automate Desktopã§äœæããããããŒãå®è¡ã§ããããã§ãïŒèªåã®ãã©ã³ãšç°å¢ã§ã¯ã¡ãã£ãšè©Šããªãã£ãïŒãæé ãšããŠã¯ã以äžã®éãã
- äºåã«on-premise data gatewayã®ã€ã³ã¹ããŒã«ãå¿ èŠã§ãïŒããã§è€éãªãããã¯ãŒã¯æ§æã®äŒç€Ÿã ãšã²ãŒããŠã§ã€çšã¡ã¢ãã®ç»é²ã«å€±æããïŒ
- ãŠã§ãã®Power Automateã«ãã°ã€ã³ãã
- å·Šãµã€ãããŒã®äœæãã¯ãªãã¯ããã¹ã±ãžã¥ãŒã«æžã¿ã¯ã©ãŠããããŒãã¯ãªãã¯
- é©åœãªååãå®è¡éå§æ¥ä»ãšæéããããŠå®è¡ééãæå®ãäœæãã¯ãªãã¯ãã
- ãããŒäœæç»é¢ã§ãæ°ããã¹ããããã¯ãªãã¯
- ã³ãã¯ã¿ã§ã¯ãããã¹ã¯ããããããŒããéžæãã
- ã¢ã¯ã·ã§ã³ã«æŒããŠãPower Automate Desktopã§æ§ç¯ãããããŒãå®è¡(Premium)ãéžæãã
- 1.ã§ã»ããã¢ãããå®äºã§ããã°ãã²ãŒããŠã§ã€åã®éžæã§ã²ãŒããŠã§ã€ãåºãŠãã
- ãã¡ã€ã³ãšãŠãŒã¶åã¯çµç¹ã®ADã®domainãšãŠãŒã¶åãåããŒã¯ã§çµåãããã®ãå ¥åãã
- ãããŠãã°ã€ã³ãã¹ã¯ãŒããå ¥å
- äœæãã¯ãªãã¯ããŠå®äº
ããã§æå®æå»ã§äŸãã°ïŒæ¥çœ®ãã«å®è¡ãªã©ãåºæ¥ãŸããéåžžã«é¢åãªæé ãªã®ã§ãæ¡ä»¶å€å®ãšå€æ°ãå©çšããŠãå€æ°ã«ããæå®æå»ãã©ãããå€å®ãæå®æå»ã«ãªã£ããå®è¡ã®ãããªããªãããŒãªæã®ã»ãããã·ãããããªãã
â»æå®æå»ã§ã¯ãªãäŸãã°ç¹å®ã®ã¡ãŒã«ãåä¿¡ãããå®è¡ãšãã£ãããªã¬ãŒãèµ·ç¹ãšããŠçºç«ãããå Žåãåæ§ã®æ§ç¯ãå¯èœã«ãªã£ãŠããŸãããã MSã«æãäºã¯ãããªã®ã¯ãã¯ã©ã€ã¢ã³ãåŽã®ã¢ããªã§å¯Ÿå¿ããããšãªã®ã§ãã²ãŒããŠã§ã€ãªã©äœ¿ãããã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ã§å®è¡åºæ¥ãããã«ãã¹ãã ãšããããšããããããªãã§ã¯ã©ãŠãåŽããé¢åãªä»çµã¿äœ¿ã£ãŠããããŠãã®ãã
å³ïŒäŸãã°æ·±å€ã«å€§ããªãããåŠçããããçã§äœ¿çš
å³ïŒãããŒã§ã¯åçš®èšå®ãå¿ èŠ
Power Automate DesktopåŽããPower Automateãå®è¡
æåãã©ã³ã«å ¥ããšãåè¿°ã®ããã«Power AutomateåŽããPower Automate Desktopã®ãããŒãé£ç¶ããŠå®è¡åºæ¥ãã®ã§ãäœããããªã¬ãŒã«ããŠPower Automate Desktopãå®è¡å¯èœãªã®ã§ãããçŸå®ãã©ã¡ãããšãããšã¯ã©ãŠããã¡ãŒã¹ãã§ã¯ãªãäŒæ¥ã®ã»ããå€ãã£ããããã®ãšãæã£ãã»ã©ã¿ã¹ã¯ã©ã³ããŒã£ãŠäœ¿ããªãã®ã§ãããããPower Automate DesktopåŽããPower AutomateåŽãå©ããŠããŠã§ããµãŒãã¹ãåããã»ããéèŠãé«ããšæããŸãã
Premiumã¢ã«ãŠã³ãã®å Žåã以äžã®æé ã§Power Automate DesktopåŽããPAåŽãå©ããã®ã§å®è¡çµæãTeamsã«æçš¿ãªã©ã¯ç°¡åã«å®çŸå¯èœã§ãã
- Power Automateã«ãã°ã€ã³
- å·Šãµã€ãããŒãããã€ãããŒã«å ¥ããæ°ãããããŒâã€ã³ã¹ã¿ã³ãã¯ã©ãŠããããŒãéžæ
- æåã«éžã¶ããªã¬ãŒã¯ããHTTPèŠæ±ã®åä¿¡æããéžã¶
- èŠæ±æ¬æã®JSONã¹ããŒãã¯ä»¥äžã®ãããªãã®ãå ¥åããŸãã
- ç¶ããŠãã¢ã¯ã·ã§ã³ãšããŠãTeamsã®ã¡ãã»ãŒãžãæçš¿ããV3ãã€ãªããŸã
- æ¢ã«äœã£ãŠããããŒã ãéžã³ãŸãããŸãããã®äžã®ãã£ã³ãã«ãéžã³ãŸãïŒãã£ã³ãã«ã1åã®å Žåã¯Generalãéžã¶ïŒ
- ã¡ãã»ãŒãžæ¬æã«ã¯ãåçãªã³ã³ãã³ãã®äžããã3.ã®messageãéžã³ãŸãã
- ä¿åãããšã3.ã«POSTçšã®URLãçæãããã®ã§ããããã³ããŒããŠãã
- ãã®URLãPower Automate Desktopã§äœ¿ãã®ã§ããããã®ãŸãŸè²Œãä»ãããšæ§æãšã©ãŒã«ãªãã®ã§ããã¡ãã®ãµã€ãã§URLãã³ãŒããã
- Power Automate DesktopåŽã§ãWebãµãŒãã¹ãåŒã³åºããŸãã¢ã¯ã·ã§ã³ãè¿œå ãã
- URLã«9.ã®ãã³ãŒãããURLãå ¥å
- ã¡ãœããã¯POSTãéžæ
- ã³ã³ãã³ãã¿ã€ãã¯application/jsonãæå®ãã
- èŠæ±æ¬æã¯ä»åã¯ã·ã³ãã«ã«{"message":"hello world"}ãå ¥ããŠãããŸããã
- 詳现ãéããŠãèŠæ±æ¬æããšã³ã³ãŒãããŸãã®ãã§ãã¯ã¯å€ããŠãã
- ä¿åããŠãPower Automate DesktopåŽããå©ããšã3.ã®PAåŽã¢ã¯ã·ã§ã³ãå®è¡ãããŠã14.ã®ã¡ãã»ãŒãžãæž¡ãããŠã5.ã®Teamsã«ã¡ãã»ãŒãžãæçš¿ãããŸãã
ãã®Power AutomateåŽã®ãããŒã«ããã«ç¶ããã°ã¿ã¹ã¯ã©ã³ããŒã§ããŸãã
1 2 3 4 5 6 7 8 9 10 11 |
{ "type": "object", "properties": { "channel": { "type": "string" }, "message": { "type": "string" } } } |
Power Automate DesktopåŽã®ã³ãŒãã¯ä»¥äžã®ãããªæã
1 |
Web.InvokeWebService Url: $'''ããã«PAåŽã®POSTçšURLãå
¥ãã''' Method: Web.Method.Post Accept: $'''application/json''' ContentType: $'''application/json''' RequestBody: $'''{\"message\":\"hello world\"}''' ConnectionTimeout: 30 FollowRedirection: True ClearCookies: False FailOnErrorStatus: False EncodeRequestBody: False UserAgent: $'''Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.21) Gecko/20100312 Firefox/3.6''' Encoding: Web.Encoding.AutoDetect AcceptUntrustedCertificates: False ResponseHeaders=> WebServiceResponseHeaders Response=> WebServiceResponse StatusCode=> StatusCode |
å³ïŒPAåŽã®Premiumã³ãã¯ã¿ãå©çšããŸã
å³ïŒURLãã³ãŒããå¿ èŠã§ã
å³ïŒPADåŽã®èšå®å 容
æ°ã«ãªãæ©èœã§RPAãäœã£ãŠã¿ã
ä»åã®Power Automateã«ãŠããã€ãæ°ã«ãªãæ©èœã§ç°¡åãªRPAãäœã£ãŠã¿ãããšæããŸãããµã¯ã£ãšè²ã è©ŠããŠã¿ãææ³ã¯ãããã¯ä»ã®RPAã«ãèšããããšã§ãããããã°ã©ãã³ã°ã®èããç¿åŸåºæ¥ãŠã人ã¯ãåŠç¿ã³ã¹ãã¯äœãã§ããããã§ãªã人ã¯ãæ¡ä»¶åå²ãã€ã³ã¹ã¿ã³ã¹ããšã©ãŒåŠçãªã©ãªã©äžé£ã®ãåºç€ç¥èãã¯ãã¯ãå¿ èŠããšãã£ãŠããå®éã«VBAãšãã§ãŽãªãŽãªæåããå匷ããããã¯ãã¯ããã«äœã³ã¹ãã§ãã
OCRæ©èœ
ä»åã¯æ¢åã§çšæãããŠããŠä»ãã䜿ããMODIããã³Tesseractã®2ã€ããã¹ãããŠã¿ãŸããããããã²ãšã€ã³ã°ããã£ãâMicrosoftâComputer Visionã«ãå¥ã®OCR APIãçšæãããŠããŸããGoogleã«ãããžã§ã³ã«ããã¹ãæ€åºãªã©ã®Vision APIã®é ç®ããããŸãããæåã®ãµãŒãã¹ã§ãããç¡åæ ãããã®ã§è©ŠããŠã¿ã䟡å€ã¯ããããã§ãã
MODI OCR
â»6æã¢ããããŒãã§å»æ¢ãããŸãã
Power Automate Desktopã®OCRã¯2çš®é¡ã®ãšã³ãžã³ãå©çšã§ããã®ã§ããããã®äžã§MODI OCRã¯çŸæç¹ã§ã¯å€ãã®äººã䜿ããããŸãéåžžã«å€ããšã³ãžã³ãªã®ã§ãã®ãããèªã¿èŸŒãç»åãéžã³ãŸãããã£ãŠå®çšããã«ã¯ã¡ãã£ãšã¢ã¬ãªæ©èœã§ããããã£ãŠã¿ãŸããã
äºåã«Office2007ã«å«ãŸããŠããMicrosoft Office Document Imagingãšãããã®ãå¿ èŠã§ãããMODIã®æ¬äœã§ããç¡ååãããSharePoint Designer 2007ã«ãå«ãŸããŠããããã§ãããçŸåšã¯ããé åžãããŠããŸãããããã§ãWebarchiveãå©çšããŠå ¥æã(430MBããã)ãOffice Document Imagingã®ã¿ãã€ã³ã¹ããŒã«åŸã«åèµ·åããŠã以äžã®ç»åãèªã¿èŸŒãã§ã¿ãŸããã
å³ïŒWikipediaã®ãšããããã¹ããç»ååããŠããã
以äžã®æé ã§RPAãçµãã§ããŸãã
- MODI OCRãšã³ãžã³ãäœæãè¿œå ã
- OCRã䜿ã£ãŠããã¹ããæœåºãè¿œå ãOCRãœãŒã¹ã¯ãã£ã¹ã¯äžã®ç»åã§ããã¡ã€ã«ãã¹ã§ãã«ãã¹ãæå®ãOCRãšã³ãžã³ã¯1.ã§äœã£ããšã³ãžã³ã®å€æ°ãæå®ããŸãã
- ããã¹ããã¡ã€ã«ã«æžã蟌ã¿ãŸããè¿œå ããã¡ã€ã«ãã¹ã¯ãã«ãã¹ã§result.txtãæå®ãæžã蟌ãããã¹ãã¯2.ã®å€æ°ãæå®ãäžæžãã§ãšã³ã³ãŒãã¯Unicodeãæå®
ããã§å®è¡ããã®ã§ããããããããªç»åãèªã¿èŸŒãŸããŸããããæ®ã©ã§ãšã©ãŒãèªèã§ããªãæåãèšå·ããããšNGã®ããã§ãã
å³ïŒ3ã€ã®ã¹ãããã®ã¿ã§æ§ç¯
OCRçµæã¯ä»¥äžã®éã
京ç 6000 ç³»é»è»ã¯ã京çé»é京çç·çšã®éå€åœ¢é»è»ã§ããã 1 972 幎ãã 1991 幎㫠304 äž¡ã補é ããã 20n 幎ãŸã§éçšããããéœå¶å°äžéæ°å®¿ç·ä¹ãå ¥ããåæã«èšèšããã京çã§åã㊠20m çŽã®è»äœãæ¡çšããã京çç·å šç·ã»éœå¶å°äžéæ°å®¿ç·ã§éçšãããã®ã¡ã 1 998 幎ãã 20n 幎 3 æã«ãããŠäºæ¥çšè»ã«æ¹é ããã 3 äž¡ãšéæ ä¿åããã 1 äž¡ãé€ããŠå»è»ã»è§£äœããããäžå€æ©å°åºéçºã«ãã沿ç·äººå£ã®å¢å ãçžæš¡åç·å»¶äŒžã«ããå€æ©äºã¥ãŒå€ãŠã³ä¹ãå ¥ããéœå¶å°äžé 10 äžç·ãåŸã®éœå¶å°äžéæ°å®¿ç·ã以äžãæ°å®¿ç·ãšè¡šèšããïŒä¹å ¥æ§æ³ã«ããã京çç·ã®å©çšå®¢å¢å ãèŠèŸŒãŸããçžåœæ°ã®è»äž¡ãæºåããå¿ èŠã«è¿«ããããªãã補é è²»çšãä¿å®è²»çšãæããæ°åè»äž¡ãšã㊠6000 ç³»æ§æ³ãããã ⊠âŠ
Tesseract OCR
ããäžã€çšæãããŠãOCRãšã³ãžã³ãTesseractã§ããªãŒãã³ãœãŒã¹ã§éçºãããŠãOCRãšã³ãžã³ã§ããçµæ§æããéçºãããŠãããã§ãçŸåšææ°çã¯ãv5.0ãšããŠçšæãããŠããŸããå®éã«äœ¿ã£ãŠã¿ãŸããããMODIãšéã£ãŠèªã¿åããç»åãéžã¶ãšãã£ãããšããªããŠãåé¡ãªãåã蟌ããŸããã
ããããPower Automate Desktopã§æšæºã§çšæãããŠãèªã¿åãå èšèªãè±èªãã¹ãã€ã³èªãªã©5ã¶åœèªã®ã¿ã§ãæ¥æ¬èªãå ¥ã£ãŠããŸããããšããããšã§ä»¥äžã®äºåæºåãããŸãã
- ãã®ããŒãžã«ããã€ã³ã¹ããŒã©ãããŠã³ããŒãããŠã€ã³ã¹ããŒã«ããïŒä»åã¯64bitãéžã³ãŸããïŒã
- ã€ã³ã¹ããŒã«åŸãã€ã³ã¹ããŒã«å ã«ããtessdataãšãããã©ã«ããé©åœã«ãã¹ã¯ãããã«ã³ããŒããïŒãã®äžã«æ¥æ¬èªã®èšèªãã¡ã€ã«ãå ¥ã£ãŠãïŒ
ä»åã¯ä»¥äžã®ãã¡ã€ã«ãèªã¿èŸŒãŸããŠã¿ãŸããã
å³ïŒçµæ§è€éãªæåãæ··ãã£ãŠãWikiã®ãšããããŒãž
以äžã®æé ã§RPAãçµãã§ããŸãã
- Tesseract OCRãšã³ãžã³ãäœæãè¿œå ãããã«ã¯ãªãã¯ã§èšå®ãå€ãã
- ä»ã®èšèªã䜿ãã®ã¹ã€ããããªã³ã«ããŠãèšèªã®çç¥åœ¢ã¯jpnãæå®ãèšèªã®ããŒã¿ãã¹ã¯ãã¹ã¯ãããã«ã³ããŒããtessadataãæå®ãã
- OCRã䜿ã£ãŠããã¹ããæœåºãè¿œå ãOCRãœãŒã¹ã¯ãã£ã¹ã¯äžã®ç»åã§ããã¡ã€ã«ãã¹ã§ãã«ãã¹ãæå®ãOCRãšã³ãžã³ã¯1.ã§äœã£ããšã³ãžã³ã®å€æ°ãæå®ããŸãã
- ããã¹ããã¡ã€ã«ã«æžã蟌ã¿ãŸããè¿œå ããã¡ã€ã«ãã¹ã¯ãã«ãã¹ã§result.txtãæå®ãæžã蟌ãããã¹ãã¯2.ã®å€æ°ãæå®ãäžæžãã§ãšã³ã³ãŒãã¯Unicodeãæå®
ããã§å®è¡ãããŠã¿ãŸããããªãã·ã§ã³èšå®ä»¥å€ã¯ç¹ã«ãšã©ãŒããªããããªãèªã¿èŸŒããŸãããè¥å¹²ãªã«ã·ãéšåããããŸããã倧äœãããã«OCRåºæ¥ãŠããŸãã
å³ïŒããã®ãªãã·ã§ã³èšå®ãèã§ã
OCRçµæã¯ä»¥äžã®éã
åå®äœã¯é«ã5-8cmãããã¯ãã以äžã«éããé éšãšæçãªæãšã§æ§æããããé éšã¯å šäœãšããŠã¯æªãã çç¶ããªããè¡šé¢ã«ã¯èããå¹åžããããçããŠè³ç¶ã®å€èŠ³ãæã¡ãé»è€è²ãªããèµ€è€è²ãåãããæã¯å€ªãåæ±ç¶ã§ãã°ãã°æµ ã瞊ãããæããé¡çœè²ãªããã¯ãªãŒã è²ã§å€å°ããã€ãã瞊æé¢ã§ã¯ãé éšã¯äžæã®åç€ç¶ã®åå®å±€æ (èå圢æéšçµå®éš : Hymenophore) ãè€éãã€äžèŠåã«æããããŸããæ§é ãæããæã®å éšã«ããã°ãã°äžèŠåãªç©ºéãçããŠããã
åè£ã¯çŽ°é·ãåçç¶ãªããããæ£ç¶ãåããç¡è²ã§å€§åœ¢ãã€èå£ããšãŠçŽ 溶液ã§éãæãŸãã (æªçãªåé»ã§ã¯çŽ°è質ãé»è€è²ã«æãŸãããéå€ããããšã¯ãªã) ãå 端ã«èãåç€ç¶ã§æçãªè (Operculum) ãåããå éšã«8åã®åè¡°èåãçãããåèŠèåã¯åºæ€¿å圢ã§ç¡è²ã»èå£
10ããŒã»ã³ãã®æ°Žé žåã«ãªãŠã 氎溶液äžã§èŠ³å¯ãããšäž¡ç«¯ã«ããäœãã¯ãã·ã§ã³ç¶ããªããéå±äœ (Apicula) ãèªãããããšãŠçŽ 溶液ã§åè²ããããšã¯ãªãããã°ãã°2åã®å°ããªæ²¹æ»Žãå«ã¿ã1åã®æ žãæããã åè£ã«æ··ãã£ãŠãç¡æ°ã®åŽç³ž (äžçšè糞) ãèŠåºãããå°æ°ã®éå£ãæãããã®å 端ã¯å ãã«èšãããšãšãã«èµ€è€è²ã®å ç²ãå«ãã§ããã åå®äœãæ§æããè糞ã¯ç¡è²ã»èå£ã§ãéå£éšã§åŒ±ããã³ããããšããããããããé£çµãæããªããæã®è¡šé¢ã«ãããŠã¯ãè糞ã®å 端ãæŽãã·ç¶ãªããçç¶ã«èšããããé¡èã«çºéããè¡šç®äžå±€ããªãããšã¯ãªãäž!ã
Google Cloud Vision API
åè¿°ïŒã€ã®OCRã¯æ£çŽåæ代çãšããããå€ãæ代ã®OCRã®ä»çµã¿ã§ããããã粟床ã¯æ£çŽè¯ããšã¯èšããŸãããããã§äœ¿ãã®ãæåã«ãªããŸãããGoogle Cloud Vision APIãã³ã°ããã£ãã«ããã¢ã¯ã·ã§ã³ã§ããªãç°¡åã«å©çšåºæ¥ãŸãã
Microsoftã®Azureã«ãComputer Visionãšããåæ§ã®APIãçšæãããŠããŸãããAzureã¯å人çã«ãã¡ããã¡ãããŠããŠäœ¿ãã«ããã®ã§ãGoogleã®APIãèªåã¯äœ¿ã£ãŠãŸãã
Power Automate Desktopã§Cloud Vision APIã䜿ã£ãOCRãå®çŸ
ã¹ã¯ã·ã§ãåã£ãŠã¡ãŒã«ã§éã
ãšããã¢ããªã§ç»é¢ã«ãšã©ãŒãåºãŠããã«ããã¹ã¯ã«å©ããæ±ãããã¹ã¯ã·ã§ãåã£ãŠâãªããExcelã«è²Œãä»ããâã¡ãŒã«ã«æ·»ä»ããŠâãã«ããã¹ã¯ã®ã¢ãã¬ã¹ãå ¥ããŠâæ¬ææžããŠâéãããããªåŠçãªã®ã§ããããŸãã¹ã¯ã·ã§ã®ãšãæ¹ç¥ããªã人ãå€ãããããã°ç¥ã£ãŠããŠããªããExcelã«è²Œãä»ããŠéã£ãŠãããã®ã ãããç»åãå°ããããŠèŠããªãã»ã»ã»ãªãã§ãExcelã«è²Œãä»ããã®ãç解ã«èŠãããééã£ãã¢ãã¬ã¹ã«ãã«ããæ±ãããšãã£ãããšãçµæ§ãã£ããããŸãã
ãšããããšã§ãä»åãããèªååããRPAãã€ãã£ãŠã¿ãŸãããé£ç¹ã¯ãã®ãŸãŸã ãšPower Automate Desktopãã¹ã¯ã·ã§ã«å ¥ã£ãŠããŸãã®ã§ãããã€ãæå°åããŠããã¹ã¯ã·ã§ãæ®ãå¿ èŠãããç¹ãRPAã«å ããŠããå¿ èŠãããäºã§ãïŒäœæç»é¢ã§ã¯ãªãäžèŠ§ãããªãããã®åŠçã¯ãããªããã§ãããã©ãïŒ
以äžã®æé ã§RPAãçµãã§ããŸãã
- ãŠã£ã³ããŠã®ååŸãè¿œå ãããã«ã¯ãªãã¯ããŠããã©ã¢ã°ã©ãŠã³ããŠã£ã³ããŠãæå®ãã
- ãŠã£ã³ããŠã®ç¶æ ã®èšå®ãè¿œå ãããã«ã¯ãªãã¯ããŠãæ€çŽ¢ã¢ãŒããããŠã£ã³ããŠã®ã€ã³ã¹ã¿ã³ã¹/ãã³ãã«ããšããæå®ããŠã£ã³ããŠã€ã³ã¹ã¿ã³ã¹ã¯1.ã§èšå®ãããã®ãéžæããŠã£ã³ããŠã®ç¶æ ã¯ãæå°åããæå®ãã
- ã¹ã¯ãªãŒã³ã·ã§ãããååŸãè¿œå ãããã«ã¯ãªãã¯ããŠã察象ã¯ãã¹ãŠã®ç»é¢ãæå®ãã¹ã¯ãªãŒã³ã·ã§ããã¯ãã¡ã€ã«ãšããä¿åå ãæå®ïŒæ¡åŒµåãŸã§ä»ãããã«ãã¹ïŒãç»åã®åœ¢åŒã¯jpgãæå®ã
- å ¥åãã€ã¢ãã°ã衚瀺ãè¿œå ãããã«ã¯ãªãã¯ããŠãå ¥åã®çš®é¡ãè€æ°è¡ã«å€æŽããã
- IFãè¿œå ã4.ã®ButtonPresså€æ°ãèŠãŠãOKãªãã°xxxxãELSEãè¿œå ãããã£ã³ã»ã«æã®åŠçãšãã
- 5.ã§OKã®æãšãã圢ã§ãªãã·ã§ã³æå®ãããŠãããELSEãšã®éã«ã¡ãŒã«éä¿¡ã®åŠçãè¿œå ããŠãã
- Outlookãèµ·åããŸããè¿œå ã
- Outlookããã®ã¡ãŒã«ã¡ãã»ãŒãžã®éä¿¡ãè¿œå ãã¢ã«ãŠã³ãã¯èªèº«ã®ã¡ã¢ãïŒã°ã«ãŒãã¢ãã¬ã¹ãè¡ããããïŒãå®å ãæ¬æã¯4.ã®å ¥åå€ã®å€æ°ãæå®ããã
- 8.ã«ç¶ããŠãæ·»ä»ãã¡ã€ã«ã§ã¯ã3.ã§æå®ãããã«ãã¹ããã®ãŸãŸå ¥ããïŒãããªãã§å€æ°ãããªããã ããã»ã»ã»ïŒ
- æåŸã«ã¡ãã»ãŒãžã衚瀺ãè¿œå ãçµäºããæšã®éç¥ãå ¥ããããã®åŸã«7.ã®ã€ã³ã¹ã¿ã³ã¹ãéããåŠçãå ¥ããŠããããã ããã©ãç°å¢ã«ãã£ãŠã¯5ååŸã«éä¿¡ãšãã ãšãOutlookãããŸã ã¡ãŒã«éã£ãŠãªããïŒã£ãŠã¡ãã»ãŒãžãåºãŠããŸãã®ã§ä»åã¯å ¥ããŠããªãã
- ãã®åŸéä¿¡åŸã«ã3.ã®ãã«ãã¹ã®ãã¡ã€ã«ãåé€ããåŠçãå ¥ããŠãè¯ããããããªãã
- ELSEåŽã«ã¯ãã£ã³ã»ã«æãªã®ã§ãã¡ãã»ãŒãžã衚瀺ãè¿œå ã
å®éã«è©ŠããŠã¿ãæãRPAãèµ·åãããš
- Power Automate Desktopãæå°å
- ã¹ã¯ã·ã§æ®åœ±
- ããã³ãããåºãã®ã§ããšã©ãŒå 容ãèšè¿°ããŠããã
- OKã¯ãªãã¯ã§Outlookèµ·åããã¡ã€ã«æ·»ä»ãã¡ãã»ãŒãžè¿œå ããããŠéä¿¡
- çµäºã¡ãã»ãŒãž
ãšããäžé£ã®äœæ¥ãåèªååãšãã圢ã®RPAãäœããŸããããŠãŒã¶ã¯å®å ãæ°ã«ããããŸãã¹ã¯ã·ã§æ®åœ±ã§ããã€ãããå ¥ããã®ãæ¬æã®ã¿ãªã®ã§ã確å®ã«ãšã©ãŒç»é¢ãæ ã·ã¹ã«éã蟌ããŸãããã®ãããŒãææã¢ã«ãŠã³ããªãã°å šç€Ÿå¡ã«å ±æãããªã«ããã£ããå®è¡ããŠæ瀺ã«åŸãã§æžã¿ãŸããïŒã€ãã§ã«Teamsã«éç¥ãšããã£ãŠãé¢çœããããããªãïŒ
â»ã¡ãŒã«ãéä¿¡ã§ã¯ãªãOutlookãèµ·åãéžãã§ããçç±ã¯ãMicrosoft365ã®Exchange Serverã䜿ã£ãŠãå ŽåãSMTPéä¿¡ãçšæãããŠããªãã±ãŒã¹ããããããSMTPãµãŒããçšæã§ãããªãã°ãã¡ãŒã«ãéä¿¡ãè¿œå ã§ãå¯ã§ã¯ãªãããšæããŸãã
1 2 3 4 5 6 7 8 9 10 11 |
UIAutomation.Windows.GetForegroundWindow WindowTitle=> WindowTitle WindowInstance=> AutomationWindow UIAutomation.Windows.SetStateByInstanceOrHandle WindowInstance: AutomationWindow State: UIAutomation.WindowState.Minimized System.TakeScreenshotAndSaveToFile File: $'''ããã«ä¿åããjpgã®ãã«ãã¹ãæå®''' ImageFormat: System.ImageFormat.Jpg Display.InputDialog Title: $'''ãšã©ãŒãçºçããŸããã''' InputType: Display.InputType.Multiline IsTopMost: True UserInput=> UserInput ButtonPressed=> ButtonPressed IF ButtonPressed = $'''OK''' THEN Outlook.Launch Instance=> OutlookInstance Outlook.SendEmail Instance: OutlookInstance Account: $'''éä¿¡å
ã¡ãŒã«ã¢ã«ãŠã³ããæå®''' SendTo: $'''ããã«éä¿¡å
ã¡ã¢ããæå®''' Subject: $'''ãšã©ãŒãçºçããŸããããã¹ã±ã''' Body: UserInput IsBodyHtml: False Attachments: $'''æå®ãããjpgãžã®ãã«ãã¹''' Display.ShowMessage Title: $'''éä¿¡å®äº''' Message: $'''å©ããåŒã³ãŸãã''' Icon: Display.Icon.Information Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2 ELSE Display.ShowMessage Title: $'''éä¿¡ãã£ã³ã»ã«''' Message: $'''ãã«ãã¯ãã£ã³ã»ã«ãããŸããã''' Icon: Display.Icon.Information Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: True ButtonPressed=> ButtonPressed3 END |
å³ïŒãããªæãã«åŠçãäœã£ãŠã¿ãŸããã
å³ïŒãŠã£ã³ããŠæå°åãããªããšRPAã®ç»é¢ãåããŠããŸã
Excelã®ãã¯ãå®è¡ã§ã·ãŒãPDFååŸã«å šéšçµåãã
å®åã§ã¯ããããã®ã§ãããåæ åœäŒè°çšè³æããã©ãã©ã«æã£ãŠããŠãããããåå¥ã«å°å·âäžæãã€æŸã£ãŠã¯ãããã¹æ¢ããšããéçç£çãªä»äºãäºåã«ã¯ãããã£ããããŸãããããã¯äžåºŠPDFåããåŸã«ãpdfasã®ãããªçµåãœããã䜿ã£ãŠäžæã«ããããããå°å·ãããã°äžæäžææŸãå¿ èŠããããŸããããããRPAã䜿ã£ãŠãåå¥ã®ãã¡ã€ã«ãPDFåâ1æã®PDFã«çµåâå°å·ãŸã§ããµã¯ã£ãšçµãããããšãããã®ããã£ãŠã¿ãŸããã
ä»åã¯Excelãã¡ã€ã«1åãªã®ã§ããããã¯ããä»èŸŒãã§ãããã·ãŒããïŒæãã€PDFã«ããŠæå®ã®ãã©ã«ãã«å ¥ããŠããŸããPower Automate Desktopã«ã¯å°å·ã®ã¡ãœããã¯ãã£ãŠãPDFåããã¡ãœããã¯ç¡ãã®ã§ãããããæã¯ãã¯ãã®åºçªã§ãã䜿çšãããŠé ãããã¯ãã¯ãã¡ãã®ã³ãŒãã§ãã
以äžã®æé ã§RPAãçµãã§ããŸããExcelãã¡ã€ã«ã¯ãã€ããã¥ã¡ã³ãçŽäžã«æ ŒçŽããŠããŸãã
- ç¹æ®ãªãã©ã«ããŒãååŸãè¿œå ãç¹æ®ãªãã©ã«ããŒã®ååã§ã¯å人çšãéžæïŒãããMyDocumentãããïŒããããå ¥ããããšã§äººæ¯ã«ç°ãªãMyDocumentã®ãã¹ãèªåå€å®ã§åã£ãŠãããŸãã
- Excelã®èµ·åãè¿œå ãããã¥ã¡ã³ããã¹ã¯1.ã®ãã¹ã«\é£è«æ€ç©.xlsmãšä»ãå ãããã¹ãæå®ããŠãããŠããŸããïŒäŸïŒ%SpecialFolderPath%\é£è«æ€ç©åšåº«.xlsmïŒ
- Excelãã¯ãã®å®è¡ãè¿œå ãå éšã§sample2()ãšãããã¯ããååšããŠãã®ã§ããã¯ãã§ãã®é¢æ°åãæå®ããŸããããã§ãåã·ãŒããåå¥ã®PDFãšããŠpdfãšãããã©ã«ãã«æ ŒçŽãããŸãã
- Excelãéãããè¿œå ã
- ãã©ã«ããŒå ã®ãã¡ã€ã«ãååŸãè¿œå ããã©ã«ãã¯3.ã®åºåå ãæå®ãããã®ã§ã1.ã®ãã¹ãšpdfãçµã¿åããããã¹ãæå®ïŒäŸïŒ%SpecialFolderPath%\pdf\ïŒ
- ã€ã¥ããŠãã£ã«ã¿ã¯PDFã®ã¿ãªã®ã§ã*.pdfãšããŠã¯ã€ã«ãã«ãŒããæå®ã
- PDFãã¡ã€ã«ãçµ±åãè¿œå ãPDFãã¡ã€ã«ã§ã¯ã5.ã®å€æ°ã§ãã¡ã€ã«ã®äžèŠ§ãšããŠæå®ãçµ±åãããPDFã®ãã¹ã¯3.ãšåããã¹ãæå®ããŠã¿ãŸããã
- ããã¥ã¡ã³ãã®å°å·ãè¿œå ãæ¢å®ã®ããªã³ã¿ã§ããå°å·ãåºæ¥ãŸããããããã§åãåããç¡ãã§å°å·ãå®è¡ãããŸãã
- ã¡ãã»ãŒãžã衚瀺ãè¿œå ãå°å·å®äºã®ã¡ãã»ãŒãžã衚瀺ããŠãRPAå®è¡å®äºã
æ åœè ã«ã¯æå®ã®ãã©ã«ãã«ã§ãçªã£èŸŒãã§ãããŠããããããããã«ã¯äºãPDFåã®ãã¯ããä»èŸŒãã§ãããFor eachã«ãŒãã§ã䜿ã£ãŠé çªã«ãã¯ããå®è¡ããŠãPDFåãã®ã¡ã«ããããçµ±åããŠå°å·å®è¡ããšãŸã§çµã¿äžããã°ãè³æã®äœææéãå€§å¹ ã«æžãã®ã§ã¯ãªãããšæããŸããããã€ã工倫ã¯å¿ èŠã§ããã
ãŸããPDFåãRPAã§ãªããšãããããšãããç°¡åãªãã¯ãäžåã§å®çŸåºæ¥ãäºãªã®ã§ãç©æ¥µçã«ãã¯ããçµã¿åãããã»ãã楜ã«RPAã¯äœããŸãã
å³ïŒä»åã®ãããŒã¯ãããªæããäžé£ã®äœæ¥ãäžå¡ã«ããã
å³ïŒPDFçµåéšåã®ãããŒ
ExcelããŒã¿ãJSONåâGASã«POSTã§éä¿¡
Excelã®è¡šããŒã¿ãèªã¿èŸŒãã§ãGoogle Spreadsheetã«ä»èŸŒãã§æŒããdoPostå®ã«REST APIãšããŠããŒã¿ãéã蟌ãã§è¿œèšãããšãã£ãããšãPower Automate Desktopã«ããããŠã¿ãããšæããŸããã¡ãã£ãšè€éãªã®ã§ã詳现ã«èšè¿°ãããŠã¿ãããšæããŸãã
䜿çšããçŽ æ
äºåæºå
Google Spreadsheetã«ã¯ä»¥äžã®doPostã§ããŒã¿ãåãä»ããã³ãŒããå ¥ã£ãŠããŸãã®ã§ãäºåã«ã³ããŒãã以äžã«èšå®å€æŽãšãããã€ãå¿ èŠã§ãã
- ã¹ã¯ãªãããšãã£ã¿ãéã
- ã³ãŒã.gsã®ssidã«ã¹ãã¬ããã·ãŒãã®IDãèšè¿°ãã
- ãããã€ãã¿ã³ãã¯ãªãã¯ããæ°ãããããã€ãéžæ
- ãããã€ããæã«ä»åã¯èªèšŒãªãã§åãä»ããã®ã§ãã¢ã¯ã»ã¹ã§ãããŠãŒã¶ãå šå¡ã«èšå®ãã
- ãããã€ãã¿ã³ãã¯ãªãã¯ããããURLãåºãã®ã§ã³ããŒãã
- èªã¿èŸŒãExcelããŒã¿ã¯ããŠã³ããŒããããèªåã®ããã¥ã¡ã³ããã©ã«ãçŽäžã«é 眮ããŸãã
ãœãŒã¹ã³ãŒã
Power Automate DesktopåŽ
以äžã®ã³ãŒããã³ããŒããŠã貌ãä»ãããšãããŒãæ§ç¯ãããŸããæ§ç¯ããããããŠã§ããµãŒãã¹ãåŒã³åºããŸãã®é ç®ã«ãŠããã«ã¯ãªãã¯ããURLã®æ¬ã«äºåæºåã®5.ã§ã³ããŒããexecã§çµããURLãèšè¿°ããŠä¿åããŸãã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
Folder.GetSpecialFolder SpecialFolder: Folder.SpecialFolder.Personal SpecialFolderPath=> SpecialFolderPath Excel.LaunchAndOpen Path: $'''%SpecialFolderPath%\\test.xlsx''' Visible: False ReadOnly: False LoadAddInsAndMacros: False Instance=> ExcelInstance Excel.ReadCells Instance: ExcelInstance StartColumn: 1 StartRow: 1 EndColumn: 4 EndRow: 11 ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData Variables.CreateNewList List=> jsonman # EXCELããŒã¿ãJSONã«å€æ LOOP FOREACH CurrentItem IN ExcelData SET jsonrec TO $'''{''' SET jsonrec TO $'''%jsonrec% \"ID\": \"%CurrentItem['ID']%\",''' SET jsonrec TO $'''%jsonrec% \"item\": \"%CurrentItem['ååå']%\",''' SET jsonrec TO $'''%jsonrec% \"price\": \"%CurrentItem['äŸ¡æ Œ']%\",''' SET jsonrec TO $'''%jsonrec% \"count\": \"%CurrentItem['åšåº«æ°']%\"''' SET jsonrec TO $'''%jsonrec% }''' Variables.AddItemToList Item: jsonrec List: jsonman NewList=> jsonman END Text.JoinWithCustomDelimiter List: jsonman CustomDelimiter: $''',''' Result=> JoinedText Excel.Close Instance: ExcelInstance SET sendjson TO '{\"excelman\":[' + JoinedText + ']}' Web.InvokeWebService Url: $'''ããã«GASåŽã®URLãèšè¿°''' Method: Web.Method.Post Accept: $'''application/json''' ContentType: $'''application/json''' RequestBody: sendjson ConnectionTimeout: 30 FollowRedirection: True ClearCookies: False FailOnErrorStatus: False EncodeRequestBody: False UserAgent: $'''Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.21) Gecko/20100312 Firefox/3.6''' Encoding: Web.Encoding.AutoDetect AcceptUntrustedCertificates: False ResponseHeaders=> WebServiceResponseHeaders Response=> WebServiceResponse StatusCode=> StatusCode Display.ShowMessage Title: $'''ãã¹ã''' Message: WebServiceResponse Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed |
ä»åã®ãããŒã¯ä»¥äžã®ãããªæ§æã§ãã
- ããã¥ã¡ã³ãçŽäžã®test.xlsxãèªã¿èŸŒã¿
- Excelã¯ãŒã¯ã·ãŒããèªã¿åãã§ã¯ã詳现ã«ãŠç¯å²ã®æåã®è¡ã«ååãå«ãŸããŠããŸãã«ãã§ãã¯ãå ¥ããŠããŸããïŒãããJSONã®ããŒã«ãªãïŒ
- ãªã¹ããçšæïŒãããJSONã®åå°ã«ãªããŸãïŒ- jsonmanãšããå€æ°å
- For eachã§èªã¿èŸŒãã ExcelããŒã¿ãJSONã«å€æã
- æ§ç¯åŸã«ããã¹ãã®çµåãå©çšããŠã3.ã®ããŒã¿ã«ã³ãåºåãã«å€æŽãã
- POSTã§éã蟌ãçšã«ã5.ã®ããŒã¿ã«excelmanãšããããŒãä»ãã5.ã®ããŒã¿ã¯[]ã®é åãšããŠæ§ç¯ãçŽãã
- ãŠã§ããµãŒãã¹ãåŒã³åºãã§ãGASåŽã®URLãPOSTã§å©ãããã®æã詳现ã«ãŠãªãã€ã¬ã¯ãã«è¿œåŸããã«ãã§ãã¯ãå¿ èŠã
- ãŸããèŠæ±æ¬æããšã³ã³ãŒãããã®ãã§ãã¯ã¯å€ããŸããã
- èŠæ±æ¬æã«ã¯6.ã§ã»ããããå€æ°ãæå®ãã
- å®è¡çµæãGASåŽããreturnãããŠããã®ã§ããããåãåã£ãŠã¡ãã»ãŒãžããã¯ã¹ã§è¡šç€ºãã
å³ïŒREST APIãå©ãæã«ããäžè©±ã«ãªããŸã
GASåŽã³ãŒã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
//æžã蟌ã¿ã¹ãã¬ããã·ãŒãID var ssid = "ãã®ã¹ãã¬ããã·ãŒãã®ID"; //POSTã§åãåã£ãŠã¹ãã¬ããã·ãŒããžæžã蟌㿠function doPost(e) { try{ //éä¿¡ãã©ã¡ãŒã¿ãååŸãã var temp = e.postData.getDataAsString(); if (temp == undefined) { //ãã©ã¡ãŒã¿äžè¯ã®å Žåã¯undefinedã§è¿ã return ContentService.createTextOutput("ãªããéä¿¡ããŒã¿ããªã«ã·ã€ã§ã"); } else { //JSONå var json = JSON.parse(temp); //excelmanã ãåãåºã var excelman = json.excelman //ã¹ãã¬ããã·ãŒããååŸ var ss = SpreadsheetApp.openById(ssid).getSheetByName("ã·ãŒã1"); //JSONããã¬ã³ãŒããçæããŠappendrowãã for(var i = 0;i<excelman.length;i++){ //äžæé
åãçšæ var temparr = []; //ã¬ã³ãŒããäžååãåºã var rec = excelman[i]; //JSONããé
åãæ§ç¯ temparr.push(rec.ID); temparr.push(rec.item); temparr.push(rec.price); temparr.push(rec.count); //æžã蟌㿠ss.appendRow(temparr); } //ãã°åºåãšå€ã®åºå return ContentService.createTextOutput("Googleã¹ãã¬ããã·ãŒãã«è¿œèšããŸãã"); } }catch(e){ //ãšã©ãŒã¡ãã»ãŒãžã衚瀺 return ContentService.createTextOutput(e.message); } } |
- GASåŽã§ã¯ãJSONåãããããŒã¿ãPower Automate Desktopã§åãåã£ãŠããŸãã
- åãåã£ãããŒã¿ã1è¡ãã€é åãšããappendRowã§æžã蟌ãã§ããŸãã
ãµããããŒæŽ»çšã§åŠçãåå²
ããã°ã©ã éçºã§ãããçšåºŠå€§ããªåŠçã¯ãåŠçããŒããåããŠã倧å ã®é¢æ°ããæ¡ä»¶ã«å¿ããŠåŒã³åºãããã«ããã®ãéçºãã¯ããã¯ãšããŠæ®éã«è¡ãããŠããŸããåããããŒã®äžã§èšè¿°ããŠãè¯ãã®ã§ãããåŠçã倧ãããã°å€§ããã»ã©ãèŠéããæªããªããã¡ã³ããã³ã¹ãè¡ãã«ãããªããŸããPower Automate Desktopããã®ãåŠçãåå²ãããŠæ¡ä»¶ã«å¿ããŠåŒã³åºãããšãã£ãäºãå¯èœã«ãªã£ãŠããŸããããããµããããŒã
åºæ¬çã«ã¯IF ELSE ENDã䜿ããããããã®äžã§ãµããããŒã®å®è¡ã¢ã¯ã·ã§ã³ãå ¥ããŠãåŠçã®äžèº«ã¯ãµããããŒã®åŽã«èšè¿°ããŠããããšã«ãªããŸããä»åã¯èµ·åæã«åºå€ãïŒéå€ãïŒããŠãŒã¶ã«éžã°ããŠãããããã®ã±ãŒã¹ã«å¿ããŠãµããããŒãå®è¡ããåèªååã§äœã£ãŠã¿ãŠãŸããåºå€ãªãã°SelectIndexã®å€ã1ãªã®ã§ãincomeãå®è¡ãéå€ãªãã°0ãªã®ã§outgoingãå®è¡ãšãã£ãæãã§ãããŸããä»åã®ãµã€ãã§ã¯åºå€ã»éå€ãã¯ãªãã¯ããéšåããiFrameãã§äœãããŠããŸã£ãŠãã®ã§ãåŠçã«ãiFrameå ã®ãœãŒã¹URLãæå®ããŠããã«ããŒãžã移åãã®åŠçãå ¥ããŠããŸãïŒPuppeteerã§ããããã®æã®åŠçãè¡ããŸãïŒã
ã¯ãªãã¯ãå®è¡ããããæåŸã«ãã©ãŠã¶ãéããããšã§å®äºãšãªããŸããå®éã®ã³ãŒãã¯ä»¥äžã®éãã§ãã
1 2 3 4 5 6 7 8 9 10 11 12 |
Variables.CreateNewList List=> List Variables.AddItemToList Item: $'''åºå€''' List: List NewList=> List Variables.AddItemToList Item: $'''éå€''' List: List NewList=> List Display.SelectFromList Title: $'''å€æ ''' Message: $'''ã©ãããïŒ''' List: List IsTopMost: True AllowEmpty: False SelectedItem=> SelectedItem SelectedIndex=> SelectedIndex ButtonPressed=> ButtonPressed Display.ShowMessage Title: $'''ã¢ã¯ã·ã§ã³''' Message: SelectedIndex Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2 IF SelectedIndex = 1 THEN CALL income ELSE CALL outgoing END WAIT 5 WebAutomation.CloseWebBrowser BrowserInstance: Browser |
å³ïŒã¡ã€ã³ãããŒå ã§åŠçåå²ã§ãµããããŒãåŒã³åºã
å³ïŒãµããããŒã§ã¯ããããã®å®è¡åŠçãèšè¿°ãã
SQLãå©çšããŠExcelããŒã¿ã47éœéåºçå¥ã«æ¯ãåã
ãã¡ããã¡ãã«ãªã£ãŠãããŒã¿ããŒã¹ã«å¯ŸããŠãç¹å®ã®åã§ãã£ã«ã¿ãããããããããããã®ã·ãŒãã«æ¯ãåãããšããã®ã¯çµæ§è»¢èšã®äºäŸã§ã¯å€ãã®ã§ã¯ãªãã§ããããïŒä»åãPower Automate Desktopã®ã¿ã§Excel VBAãå©çšããã«SQLãå©çšããŠåé¡ãããŒã¿ãæ¯ãåãããµã³ãã«ãäœã£ãŠã¿ãŸããã
䜿çšããçŽ æ
- data.xlsx - 47éœéåºçåãå ¥ã£ãŠãã ãã®Excelãã¡ã€ã«
- database.xlsx - 47éœéåºçããã¡ããŸãã«å ¥ã£ãŠãããŒã¿ïŒç䌌å人æ å ±çæãµãŒãã¹å©çšïŒ
ä»å䜿çšããODBCãã©ã€ãã¯ãæ¬æ¥Accessã«ä»å±ã®ã¢ããªã®ã§ãããAccessãç¡ããšããMicrosoft Access ããŒã¿ããŒã¹ ãšã³ãžã³ 2016 åé åžå¯èœã³ã³ããŒãã³ããã€ã³ã¹ããŒã«ããã°ãMicrosoft.ACE.OLEDB.12.0ãšããŠå©çšããäºãå¯èœã§ãã
å®æŒåç»
å®è¡é床ããŸããŸãã§ããæäœæ¥ã§ãããªäœæ¥ããŠããäœåæããããšãããããã£ã«ã¿ãSQLã§äžçºãªã®ã§ãããããå ã®RPAãæŠåšã«ããäºåå¡ã¯SQLæãå匷ããŸãããã
ãœãŒã¹ã³ãŒã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
Excel.LaunchAndOpen Path: $'''ããã«data.xlsxã®ãã«ãã¹''' Visible: True ReadOnly: False LoadAddInsAndMacros: False Instance=> ExcelInstance Excel.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1''' Excel.ReadCells Instance: ExcelInstance StartColumn: 1 StartRow: 1 EndColumn: 1 EndRow: 48 ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData Variables.RetrieveDataTableColumnIntoList DataTable: ExcelData ColumnNameOrIndex: $'''éœéåºç''' ColumnAsList=> ColumnAsList SET ExcelPath TO $'''ããã«database.xlsxã®ãã«ãã¹''' Database.Connect ConnectionString: $'''Provider=Microsoft.ACE.OLEDB.12.0;data source=%ExcelPath%;extended properties=\"Excel 12.0 Xml;HDR=Yes\";''' Connection=> SQLConnection LOOP FOREACH CurrentItem IN ColumnAsList SET Prefecture TO CurrentItem Database.Execute Connection: SQLConnection Statement: $'''SELECT * FROM [Sheet1$] WHERE [prefecture] = \"%Prefecture%\" ''' Timeout: 30 Result=> QueryResult SET rec TO QueryResult Excel.AddWorksheet Instance: ExcelInstance Name: Prefecture WorksheetPosition: Excel.WorksheetPosition.Last Excel.ActivateWorksheetByName Instance: ExcelInstance Name: Prefecture Excel.WriteCell Instance: ExcelInstance Value: QueryResult Column: 1 Row: 1 END |
- data.xlsxã®ãã«ãã¹ãšdatabase.xlsxã®ãã«ãã¹ãæå®ããŸãã
- data.xlsxã®Sheet1ããã¯47éœéåºçã®ããŒã¿ãååŸããŠãããŒã¿ããŒãã«åããªã¹ãã«è¿œå ãšãã圢ã§ãªã¹ãåã®å€æ°ãäœããŸãã
- SQLæ¥ç¶ãéããå©çšããŠãxlsxã«å¯ŸããŠæ¥ç¶æååã§æ¥ç¶ããŸããxlsxã®å Žåã«ã¯ãProvider=Microsoft.ACE.OLEDB.12.0;data source=%ExcelPath%;extended properties="Excel 12.0 Xml;HDR=Yes";ãšãã圢ã«ãªããŸãã%ExcelPath%ãdatabase.xlsxãžã®ãã«ãã¹ã®å€æ°ãå²ãåœãŠãŠãŸãã
- ã«ãŒãã§ãªã¹ããåããŠãéœéåºçåã1åã%Prefecture%ãšãã圢ã§ååŸããŠãããŸã
- SQLã¹ããŒãã¡ã³ãã®å®è¡ã«ãŠãããŒã¿ã®å¡ã«SQLæããªããŠãããŒã¿ã®å¡ãåãåºããŸããæ¡ä»¶ã¯éœéåºçã%Prefecture%ãšåèŽãããã®ãSQLæã¯SELECT * FROM [Sheet1$] WHERE [prefecture] = "%Prefecture%"ã«ãªããŸããæååãªã®ã§å€æ°ã«""ãæ¬ãã®ãå¿ããã«
- ããŒã¿ãååŸåºæ¥ãããæ°ããã·ãŒããdata.xlsxã«æ°ããã·ãŒãã%Prefecture%ã«ãŠäœæãã¢ã¯ãã£ãã«ããŸãã
- Excelã¯ãŒã¯ã·ãŒãã«æžã蟌ã¿ã«ãŠã5.ã§ååŸããçµæãã»ã«ã®1åç®1è¡ç®ã«äžçºæžã蟌ã¿ããŸãã
- åŸã¯éœéåºçåã ãã¶ãåããšã5000件ã®ãããŒããŒã¿ãéœéåºçå¥ã«æ¯ãåããããŠãããŸãã
- GROUP BYãšãã£ããã®ã ãã§ãªããSUMãCOUNTãINSERTãUPDATEæãªã©ã䜿ããããã§ãã
ODBCãã©ã€ããããã°ãAccessããŒã¿ããŒã¹ãMySQLãªã©ã䜿ããŸããç¹ã«Accessã®å Žåã¯ã¯ãã¹éèšã¯ãšãªã䜿ãããããã®ã§ãäºãAccessåŽã§äœã蟌ãã§æŒãã°ãã¯ãã¹éèšãããçµæãäžçºã§ååŸãšãã£ãèæ¥ãå¯èœã§ãã
å³ïŒExcelã«å¯ŸããŠSQLæãã¶ãæããŠæœåºãã
ãã©ãã«ã·ã¥ãŒãã£ã³ã°
ç¡ç·LANã«ã¢ã¯ã»ã¹ã§ããªããªã
WPA2-Enterpriseã®ãããªã瀟å LANæ¥ç¶ã«èšŒææžã䜿ã£ãŠæ¥ç¶ããã¿ã€ãã®æ¥ç¶æ¹æ³ãåã£ãŠããäŒæ¥ã«æŒããŠãPower Automate for Desktopãã€ã³ã¹ããŒã«åŸã«ç¡ç·LANæ¥ç¶ãã§ããªããªããšããçŸè±¡ãå ±åãããŠããŸãããã®åå ã¯ãPADãã€ã³ã¹ããŒã«æã«æ§ã ãªèšŒææžãã€ã³ã¹ããŒã«ããäºã«ãã£ãŠãæ¢åã®èšŒææžãäžæžããããŠããŸããçµæç¡ç·LANã«æ¥ç¶ã§ããªããªããšããçµæ§å€§ããªåé¡ã§ãã
ãã¡ãã®åé¡ç¹ã®è§£æ¶ã«ã€ããŠã¯ããã¡ãã®ããã°ã®ãšã³ããªãŒã«ãŠåé¿æ¹æ³ãæ瀺ãããŠããŸããPADã瀟å å±éããåã«å®éšæ©ã§ãã¹ããããåæ§ã®çäŸã«ã¶ã€ããããã§ããã°ãåé¿çãè¬ããå¿ èŠãããã§ãããã
åèåç»
é¢é£ãªã³ã¯
- ã§ããPower Automate ç¡åããŠã³ããŒã
- Add a Microsoft Dataverse database
- MicrosoftããExcelãã®ãããªããŒã³ãŒãåãããã°ã©ãã³ã°èšèªãPower Fxããçºè¡š
- Microsoftããã¹ã¯ãããæäœã®èªååããŒã«ãWindows 10ãŠãŒã¶ãŒã«è¿œå è²»çšãªãã§æäŸ
- WindowsïŒPowerAutomate Desktopãã€ã³ã¹ããŒã«ããŠäœ¿ã£ãŠã¿ã
- Set up Power Automate Desktop
- ã¢ã¯ã·ã§ã³ãªãã¡ã¬ã³ã¹
- Microsoftã®Power Automate Desktopã§SAPãæäœããŠã¿ã
- Microsoft Power Automate ã®RPAæ©èœãè©ŠããŠã¿ã
- Selenium IDE ã®ãããŒãç·šéãã
- Chrome Extension : Selenium IDE
- Power Automate äŸ¡æ Œ
- ã¯ã©ãŠããããŒãå ±æãã
- æ¥æ¬äžãããããããéå ¬åŒãª Power AutomateãšRPAæ©èœUI flowsã®ã©ã€ã»ã³ã¹è¡š
- RPAã®Microsoft Power Automate DesktopãšUiPathãæ¯ã¹ãŠã¿ã
- Power Automate ã®RPAæ©èœãUIãããŒãã§Adobe Photoshopãå«ããã¿ã¹ã¯èªååãè©ŠããŠã¿ãŸãã
- Microsoft Dataverse ã«é¢ããç§çã¡ã¢
- Microsoft Dataverse ããŒã¿ããŒã¹ã®è¿œå
- Microsoft Office 2010 ã§äœ¿çšãã MODI ã®ã€ã³ã¹ããŒã«
- ãSHOã®ãRobinãã€ã³ã¹ããŒã«ããŠã¿ãã
- Power Automate Desktop ããOpenCVã䜿ããšãã®æ³šæç¹
- äžè¬å ¬éããã Microsoft Dataverse for Teams ã§æ°ããåãæ¹ãå®çŸããã
- ãMicrosoftã®RPAæ©èœããWinAutomationããšã¯ïŒããã®ïŒãæ©èœã®èª¬æã
- Microsoft Teams ã§ã®æ¿èª
- Power Automate Desktop ã®ãããŒã®ä¿åæ¹æ³ã ã£ãããã以å€ã ã£ãã
- Quick guide: Utilize Robin Scripts through C#
- Power Automate Desktop ã Excel ãã¡ã€ã«ãèªã¿åã JSON ããŒã¿ã§ Node-RED ã«é£æºããã¡ã¢
- Power Automate Desktopãç¡æã§äœ¿ããRPAã§Excelå ¥åãèªååããŠã¿ã
- Power Automate Desktop ã Excel ãã¡ã€ã«ãã obniz ã®ããŒã LED ã®ã«ã©ãŒãå€ããã¡ã¢
- Google Apps Scriptã®doPostã§JSONãªãã©ã¡ãŒã¿ã®POSTãªã¯ãšã¹ããåãã
- Problem installing Power Automate Desktop
- [Power Automate]UIãããŒã§æå®ãããã¹ã®ã¢ããªã±ãŒã·ã§ã³ãå®è¡ããããšè©Šè¡é¯èª€ãã件
- Use AutoHotkey to run scripts with ârobin.exeâ
- Referring to the AppMask
- PowerAutomateã䜿çšããSAPGUIAutomationã®RPAPlaybookïŒAPIãããŒãUIãããŒãããã³Power Automate Desktop
- Passing keyboard shortcuts to Power Automate desktop
- Reinstallation did not resolve error
ããããšç³ããŸãã
詳ããèšäºãããããšãããããŸãïŒ
倧å€åèã«ãªããŸããã
ã¡ããã©ãã³ãã³ãããã³ãããããããŒã®å®è¡ã暡玢ããŠããã®ã§ã
ãRobin.exeã§Power Automate Desktopã®ãããŒãå®è¡ãã¯ç¹ã«èå³æ·±ãã£ãã§ãã
æåå³åã§ããããPadFlowRun.exeããšãããããŒãåŒã³åºãã ãã®ãã®ãå ¬éããŠãããŸãã
UWCSãšãããã®ã§äœã£ãŠexeåãããã®ã§ãã
Stream Deckçš ãšããŠããŸããããPadFlowRun.exe “ãããŒå”ããšããèšè¿°ã§ã³ãã³ããããå®è¡ã§ããŸãã
Robin run ããã®å®è¡ã§ããšåäœéå§ãŸã§å°ãæéãããããŸããããã¡ãã§ããšå°ãæ©ãåããŸããããããŒåã§æå®ã§ããã®ã§ããããã ã楜ãããããŸããã
ãããã°è©ŠããŠããã ããããšæããã³ã¡ã³ããããŠããã ããŸããã
https://yoshio-akz.blogspot.com/2021/03/stream-deck-power-automate-desktop.html
ãããæ§
officeã®æ管ç人ã§ãããããã®UWSCã§ããã倧æããèªååã§è²¢ç®ããŠããããŒã«ã ããããŸãã
æ©éè©ŠããŠã¿ãããšæããŸãã
UWSCã ãšãäœããããªã¬ãŒã«ããŠçºç«ãã§ãããšããã®ã§ãPower Automate Desktopãšéããããã¯ã°ã©ãŠã³ãã§åŸ æ©ãããŠãããªã¬ãŒã²ãããã®ãåŸ ãŠã
ãšããã®ã§ãçµã¿åãããããé¢çœãäºãã§ãããã§ããã
䜿ã£ãŠã¿ãææ³ãããã°ã«èšèŒããŠãè¯ãã§ããïŒ
akanemaru2017 æ§
è©ŠããŠããã ããŠããããšãããããŸãïŒ
è¿ä¿¡ããããšãããããŸãã
ããã°ã«èšèŒå€§äžå€«ã§ãããããæ²èŒããŠããã ãããå¬ããã§ãïŒ
ä»ã®ãšããããšãããããã£ãŠã¿ãçãªç°¡åãªã¹ã¯ãªãããªã®ã§ãèªåã䜿ã£ãŠãŠäžäŸ¿ãªäºããèŠæãããã°æ¡åŒµããŠãããããªãšæã£ãŠããŸãã
äœãããã°ãç¥ããããã ããŸããã幞ãã§ãã
ãããæ§
èšäºã«è¿œå ããŠã¿ãŸããããšã£ãŠãã·ã³ãã«ã§ç°¡åã§ãéåžžã«è¯ãã¹ã¯ãªããã§ãããã¿ã¹ã¯ã¹ã±ãžã¥ãŒã©ããã®åŒã³åºãã§ãé£ãªãå®è¡ã§ããŸããã
VBAãä»ã®ããã°ã©ã ãããåçŽã«EXEãšåŒæ°ã ãã§è¡ããã®ã§ãVBAããã®æµãã§åŒã³åºããããPythonã§åŠçããåŸã«PADã§åŠçãããã¿ãããªããšãã§ãããã§ããã
ããã°ã㯠ç¡åçPower Automateã§æ¯æ1åãªã©ãããªã¬ãŒã«ããŠçºç«ããããšãæ€çŽ¢ããŠãã©ãçããŸããã
> UWSCã䜿ã£ãŠãããŒãå®è¡
> https://bit.ly/3CSj63m
>äŸãã°ãããã¹ããšãã£ã¿ã«è²Œãä»ããŠããããŒåã ããèªåã®PADã®ãããŒåã«æžãæããŠãæ¡åŒµåBATã§ä¿åãã
ã§ããããŒåã挢åãå«ãå ŽåããããŒåãæžããbatãã¡ã€ã«èªäœãSHIFT-JISã§ä¿åããªããšãèŠã€ãããŸããããšåºãŠå®è¡ã§ããŸããã
ããºã°ããšãããŸãã瀟å äºååŠçãç°¡çŽ åã§ããªãããšå匷äžã§ãã
äžã§èª¬æãããŠããéœéåºçå¥ã®æ¯ãåãçãšã£ãŠãåèã«ãªããŸãã
åæ©çã§ç³ãèš³ãªããã§ããããåãã§ãããããšæãã³ã¡ã³ãããŸãã
å æ¥äœæãããããŒãå®è¡ããããšPowerAutomateDesktopãèµ·åãã
ä¿åæžã®ãããŒãç·šéããããšãããšãæºåããŠããŸããã®ã¡ãã»ãŒãžåŸã
ãéä¿¡ãšã©ãŒïŒã³ã³ãœãŒã«ãšãã¶ã€ããŒéã®æ¥ç¶ã確ç«ãããŸããã§ããã
Power Automate Desktop ãåèµ·åããŠãããäžåºŠå®è¡ããŠãã ããã
é¢é£ä»ãIDïŒcca90c78-a8c3-4445-adb7-c10c9e86ac3cãïŒâã¯ãªãã
ããŒããžã³ããŒâããŒã¯ãšOKãã¿ã³ããšåºãŠããç·šéç»é¢ãéããŸãã
éããŸããããããŒãå®è¡ããããšãã¹ããŒã¿ã¹ïŒè§£æäžã
ã®ãŸãŸãäœãå§ãŸããªããã延ã 解æãããŸãŸã§ãã
åœåä¿åããã®ãšç°ãªããã€ã¯ããœããã¢ã«ãŠã³ãã§æäœããããšããŠãã
ã®ã§äžæŠãã°ã¢ãŠãããå床ãã°ã€ã³ããªãããŠãåæ§ã§ããã
ãªããªãçŽ äººã«ã¯é£ããã§ãããç¥æµã貞ããŠããã ããã°å¹žãã§ãã
ã¿ããã¡æ§
officeã®æ管ç人ã§ãã
ã¢ã«ãŠã³ããå人ã¢ã«ãŠã³ããªã®ãïŒMicrosoft365ã¢ã«ãŠã³ããªã®ãããããªãã®ã§ããªããšãèšããªãã®ã§ãããããæè¿ã¢ããããŒãããåŸãšããããšãªãã°ããã®ãšã³ããªãŒã®éäžã«ãã
ãåã€ã³ã¹ããŒã«åŸã«ãšã©ãŒé »çºããåèã«ãäžæŠãã¢ã³ã€ã³ã¹ããŒã«ãããŠæ®ã£ãŠããŽããã¡ã€ã«ãåé€ããå床ææ°çãå ¥ãçŽããŠãããåæ§ã®äœæ¥ããã£ãŠã¿ãŠãã ããã
Power Automate Desktopã¯ãŸã ãŸã ãã®ãŒãªé¢ããããç¹ã«ã¢ããçŽåŸã¯ãã®ãããªäžå¯è§£ãªãšã©ãŒãåºãŠããŸãããŸããã³ãŒãã¯ããã¹ããã¡ã€ã«ã«ã³ããã§åã£ãŠãããã®ã§ãäžãäžã®çºã«ãããã£ããäœã£ãã³ãŒããä¿åãããçµããããšã®ãªãããã«ãåã£ãŠãããšè¯ãã§ãããã
ãã¡ãã§ãåæ§ã®è³ªåãåºãŠããŸããã
å人ã®Microsoftã¢ã«ãŠã³ãã§ä»ç¢ºãããŠã¿ãŸããããææ°çã§ã¯ç¹ã«ãšã©ãŒãåºãŠããªãã®ã§ããããããšãããå€ãããŒãžã§ã³äœ¿çšã«ããåé¡ããããã¯OneDriveããã£ã±ãã«ãªã£ãŠããªã©ã®åé¡ã®ã©ã¡ããã§ã¯ãªãããšã
ãé£çµ¡é ããªããŸããŠãã¿ãŸãããåçããããšãããããŸãã
ããããpowerautomatedesktopåã€ã³ã¹ããŒã«ããŠåé¡ãªã䜿ããŠããŸãã
äœãã©ãã ãã ã£ãã®ãããããããŸãããåããã®ã§ãšã·ãšããŠããŸãã
ïŒPC ã¯ããŒã«ã«ã¢ã«ãŠã³ãã§ãã°ãªã³ããŠããŠãPAD䜿çšæã«éœåºŠãã€ã¯ããœããã¢ã«ãŠã³ãã«ãã°ãªã³ããŠããŸãïŒ
powerautomateã®ç¡åçïŒdesktopïŒã¯ããããŒã®å ±çšãã§ããªãããšããããšã§ãïŒå°ã®PCïŒãšãã«ããŒã«ã«ã¢ã«ãŠã³ãã§èµ·åïŒã§
â PC_ãã€ã¯ããœããã¢ã«ãŠã³ãïŒmizuãã§é垞䜿çš
â¡PC_ãã€ã¯ããœããã¢ã«ãŠã³ãïŒnajiãã§é垞䜿çš
ããšããŠãããšããã«ã
â ã®PCã§â¡ã®najiã¢ã«ãŠã³ãã§PADã®ãããŒ:a)ãäœæã»ä¿åãã
â¡ã®PCã§â¡ã®najiã¢ã«ãŠã³ãã§ãã°ãªã³ããŠãããŒ:a)ã䜿ãã
ã§ããšãã¯ãããŠã¯ãã¡ãªãã§ããããïŒ
ãªãã ã説æãããã¥ããã§ãããå¥ããœã³ã³ã§åäœç¢ºèªããŠå®çšŒåã¯å¥PCã§ããšããããšã§ã
PADãã®ãã®ãèµ·åãããšãã«ãšã©ãŒïŒãµã€ã³ã€ã³äžã«ãšã©ãŒãçºçããŸããã管çè ã«ãååãäžããïŒãâ¡ã§åºãŸããããã¯äžäœïŒïŒïŒ
éœåºŠãã°ã€ã³ããããããã§ãããïœããªããŠãããé©åœãªåŠçã§ã¯ãã¡ã¿ããã§ãã
ãªããªã奥深ãã§ãã
ã¿ããã¡ãã
ãã¯ããããããŸãã
PADã¯æªã é²åäžæ ãç¹ã«åæãã䜿ã£ãŠã人ã®å Žåãã¢ããæã«ãã©ãã«ãåºãã¡ãªã®ã§ããã®éã¯åã€ã³ã¹ããŒã«ãäžçªå¹æããããŸãã
ããŠããããŒå ±æã§ããããããããããŒã¯ã¢ã«ãŠã³ãã«çŽä»ããããŠãå®è¡æã«ããŠã³ããŒãïŒOneDriveãDatavarseããïŒãããŠå®è¡ãããã®ã§ãã¿ããã¡ããã®äœ¿ãæ¹ã§åé¡ãªãã§ãã
å ±æã¯äžäœãã©ã³ã«ãªããŸããããšã³ããªãŒã«ãããããã«ããããŒãã³ããã§æž¡ãäºã¯ã§ããã®ã§ãæéã§ã¯ãããŸãããå®æåãªãã°éãã¢ã«ãŠã³ãã«ãããŒãããã¹ãããªã«ãã§æž¡ããŠãæ§ç¯
ããŠãããã°OKã§ãã
èµ·åããæã®ãšã©ãŒãPCâ¡åŽã®PADãäžåºŠåã€ã³ã¹ããŒã«ããŠã¿ããšè¯ããšæããŸãïŒéåžžã®MSã¢ã«ãŠã³ããšäŒæ¥ã¢ã«ãŠã³ãã®åãæ¿ããæ¬æ¥ã¯ã§ããã¯ãã§ããïŒ
ã¿ããã¡ã§ã
ã³ã¡ã³ãè¿ä¿¡ããããšãããããŸããäžèšã®äžå ·åã§ããçŸæ®µéã§ã®ææ°ããŒãžã§ã³ïŒ2.121.7121216ïŒãåã€ã³ã¹ããŒã«ããŠè§£æ¶ãããŸããã
PowerAutomateCommunityã§ããšãèŠãŠããŠããããŒãžã§ã³ã¢ããåŸ ã¡ãŸããïœãã¿ãããªæžã蟌ã¿ããããŸããããã£ã±ããªïŒã§ãã
ãçžè«ããã ããŸããŠããããšãããããŸããä»åŸãåèã«ãããŠããããŸãã
ã¿ããã¡æ§
ç¡äºã«ãªããšããªã£ãããã§è¯ãã£ãã§ãã
ãŸã ãŸã βççãªç«ã¡äœçœ®ã§ãããç¶ã ãšæ°æ©èœãšç¬ç¹ãªæ©èœãè¿œå ãããŠããŠãã®ã§ããããŸã§ã®RPAãšã¯ãŸãéã£ããã®ã«ãã©ãã·ã¥ã¢ãããããŠããã®ã§ã¯ãªãããšæããŸããã
åæã«å€ãªæåããããšæãã®ã§ãã¢ããããŒãã¯æ éã«ãã§ããã