ãŸãð
æè¿ã®èšäº
- åºå®ãããèšäº
Power Automate for desktopã§ãºã³ãã³ãããåé¡ãã£ãŠã¿ãããã·
掟é£å ã§äž»å¬ããŠããWinActorã®å匷äŒã§ãã©ããªãã¿ãç·Žç¿åé¡ã«ãããããªïœãšèããŠããŠFizzBuzzåé¡çãªãã®ãæ€çŽ¢ããŠããããããºã³ãã³ãããåé¡ããªããã®ãçºèŠðâš ãªã«ãã é¢çœããð€€ æ°å¹Žåã«æµè¡ã£ããã®ã¿ããã§ããïœïŒ äŒç€Ÿã§ã¯WinActorã§ãã£ãèš³ã§ãããä»åã¯ãããPower Automate for desktopã§ãã£ãŠã¿ãŸããðµ â ãºã³ãã³ãããåé¡ãšã¯ããºã³ãããºã³ãããºã³ãããºã³ãããã³ããšããå€æ°ãæºå 1ãã©ã³ãã ã«äžŠã¹æ¿ã
錻ãããã®ãªãã¡ã¬ããè²·ã£ãŠã¿ãããã·
æè¡ãã¿ãããªããã§ããã©ãæ°ã«ãªã£ãŠãã人ãããããªãšæãã¢ãŠããããããŠã¿ãŸãð ç®ãæªãã®ã§ãã¡ã¬ããã³ã³ã¿ã¯ããå¿ é ã§ãã çµæ§èŠåãæªãã®ã§ãã¡ã¬ããããããšãã«ç®ãå°ãããªãã®ãå«ãªãã§ã𥺠è¿èŠã®ã¡ã¬ãã¯ãç®ãšã®è·é¢ãããããç®ãå°ãããªãã ã ãã錻ããããäœãã¿ã€ãã®ã¡ã¬ããéžãã§ãããã ãã©ãããããã錻ãããããªãã¡ã¬ããããã°ããã®ã«âŠããšèšããªããã¡ã¬ãå±ããããããããšããŠãããããŸããååšãããªããŠïœ ã錻ãããã®ãªãã¡ã¬ãã â 錻ãã
ãèªåã¡ã¢ããŸãçPCèšå®
PCå€ãããšãã㣠ãã®èšå®ããªãããªãããªã®ããã㣠ããããã£ãŠãªã£ãã®ã§ãèªåçšã¡ã¢Ï(o)  ããŸã Windows10ã§ããããŸã11ã«ãªã£ãŠã12ã«ãªã£ãŠããããããããšã¯å€ãããã§ãããã â PCèšå®ç³»ã¿ã¹ã¯ã㌠å°ããã¿ã¹ã¯ããŒãã¿ã³ã䜿ãïŒON ã¿ã¹ã¯ããŒãã¿ã³ãçµåããïŒçµåããªã ã¿ã¹ã¯ããŒ(ãã«ããã£ã¹ãã¬ã€) ä»ã®ã¿ã¹ã¯ããŒã®ãã¿ã³ãçµåããïŒçµåããªã IMEèšå® IMEå ¥åã¢ãŒãåæ¿ã®éç¥ïŒç»é¢äžå€®ã«è¡šç€ºããOFF
365ç°å¢ãªããCELLÃTEXTAFTERé¢æ°ã䜿ã£ãŠã·ãŒãåãååŸããããšãã§ãããã ïŒã®ããã·
Excelã®ã·ãŒãåã®ååŸã£ãŠããªããŒãé¢æ°æžããªããšãããªããŠããã©ãããã§ããã𥺠ãã€ããããã§æ€çŽ¢ããŠãã³ãããããŠããã ãã¢ã¬ã§ãã ãã®æžãæ¹ã®å€§åæãšããŠããã©ã«ãããã¡ã€ã«åã« [] ã䜿ãããŠããªãããšãšããæ¡ä»¶ããããŸãïŒã·ãŒãåã«ã¯ [] ã¯äœ¿çšã§ããŸããïŒã 365ç°å¢ãªã䜿ããæååæäœç³»ã®é¢æ°ã䜿ã£ããããã£ãšã·ã³ãã«ã«æžãããšæããŠããã£ãã®ã§ãã£ãŠã¿ãŸããâ â»ããã365ç°å¢ãªã®ã«ããã®é¢æ°ãªãããŒðŠãã£ãŠæ¹ããã£ããã£ããããã¡ã
- åºå®ãããèšäº
ãã¬ãžã³
èšäº
Microsoft365ã®Excelçãææ°ã«ã¢ããããŒãããŠãææ°ã®é¢æ°ã®å ¥æãšCSVãéãããšãã«é ã®0ãæ¶ããªãããã«ããŠã¿ãããã·
ãªãã§ç§ã®ç°å¢ã«ã¯ãTEXTJOINé¢æ°ã¯ããã®ã«TEXTBEFOREé¢æ°ãšãTEXTAFTERé¢æ°ãšãããªããã ããã£ãŠæã£ãŠã⊠ãµãšäŒç€Ÿã§æããŠããã£ãããšã«æãåœããã ãæŽæ°ãïŒïŒïŒã ãšããããã§ãæåã§æŽæ°ãããŠã¿ãŸãã(*'Ï'*) ãã䜿ãExcelããæäœã ExcelãããéããŠãå·Šäžã®ããã¡ã€ã«ããã ãã¢ã«ãŠã³ãããéã㊠ããïŒãä»ããæŽæ°ãã ã©ããã§ãããšãä»ã®ã¢ããªãäžç·ã«æŽæ°ããŠãããã¿ããã ãã㊠ãŸãã¯TEXTAFTE
ããŒãã«ã®åã«ååãå®çŸ©ããŠãSORTBYé¢æ°ããã£ãããããŠã¿ãããã·
ãPower Queryã§å ããŒã¿ãäœã£ãŠããããFILTERé¢æ°ãšSORTé¢æ°ã§ä»ã®ã·ãŒãã«éšçœ²å¥ã«äžŠã¹æ¿ããŠåºåããããšããããšããããã£ãŠããŸãã åŒãå ¥ãåã«ãªãã®ã§ã©ãããŠãé·ããªã£ãŠããŸããèŠã«ãããªïœð€ååã®å®çŸ©ããŠããããŠæ¯æããã ãçŽãã°ããããã«ãããïœãšæã£ãŠãããŸããã SORTãšSORTBYã®éããããŒãã«ã«ããŠããã°ããŒãã«ã®ååã§ååã®å®çŸ©ãã§ããããšãæããŠããã ããã®ã§ããã£ãŠã¿ãŸãâ ãããªããŒãã«ã売äžäžèŠ§ããçšæããŠãããŸãã
Power Automate for desktopã§ããã€ã䜿ããã®ãèµ·åããŠãŠã£ã³ããŠãé 眮ããŠã¿ãããã·
ãã³ãã¯ããããã¿ã«ããããšæã£ãŠããã®ã§ããïœ ã¯ã©ãŠããããŒã®æ°ãããã¶ã€ããŒã®ä»æ§ã¯ãå€åã倧ããããã®ã§ãããŠãããŸãïœ ã¡ããã©ãã£ãŠã¿ããããšããã£ãã®ã§ãããã®æ€èšŒããŠã¿ãŸãããŒïŒð ãã€ã3ç»é¢ã§PC觊ã£ãŠããŸãã éããã®ããŠã£ã³ããŠã®é 眮ãããã€ã決ãŸã£ãŠãããã§ãããã èµ·åã¯ã¹ã¿ãŒãã¢ããã«å ¥ããŠããã®ã§ããããããããã«ããããã®ãŠã£ã³ããŠã§ããæãã®ãµã€ãºæã§é 眮ãŸã§ããŠããããããŒããPADã§äœã£ãŠã¿ãŸããðïŒãšããããä»noteæžããªã
Power Queryã§åºåãããå Žæ以å€ã«åºåãæåãå ¥ã£ãŠãããšãã«ãå°åãã«åºåã£ãŠã¿ãããã·
ãªãã®ãã£ã¡ããªã¿ã€ãã«ïœ X(æ§Twitter)ã§èŠããããã¹ãã®ãé¡ã ãªãããªãã£ãã®ã§å®éããããããšã®åçã«ã¯ãªã£ãŠããªãã®ãããããªããã©ããã¿ãšããŠé¢çœãã£ãã®ã§ãã£ãŠã¿ãð ãããŠããããªããã¢ããã³ãã«ã¬ã³ããŒãšããðð âš ãããªé¢šã«ã«ã³ãåºåãã«ãªã£ãŠããããŒã¿ãçšæã ã«ã³ããåºåãæåã«ããŠåãåããããã ãã©ãããèŠããšã¡ãŒã«ã¢ãã¬ã¹ã® . ã , ã«æã¡ééããããŠãããšãããããã ãããæ®éã«ã,ãã§äžæ¬ã§åºåããš ãŸãåœç¶ãããªã
Power Automateã®æ°ãã¶ã€ããŒã®ãã£ãŒãããã¯ã翻蚳ããŠéä¿¡ããŠã¿ãããã·
æ°ãã¶ã€ããŒãäœæãããšãã«ããããïŒããã£ãŠâŠããšæã£ããšããMicrosoftããŸã«ãã£ãŒãããã¯ãéä¿¡ããããšãã§ããŸãã ãããŒãã¶ã€ããŒã®å³äžã«ããããã£ãŒãããã¯ãéä¿¡ãããããéããŸãã éããšãããªæãã ãã£ãè±èªð± Edgeã®ç¿»èš³ã䜿ãããšæã£ãã®ã§ãããããŸãæ©èœããªãã£ãã®ã§Google翻蚳ããŸã«ç¿»èš³ããŠããã£ãã¡ã¢ã次ã«ãã£ãŒãããã¯ãéä¿¡ãããšãã®ããã«æ®ããŠããð ãã§ã«ããããã®ãã£ãŒãããã¯ãéä¿¡ãããŠããã®ã§ããã§ãã¯é ç®ã¯å¯ãã
æ°ãã¶ã€ããŒãšæ§ãã¶ã€ããŒã®ãæ°ããå¿çãéä¿¡ããããšããããªã¬ãŒã®ä»æ§ãéãããã·
ãã©ãã¯ãŒããã®ãã¹ãã§ç¥ã£ãããšã æ°ãã¶ã€ããŒã ãšãApply to each ã For each ãªãã§ããã PADã«åãããã®ããªïŒ ä»ã¯æ°ãã¶ã€ããŒãžã®ç§»è¡æã§ãæ°èŠäœææã®äœæç»é¢ã¯æ°ãã¶ã€ããŒã«ãªãã ããã«ãçŽæã®ãå¿çã®è©³çŽ°ãååŸãããã¢ã¯ã·ã§ã³ãå ¥ããŠãå¿çIDãèšå®ãããšãFor each ã«å²ãŸããä»æ§ã«ãªã£ãã®ã ð³ ã¡ãªã¿ã«æ§ãã¶ã€ããŒã ãšããããªæãã ãžãŒããã§ã䜿çšé »åºŠãé«ã ãã®ããªã¬ãŒã®ä»æ§ãå€ããã®ã¯ãã¡ãã£ãšå°ãð ãäœ
Power Queryã§æ¥ä»ã«å€æããŠãããå€ã®ããã·
Power Queryã®åã®å€æŽã§æ¥ä»ã«ãããšãããã£ð³ãããæ¥ä»ã«å€æããŠããããã ïŒãšæã£ãããšããã£ãã®ã§ãæ€èšŒããŠã¿ãã ãŸãã¯æ®éã«æ¥ä»ã®åœ¢ãæžåŒèšå®ã¯æ¥ä»ãšæååã æžåŒèšå®ãæ¥ä»ã ãšãæå»ãäžç·ã«ä»ããŠæ¥ãã åã®å€æã¯åé¡ãªãã æžåŒèšå®ã§ææ¥ãŸã§å ¥ããŠã¿ããæååãåãããã«å ¥åã æ¥ä»ã®æ¹ã¯ãã£ããšåããæååã¯å ¥åã®ãŸããŸã æåã§ææ¥å ¥ããŠããã¡ãããšæ¥ä»ã«ããŠãããð ããããééã£ãææ¥å ¥ãããã©ããªããã ã(â§èžâŠ*) ãš
PnP PowerShellãšããã䜿ã£ãŠãªã¹ãã®åãäœæããããšããããè²ããªãšããã§ã€ãŸã¥ããããã·
Power Automateã§æ±ããšãã«èŠãããããã«ããªã¹ããäœããšãã¯å ã«è±èªã§äœã£ãŠãããåŸããæ¥æ¬èªã«ããã ããããäœæ³ãªãã ãã©ããã£ã±ãããã©ãããŒãïŒ ãªãã楜ã«ã§ãããããã®ã«ãªãŒãšæã£ãŠãããããªãªãããããã¿ã€ã ãªãŒã«çŽ æµãªèšäºããããŠãã ãã£ãð€€ ãªããšãããã°ããç§ã PnP PowerShellã䜿ããã§ãã£ãŠãã»ã»ã»ãïŒ ç¥ãããã£ãð€£ PowerShellãšãã£ãããããã®ããšã ãšæã£ãŠãð€£ð€£ ãã¡ããåèã«ã€ã³ã¹ããŒã«ã«ãã£ã¬ã³ãž
Teamsã®å ±æãã£ãã«ã®æ€èšŒãããŠã¿ãããã·
Teamsã®å ±æãã£ãã«ã ãªã«ãã䟿å©ãªãã®ãããã ã©ããªãã®ãªã®ããã¡ãããšæ€èšŒããŠã¿ãð€ çµçéšãšåæ¯åºã®éã«ã確èªçšã®ãã£ãã«ãå 容å¥ã«äœãããšãæ³å®ã åå€å±æ¯åºã® ãŸãããæ¯åºé·ã¯ãçµçéšãšã®ããåãçšã®ããŒã ãäœæã çµçéšã® ãŸãçµçéšé·ã¯ãåæ¯åºãšã® ããåãã確èªå 容ããšã«ããŒã ãåãããã ããŒã åã®3ç¹ãªãŒããŒããããã£ãã«ãè¿œå ã å ¥éé¢ä¿ããŒã ã«ãåå€å±æ¯åºçšã®å ±æãã£ãã«ãäœæã è«æ±é¢ä¿ããŒã ã«ãäœæã ãã®å ±æãã£ãã«ããå
Power Automateã§ããã©ãŒã ããå±ããæ·»ä»ãã¡ã€ã«ããªã¹ãã«ä¿åããŠããªã¹ãã®éžæè¢ãå€æŽãããæå®ãããã©ã«ãã«ã³ããŒããŠã¿ãããã·
ã¿ã€ãã«ã«å šè²ãè©°ã蟌ãç§ïœ æ€èšŒããããšã®ã¡ã¢Ï(o)  ãã©ãŒã ã§éä¿¡ãããæ·»ä»ãã¡ã€ã«ããªã¹ãã«ããããããŒã«ã€ããŠã¯ããã¡ãã®ããã°ãåèã«ãããŠããã ããŸããð ãšã£ãŠãããããããã£ãâŠïŒããããšãããããŸãâš ãããªæãã®ã°ã«ãŒããã©ãŒã ãäœæã ãªã¹ãã¯ãããªæãã äžèšã®èšäºãããæ·»ä»ãã¡ã€ã«ã¯å ã ãªã¹ãåŽã§çšæããŠãããŠããåã ãšç¥ã(ÂŽã»â³ã»ïœ)ïŸïŸïœ° ã確èªãããæªããããæžãã«å€æŽããããšãããªã¬ãŒã«å®è¡ãããŠãæå®ããå Žæã«
SharePointãªã¹ãã§ãã¥ãŒã®èšå®ãããŠExcelã«ãšã¯ã¹ããŒãããŠã¿ãããã·
䟿å©ãããªããšãæããŠããã ããã®ã§ãæ€èšŒããŠã¿ãŸããð€€ ããããã°ç§ãPower QueryããSharePointãªã¹ãã«ç¹ãã«è¡ã£ãŠãããã®ãããŸããã©ããããªã«éããæããããšã¯ãªãã§ããð€ ããŒã¿éã®éãããªïŒ å®ã¯ç§ãã以åã«ãã£ã«ã¿ããç¶æ ã§ãšã¯ã¹ããŒããããªãã®ãâŠð¢ãšæãããããŒãçµãããšããŠè«Šããçµç·¯ããããŸããïœ è·å Žç°å¢ã§ã¯ãªããExcelã®ããŒã¿ã®ååŸã¡ãã¥ãŒã«ãSharePointé¢é£ã®ãã®ãçŸããªãã£ããã§ããïœð€ ã¡ãªã¿ã«ããã¯ãç°¡åãª
Power Queryã§SharePointã«ãããã©ã«ãå ã®ãã¡ã€ã«ãçµ±åããŠã¿ãããã·
Power Queryã§ãSharePointã®ãã©ã«ãå ã®ãã¡ã€ã«ãçµ±åããããã ãã© ãããããããªãð¢ å¡Ÿé·ãšOishimiyããããããããæ å ±ãðâš ã§ããã¿ããã âŠïŒð€© SharePointã«ãããªãã©ã«ããçšæã ãã®ãã©ã«ãå ã«ãããã¡ã€ã«ãçµ±åããŸãã Power Queryã§ãããŒã¿ååŸããŠè¡ããŸããïœïŒ éžæããã®ã¯ãSharePointãã©ã«ããŒããã ãã®ã¡ãã¥ãŒããªãå Žåããããã©ããã®å Žåã¯Mèšèªã§æžãã°OKðââïž ããã«ã¯ãSh