PAD Mod

/# 【処理概要】

指定のフォルダに指定のファイル名でスクリーンショットを保存する。#/

SET strLogMessage TO $'''>Start - Mod_TakeScreenShot , in_strSaveSSDir : %in_strSaveSSDir% , in_strSSFileName : %in_strSSFileName%'''

CALL メッセージをログ_Info

BLOCK TakeScreenShot

ON BLOCK ERROR

SET out_isSuccess TO False

SET strLogMessage TO $'''スクリーンショットの取得に失敗しました。'''

CALL メッセージをログ_Error

THROW ERROR

END

/# ◆エラー発生時

out_isSuccess = False

メッセージをログ#/

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDataTime

Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDataTime CustomFormat: $'''yyyy-MM-dd-_HH-mm-ss''' Result=> strNow

@@flowname: '【共通テンプレート】Cmn_Check-CreateDirectory'

External.RunFlow FlowId: '5d16ca20-663a-4dbc-825c-de0faa746c86' @in_strCheckDir: in_strSaveSSDir @in_isCreateFlag: True @in_strLogFile: $'''''' @out_isCheckResult=> out_isCheckResult2

SET strSavePath TO $'''%in_strSaveSSDir%\\%strNow%_%in_strSSFileName%.jpg'''

Workstation.TakeScreenshot.TakeScreenshotAndSaveToFile File: strSavePath ImageFormat: System.ImageFormat.Jpg

ON ERROR REPEAT 5 TIMES WAIT 2

END

SET out_isSuccess TO True

END

SET strLogMessage TO $'''>End - Mod_TakeScreenShot , out_isSuccess : %out_isSuccess%'''

CALL メッセージをログ_Info

/# 【処理概要】

セルアドレスを列番号と行番号に分割する。

単一セルでもセル範囲でも可能。#/

BLOCK セルアドレス分割

ON BLOCK ERROR

SET strLogMessage TO $'''セル分割に失敗しました。(Mod_SplitCellAddress)'''

CALL メッセージをログ_Error

END

Text.Replace Text: in_strCellAddress TextToFind: $'''$''' IsRegEx: False IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> in_strCellAddress

Text.SplitText.SplitWithDelimiter Text: in_strCellAddress CustomDelimiter: $''':''' IsRegEx: False Result=> listAddress

**REGION 開始セルを設定

Text.Replace Text: listAddress[0] TextToFind: $'''[+-]?\\d+''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> out_strColumn_From

Text.Replace Text: listAddress[0] TextToFind: $'''[a-zA-Z]''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> out_strRow_From

**ENDREGION

IF NotContains(in_strCellAddress, $''':''', False) THEN

**REGION 終了セルにブランクを設定

SET out_strColumn_To TO $'''%''%'''

SET out_strRow_To TO $'''%''%'''

**ENDREGION

ELSE

**REGION 終了セルを設定

Text.Replace Text: listAddress[1] TextToFind: $'''[+-]?\\d+''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> out_strColumn_To

Text.Replace Text: listAddress[1] TextToFind: $'''[a-zA-Z]''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> out_strRow_To

**ENDREGION

END

SET strLogMessage TO $'''%in_strCellAddress%分割 ⇒ %out_strColumn_From% , %out_strRow_From% , %out_strColumn_To% , %out_strRow_To% (Mod_SplitCellAddress)'''

CALL メッセージをログ_Info

/# 【処理概要】

指定したリストのファイルをSharePointへアップロードする。

新旧の表示形式に対応。#/

SET strLogMessage TO $'''>Start - Mod_SharePoint_FileUpload'''

CALL メッセージをログ_Info

BLOCK 'SharePoint ファイルアップロード'

ON BLOCK ERROR all

SET out_isSuccess TO False

SET strLogMessage TO $'''ファイルアップロードに失敗しました。'''

CALL メッセージをログ_Error

THROW ERROR

END

WebAutomation.LaunchEdge.LaunchEdge Url: in_strSharePointURL WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False WaitForPageToLoadTimeout: 60 Timeout: 60 BrowserInstance=> Browser

UIAutomation.FocusWindow.FocusByInstanceOrHandle WindowInstance: Browser

IF (WebAutomation.IfWebPageContains.WebPageContainsElement BrowserInstance: Browser Control: appmask['Web Page \'h ... 29F02BC7CA\'']['Span \'従来の SharePoint の表示に戻す\'']) THEN

CALL '【New】SharePointファイルアップロード'

ELSE

CALL '【Classic】SharePointファイルアップロード'

END

WebAutomation.CloseWebBrowser BrowserInstance: Browser

SET out_isSuccess TO True

END

SET strLogMessage TO $'''>End - Mod_SharePoint_FileUpload , out_isSuccess : %out_isSuccess%'''

CALL メッセージをログ_Info

# [ControlRepository][PowerAutomateDesktop]

{

"ControlRepositorySymbols": [

{

"IgnoreImagesOnSerialization": false,

"Repository": "{\r\n \"Screens\": [\r\n {\r\n \"Controls\": [\r\n {\r\n \"AutomationProtocol\": \"uia3\",\r\n \"ScreenShot\": null,\r\n \"ElementTypeName\": \"Span\",\r\n \"InstanceId\": \"3414d010-9c0a-4cce-944e-8bb981c3d8b1\",\r\n \"Name\": \"Span '従来の SharePoint の表示に戻す'\",\r\n \"SelectorCount\": 1,\r\n \"Selectors\": [\r\n {\r\n \"CustomSelector\": null,\r\n \"Elements\": [\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Body 'メインコンテンツにスキップif(!spfxPerfMarks){var spfxPerfMarks ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"body\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"isFluent xxxlg od--isNonMobile od-focus--enabled\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'SharePoint多田淑八STサインイン SharePoint スタートページマイサイト ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"spoAppComponentFlex\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"spoAppComponent\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'SharePoint多田淑八STサインイン SharePoint スタートページマイサイト ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"ms-Fabric SPOApp root-40\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"appRoot\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'SharePoint スタートページマイサイト自分のニュース自分のファイルマイリスト ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Files sp-App-root has-footer is-active od-userSelect--enabled sp-WebViewList-enable sp-fullHeightLayouts\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'SharePoint スタートページマイサイト自分のニュース自分のファイルマイリスト ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"sp-App-bodyContainer\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'SharePoint スタートページマイサイト自分のニュース自分のファイルマイリスト ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"sp-App-body\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'PAD検証_kojimaPAD検証_kojima プライベートグループフォローし ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"sp-App-bodyMain\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'PAD検証_kojimaPAD検証_kojima プライベートグループフォローし ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Files-main\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'PAD検証_kojimaPAD検証_kojima プライベートグループフォローし ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Files-mainColumn\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'ホームスレッドドキュメント自分たちと共有ノートブックページLibraryPADTES ... 範囲の切り替え種類種類名前更新日時更新者列の追加General8月22日小嶋可南江'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"sp-App--hasLeftNav\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'ホームスレッドドキュメント自分たちと共有ノートブックページLibraryPADTEST項目アイテム追加テストサイトコンテンツごみ箱編集従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Files-leftNav Files-leftNav-suiteNavSearch\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'ホームスレッドドキュメント自分たちと共有ノートブックページLibraryPADTEST項目アイテム追加テストサイトコンテンツごみ箱編集従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"LeftPane LeftPane--hasNotifications LeftPaneVisible\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'ホームスレッドドキュメント自分たちと共有ノートブックページLibraryPADTEST項目アイテム追加テストサイトコンテンツごみ箱編集従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"ms-Fabric root-40\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'ホームスレッドドキュメント自分たちと共有ノートブックページLibraryPADTEST項目アイテム追加テストサイトコンテンツごみ箱編集従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div 'ホームスレッドドキュメント自分たちと共有ノートブックページLibraryPADTEST項目アイテム追加テストサイトコンテンツごみ箱編集従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"LeftPane-notifications\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div '従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div '従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"LeftNav-subLinksClip\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div '従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"LeftNav-subLinks\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Div '従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"div\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"LeftNav-notificationLink\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Href\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"#\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": true,\r\n \"Name\": \"Anchor 'クリックするか Enter キーを押して、SharePoint のクラシック表示に戻る'\",\r\n \"Tag\": \"a\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"LeftNav-linkText\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Title\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": null\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Text\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"従来の SharePoint の表示に戻す\"\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Span '従来の SharePoint の表示に戻す'\",\r\n \"Tag\": \"span\"\r\n }\r\n ],\r\n \"Ignore\": false,\r\n \"IsCustom\": false,\r\n \"IsWindowsInstance\": false,\r\n \"Name\": \"Default Selector\",\r\n \"Properties\": []\r\n }\r\n ],\r\n \"Tag\": \"span\",\r\n \"ScreenshotPath\": \"controlRepo-screenshots\\\\dbf587f5-5db6-4db5-b80c-b62103238248.png\"\r\n }\r\n ],\r\n \"ScreenShot\": null,\r\n \"ElementTypeName\": \"Web Page\",\r\n \"InstanceId\": \"7d9fa16d-0198-423e-9e32-fc277af14e2a\",\r\n \"Name\": \"Web Page 'h ... 29F02BC7CA'\",\r\n \"SelectorCount\": 1,\r\n \"Selectors\": [\r\n {\r\n \"CustomSelector\": null,\r\n \"Elements\": [\r\n {\r\n \"Attributes\": [],\r\n \"CustomValue\": \"domcontainer\",\r\n \"Ignore\": false,\r\n \"Name\": \"Web Page 'https://sharepoint.com/sites/PAD/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2Fsites%2FPAD%5Fkojima%2FShared%20Documents%2FGeneral&FolderCTID=xxxxxx\",\r\n \"Tag\": \"domcontainer\"\r\n }\r\n ],\r\n \"Ignore\": false,\r\n \"IsCustom\": false,\r\n \"IsWindowsInstance\": false,\r\n \"Name\": \"Default Selector\",\r\n \"Properties\": []\r\n }\r\n ],\r\n \"Tag\": \"domcontainer\",\r\n \"ScreenshotPath\": \"controlRepo-screenshots\\\\be8b89a4-d760-469e-891a-a15c5d2f30b8.png\"\r\n }\r\n ],\r\n \"Version\": 1\r\n}",

"ImportMetadata": {

"DisplayName": "ローカルコンピューター",

"ConnectionString": "",

"Type": "Local",

"DesktopType": "local"

"Name": "appmask"

}

"ImageRepositorySymbol": {

"Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}",

"ImportMetadata": {},

"Name": "imgrepo"

"ConnectionReferences": []

}

/# 【処理概要】

MS Office Outlook を使ってのメール送信処理を行う。

※UiPath版の入力引数でディクショナリ型となっているものはkeyのリストが追加で必要となる。#/

SET strLogMessage TO $'''>Start - Mod_SendMailAdvanced'''

CALL メッセージをログ_Info

BLOCK SendMailAdvanced

ON BLOCK ERROR

SET out_isSuccess TO False

END

**REGION 特定文字列の置換

IF IsNotEmpty(in_dicRepWord) THEN

LOOP FOREACH key IN in_listRepWordKey

Text.Replace Text: in_strSubject TextToFind: $'''<%key%>''' IsRegEx: False IgnoreCase: False ReplaceWith: in_dicRepWord[key] ActivateEscapeSequences: False Result=> in_strSubject

Text.Replace Text: in_strBody TextToFind: $'''<%key%>''' IsRegEx: False IgnoreCase: False ReplaceWith: in_dicRepWord[key] ActivateEscapeSequences: False Result=> in_strBody

END

**ENDREGION

**REGION ハイパーリンクの置換

IF IsNotEmpty(in_dicRepHyperLink) THEN

LOOP FOREACH key IN in_listRepHyperLinkKey

Text.Replace Text: in_strBody TextToFind: $'''<%key%>''' IsRegEx: False IgnoreCase: False ReplaceWith: $'''<a href=\'%in_dicRepHyperLink[key]%>%in_dicRepHyperLink[key]%</a>''' ActivateEscapeSequences: False Result=> in_strBody

END

**ENDREGION

**REGION データテーブルのHTMLタグ変換・置換

IF IsNotEmpty(in_dicRepTable) THEN

LOOP FOREACH key IN in_listRepTableKey

SET isHeader TO False

LOOP FOREACH col IN in_dicRepTable[key].Columns

IF Contains(col, $'''Column''', False) THEN

SET isHeader TO False

ELSE

SET isHeader TO True

EXIT LOOP

END

@@flowname: '【共通モジュール】Mod_DataTableToHTMLTable'

External.RunFlow FlowId: 'a9e334c2-3186-4229-84be-f1e624027cbf' @in_dtConvertTable: in_dicRepTable[key] @in_isHeader: isHeader @in_strStyle: in_strStyle @out_strTableTag=> strTableTag

Text.Replace Text: in_strBody TextToFind: $'''<%key%>''' IsRegEx: False IgnoreCase: False ReplaceWith: strTableTag ActivateEscapeSequences: False Result=> in_strBody

END

**ENDREGION

**REGION メール送信

SET in_strBody TO $'''<pre>%in_strBody%</pre>'''

IF in_isSendMail = True THEN

@@flowname: '【共通モジュール】Mod_SendMail'

External.RunFlow FlowId: 'bf9e5cba-b390-469a-8320-c341afe476b9' @in_strTo: in_strTo @in_strCC: in_strCC @in_strBCC: in_strBCC @in_strSubject: in_strSubject @in_strBody: in_strBody @in_strStartTag: $'''''' @in_strEndTag: $'''''' @in_strAttachFilePath1: in_strAttachFilePath1 @in_strAttachFilePath2: in_strAttachFilePath2 @in_strAttachFilePath3: in_strAttachFilePath3 @in_strAttachFilePath4: in_strAttachFilePath4 @in_strAttachFilePath5: in_strAttachFilePath5 @in_strFromAccount: $'''''' @in_strLogFile: in_strLogFile @out_isSuccess=> out_isSuccess

ELSE

@@flowname: '【共通モジュール】Mod_SaveDraftMail'

External.RunFlow FlowId: '73586ae4-5441-ee11-bdf3-6045bd68f3e4' @in_strTo: in_strTo @in_strCC: in_strCC @in_strBCC: in_strBCC @in_strSubject: in_strSubject @in_strBody: in_strBody @in_strAttachFilePath1: in_strAttachFilePath1 @in_strAttachFilePath2: in_strAttachFilePath2 @in_strAttachFilePath3: in_strAttachFilePath3 @in_strAttachFilePath4: in_strAttachFilePath4 @in_strAttachFilePath5: in_strAttachFilePath5 @in_strLogFile: in_strLogFile @out_isSuccess=> out_isSuccess

END

**ENDREGION

SET out_isSuccess TO True

END

SET strLogMessage TO $'''>End - Mod_SendMailAdvanced , out_isSuccess : %out_isSuccess%'''

CALL メッセージをログ_Info

PAD Mod

Comments