{"id":3063,"date":"2020-05-02T16:32:43","date_gmt":"2020-05-02T07:32:43","guid":{"rendered":"https:\/\/1bed.allright.life\/?p=3063"},"modified":"2020-05-06T18:25:09","modified_gmt":"2020-05-06T09:25:09","slug":"post-3063","status":"publish","type":"post","link":"https:\/\/1bed.allright.life\/?p=3063","title":{"rendered":"SharePoint \u3068 Power Automate \u3067\u7a1f\u8b70\u66f8\u3092\u5b9f\u88c5\u3057\u3066\u307f\u305f\u30e1\u30e2 2"},"content":{"rendered":"

\u7d4c\u7def<\/h2>\n

\u524d\u56de\u306e SharePoint \u3068 Power Automate \u3067\u7a1f\u8b70\u66f8\u3092\u5b9f\u88c5\u3057\u3066\u307f\u305f\u30e1\u30e2 1<\/a> \u3067\u306f\u3001GUI \u3092\u4f7f\u3063\u3066 SharePoint \u4f5c\u3063\u305f\u30b5\u30a4\u30c8\u3068\u30ea\u30b9\u30c8\u306e\u8aac\u660e\u3092\u884c\u3044\u307e\u3057\u305f<\/p>\n

\u4eca\u56de\u306f\u305d\u308c\u3092 CUI \u3067\u4f5c\u6210\u3057\u307e\u3059<\/p>\n

PnP PowerShell \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n

PowerShell \u306f 5.1 \u3092\u5229\u7528\u3057\u3066\u3044\u307e\u3059<\/p>\n

\u307e\u305a\u306f\u3001\u7ba1\u7406\u8005\u3068\u3057\u3066 PowerShell \u3092\u958b\u304d\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059<\/p>\n

Install-Module SharePointPnPPowerShellOnline<\/code><\/pre>\n
\"\"<\/a><\/p>\n
\u30b5\u30a4\u30c8\u3001\u30ea\u30b9\u30c8\u306e\u4f5c\u6210<\/h2>\n
# Credential \u306e\u751f\u6210\n$cred = Get-Credential\n\n# SharePoint Online \u306e URL\n$spoUrl = 'https:\/\/<your-organization-name>.sharepoint.com'\n\n# \u4f5c\u6210\u3059\u308b\u30b5\u30a4\u30c8\u306e URL\n$siteUrl = ('{0}\/sites\/{1}' -f $spoUrl, 'ExampleWorkflow')\n\n# SharePoint Online \u306b\u63a5\u7d9a\n$spoCon = Connect-PnPOnline -Url $spoUrl -Credential $cred\n\n# \u30b5\u30a4\u30c8\u306e\u751f\u6210 (\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u30b5\u30a4\u30c8\u3001\u30c7\u30b6\u30a4\u30f3\u304c\u30c8\u30d4\u30c3\u30af\u3001\u30ed\u30b1\u30fc\u30eb\u3092\u65e5\u672c\u8a9e)\nNew-PnPSite -Title ExampleWorkFlow -Url $siteUrl -type CommunicationSite -SiteDesign Topic -Lcid 1041 -Wait:$false -Connection $spoCon\n\n# SharePoint Online \u304b\u3089\u306e\u5207\u65ad (\u8907\u6570\u306e\u63a5\u7d9a\u3092\u4f7f\u3063\u3066\u3044\u308b\u6642\u306f -Connection $spoCon \u3092\u5fc5\u305a\u3064\u3051\u308b)\nDisconnect-PnPOnline -Connection $spoCon\n\n### \u30b5\u30a4\u30c8\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\n\n# \u4f5c\u6210\u3057\u305f\u30b5\u30a4\u30c8\u306b\u63a5\u7d9a \u203b\u30b5\u30a4\u30c8\u306e\u4f5c\u6210\u304c\u7d42\u308f\u308b\u307e\u3067\u3001\u5c11\u3057\u5f85\u305f\u306a\u3044\u3068\u3044\u3051\u306a\u3044\n$siteCon = Connect-PnPOnline -Url $siteUrl -Credential $cred\n\n# Web \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\n$web = Get-PnPWeb -Includes RegionalSettings.TimeZones -Connection $siteCon\n\n# \u65e5\u672c\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u53d6\u5f97\n$timezone = $web.RegionalSettings.TimeZones | Where-Object Description -Match "(\u6771\u4eac|Tokyo)"\n\n# \u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u65e5\u672c\u306b\u5909\u66f4\n$web.RegionalSettings.TimeZone = $timezone\n$web.Update()\n\n# \u30b5\u30fc\u30d0\u30fc\u306b\u8a2d\u5b9a\u3092\u53cd\u6620\n$ctx = Get-PnPContext\n$ctx.ExecuteQuery()\n$ctx.Dispose()\n\n### \u30b0\u30eb\u30fc\u30d7\u30de\u30b9\u30bf\u30ea\u30b9\u30c8\u306e\u4f5c\u6210\n\n# \u4f5c\u6210\u3059\u308b\u30ea\u30b9\u30c8\u306e\u5185\u90e8\u540d\n$internalListName = 'Lists\/GroupMaster'\n\n# \u30ea\u30b9\u30c8\u306e\u4f5c\u6210 (\u30ab\u30b9\u30bf\u30e0\u30ea\u30b9\u30c8\u3068\u3057\u3066\u4f5c\u6210)\nNew-PnPList -Template GenericList -Url $internalListName -Title '\u30b0\u30eb\u30fc\u30d7\u30de\u30b9\u30bf' -Connection $siteCon > $null\n\n# Title \u306e\u8868\u793a\u5217\u540d\u3092\u5909\u66f4\nSet-PnPField -List $internalListName -Identity 'Title' -Values @{'Title' = '\u30b0\u30eb\u30fc\u30d7\u540d';} -Connection $siteCon\n\n# Add-PnPFieldFromXml \u3067\u4f7f\u3046\u306e\u3067 ListId \u3092\u53d6\u5f97 (\u5f8c\u3067\u3082\u4f7f\u3044\u307e\u3059)\n$groupListId = (Get-PnPList $internalListName -Connection $siteCon).Id\n\n# \u30e6\u30fc\u30b6\u30fc\u307e\u305f\u306f\u30b0\u30eb\u30fc\u30d7\u5217\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8 (\u30e6\u30fc\u30b6\u30fc\u306e\u307f\u3001\u8907\u6570\u9078\u629e)\n$fieldxmlTemplate = '<Field Type="UserMulti" DisplayName="{0}" List="UserInfo" Required="FALSE" EnforceUniqueValues="FALSE" ShowField="ImnName" UserSelectionMode="PeopleOnly" UserSelectionScope="0" Mult="TRUE" Sortable="FALSE" ID="{1}" SourceID="{2}" StaticName="{3}" Name="{3}" \/>'\n\n# \u627f\u8a8d\u8005\u5217\u306e\u4f5c\u6210\nAdd-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f '\u627f\u8a8d\u8005', (New-Guid).Guid, $groupListId.Guid, 'ApprovalUsers') -Connection $siteCon > $null\n\n# \u78ba\u8a8d\u8005\u5217\u306e\u4f5c\u6210\nAdd-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f '\u78ba\u8a8d\u8005', (New-Guid).Guid, $groupListId.Guid, 'ConfirmUsers') -Connection $siteCon > $null\n\n# \u3059\u3079\u3066\u306e\u30a2\u30a4\u30c6\u30e0\u30d3\u30e5\u30fc\u306b\u8ffd\u52a0\u3057\u305f\u5217\u3092\u8868\u793a\nSet-PnPView -List $internalListName -Identity '\u3059\u3079\u3066\u306e\u30a2\u30a4\u30c6\u30e0' -Fields 'LinkTitle','ApprovalUsers','ConfirmUsers' -Connection $siteCon\n\n### \u627f\u8a8d\u7d4c\u8def\u30de\u30b9\u30bf\u30ea\u30b9\u30c8\u306e\u4f5c\u6210\n\n# \u4f5c\u6210\u3059\u308b\u30ea\u30b9\u30c8\u306e\u5185\u90e8\u540d\n$internalListName = 'Lists\/ApprovalPathMaster'\n\n# \u30ea\u30b9\u30c8\u306e\u4f5c\u6210 (\u30ab\u30b9\u30bf\u30e0\u30ea\u30b9\u30c8\u3068\u3057\u3066\u4f5c\u6210)\nNew-PnPList -Template GenericList -Url $internalListName -Title '\u627f\u8a8d\u7d4c\u8def\u30de\u30b9\u30bf' -Connection $siteCon > $null\n\n# Title \u306e\u8868\u793a\u5217\u540d\u3092\u5909\u66f4\nSet-PnPField -List $internalListName -Identity 'Title' -Values @{'Title' = '\u627f\u8a8d\u7d4c\u8def\u540d';} -Connection $siteCon\n\n# Add-PnPFieldFromXml \u3067\u4f7f\u3046\u306e\u3067 ListId \u3092\u53d6\u5f97 (\u5f8c\u3067\u3082\u4f7f\u3044\u307e\u3059)\n$approvalPathListId = (Get-PnPList -Identity $internalListName -Connection $siteCon).Id\n\n# \u53c2\u7167\u5217\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\n$fieldxmlTemplate = '<Field Type="Lookup" DisplayName="{0}" Required="FALSE" EnforceUniqueValues="FALSE" List="{1}" ShowField="Title" UnlimitedLengthInDocumentLibrary="FALSE" RelationshipDeleteBehavior="None" ID="{2}" SourceID="{3}" StaticName="{4}" Name="{4}" \/>'\n\n# \u7d4c\u8def\u5217\u306e\u4f5c\u6210\n1..5 | ForEach-Object{ Add-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f "\u7d4c\u8def$($_)", $groupListId.Guid, (New-Guid).Guid, $approvalPathListId.Guid, "Path$($_)") -Connection $siteCon } > $null\n\n# \u6570\u5024\u5217\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\n$fieldxmlTemplate = '<Field Type="Number" DisplayName="{0}" Required="FALSE" EnforceUniqueValues="FALSE" Indexed="TRUE" IMEMode="inactive" ID="{1}" SourceID="{2}" StaticName="{3}" Name="{3}" \/>'\n\n# \u5fc5\u8981\u627f\u8a8d\u6570\u5217\u306e\u4f5c\u6210\n1..5 | ForEach-Object{ Add-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f "\u7d4c\u8def$($_)\u306e\u5fc5\u8981\u627f\u8a8d\u6570", (New-Guid).Guid, $approvalPathListId.Guid, "Path$($_)Approvals") -Connection $siteCon } > $null\n\n# \u3059\u3079\u3066\u306e\u30a2\u30a4\u30c6\u30e0\u30d3\u30e5\u30fc\u306b\u8ffd\u52a0\u3057\u305f\u5217\u3092\u8868\u793a\nSet-PnPView -List $internalListName -Identity '\u3059\u3079\u3066\u306e\u30a2\u30a4\u30c6\u30e0' -Fields 'LinkTitle','Path1','Path1Approvals','Path2','Path2Approvals','Path3','Path3Approvals','Path4','Path4Approvals','Path5','Path5Approvals' -Connection $siteCon\n\n### \u7533\u8acb\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30ea\u30b9\u30c8\u306e\u4f5c\u6210\n\n# \u4f5c\u6210\u3059\u308b\u30ea\u30b9\u30c8\u306e\u5185\u90e8\u540d\n$internalListName = 'Lists\/Apply'\n\n# \u30ea\u30b9\u30c8\u306e\u4f5c\u6210 (\u30ab\u30b9\u30bf\u30e0\u30ea\u30b9\u30c8\u3068\u3057\u3066\u4f5c\u6210)\nNew-PnPList -Template GenericList -Url $internalListName -Title '\u7533\u8acb\u30ef\u30fc\u30af\u30d5\u30ed\u30fc' -Connection $siteCon > $null\n\n# Title \u306e\u8868\u793a\u5217\u540d\u3092\u5909\u66f4\nSet-PnPField -List $internalListName -Identity 'Title' -Values @{'Title' = '\u7533\u8acb\u30bf\u30a4\u30c8\u30eb';} -Connection $siteCon\n\n# Add-PnPFieldFromXml \u3067\u4f7f\u3046\u306e\u3067 ListId \u3092\u53d6\u5f97 (\u5f8c\u3067\u3082\u4f7f\u3044\u307e\u3059)\n$applyListId = (Get-PnPList -Identity $internalListName -Connection $siteCon).Id\n\n# 1\u884c\u30c6\u30ad\u30b9\u30c8\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\n$fieldxmlTemplate = '<Field Type="Text" DisplayName="{0}" Required="FALSE" EnforceUniqueValues="FALSE" Indexed="TRUE" MaxLength="255" ID="{1}" SourceID="{2}" StaticName="{3}" Name="{3}" CustomFormatter="" IMEMode=""><Default><\/Default><\/Field>'\n\n# \u30b9\u30c6\u30fc\u30bf\u30b9\u5217\u306e\u4f5c\u6210\nAdd-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f '\u30b9\u30c6\u30fc\u30bf\u30b9', (New-Guid).Guid, $applyListId.Guid, "Status") -Connection $siteCon > $null\n\n# \u53c2\u7167\u5217\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\n$fieldxmlTemplate = '<Field Type="Lookup" DisplayName="{0}" Required="FALSE" EnforceUniqueValues="FALSE" List="{1}" ShowField="Title" UnlimitedLengthInDocumentLibrary="FALSE" RelationshipDeleteBehavior="None" ID="{2}" SourceID="{3}" StaticName="{4}" Name="{4}" \/>'\n\n# \u627f\u8a8d\u7d4c\u8def\u5217\u306e\u4f5c\u6210\nAdd-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f '\u627f\u8a8d\u7d4c\u8def', $approvalPathListId.Guid, (New-Guid).Guid, $applyListId.Guid, "ApprovalPath") -Connection $siteCon > $null\n\n# \u8907\u6570\u884c\u30c6\u30ad\u30b9\u30c8\u5217(\u62e1\u5f35\u30ea\u30c3\u30c1\u30c6\u30ad\u30b9\u30c8)\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\n$fieldxmlTemplate = '<Field Type="Note" DisplayName="{0}" Required="FALSE" EnforceUniqueValues="FALSE" Indexed="FALSE" NumLines="6" RichText="TRUE" RichTextMode="FullHtml" IsolateStyles="TRUE" Sortable="FALSE" IMEMode="inactive" ID="{1}" SourceID="{2}" StaticName="{3}" Name="{3}" RestrictedMode="TRUE" AppendOnly="FALSE" \/>'\n\n# \u7533\u8acb\u6587\u306e\u4f5c\u6210\nAdd-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f '\u7533\u8acb\u6587', (New-Guid).Guid, $applyListId.Guid, "Body") -Connection $siteCon > $null\n\n# \u6570\u5024\u5217\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8 (\u521d\u671f\u5024 0 \u3092\u5165\u308c\u308b)\n$fieldxmlTemplate = '<Field Type="Number" DisplayName="{0}" Required="FALSE" EnforceUniqueValues="FALSE" Indexed="TRUE" IMEMode="inactive" ID="{1}" SourceID="{2}" StaticName="{3}" Name="{3}"><Default>0<\/Default><\/Field>'\n\n# \u7d4c\u8def\u306e\u627f\u8a8d\u6570\u5217\u306e\u4f5c\u6210\n1..5 | ForEach-Object{ Add-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f "\u7d4c\u8def$($_)\u627f\u8a8d\u6570", (New-Guid).Guid, $applyListId.Guid, "Path$($_)Accept") -Connection $siteCon } > $null\n\n# \u7d4c\u8def\u306e\u5426\u8a8d\u6570\u5217\u306e\u4f5c\u6210\n1..5 | ForEach-Object{ Add-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f "\u7d4c\u8def$($_)\u5426\u8a8d\u6570", (New-Guid).Guid, $applyListId.Guid, "Path$($_)Reject") -Connection $siteCon } > $null\n\n# \u8907\u6570\u884c\u30c6\u30ad\u30b9\u30c8\u5217(\u66f8\u5f0f\u306a\u3057)\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\n$fieldxmlTemplate = '<Field Type="Note" DisplayName="{0}" Required="FALSE" EnforceUniqueValues="FALSE" Indexed="FALSE" NumLines="6" RichText="FALSE" Sortable="FALSE" IMEMode="inactive" ID="{1}" SourceID="{2}" StaticName="{3}" Name="{3}" \/>'\n\n# \u7d4c\u8def\u306e\u30b3\u30e1\u30f3\u30c8\u5217\u306e\u4f5c\u6210\n1..5 | ForEach-Object{ Add-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f "\u7d4c\u8def$($_)\u30b3\u30e1\u30f3\u30c8", (New-Guid).Guid, $applyListId.Guid, "Path$($_)Comment") -Connection $siteCon } > $null\n\n# \u30ed\u30b0\u5217\u306e\u4f5c\u6210\nAdd-PnPFieldFromXml -List $internalListName -FieldXml ($fieldxmlTemplate -f '\u30ed\u30b0', (New-Guid).Guid, $applyListId.Guid, "Log") -Connection $siteCon > $null\n\n# \u3059\u3079\u3066\u306e\u30a2\u30a4\u30c6\u30e0\u30d3\u30e5\u30fc\u306b\u8ffd\u52a0\u3057\u305f\u5217\u3092\u8868\u793a\nSet-PnPView -List $internalListName -Identity '\u3059\u3079\u3066\u306e\u30a2\u30a4\u30c6\u30e0' -Fields 'LinkTitle','ApprovalPath','Status' -Connection $siteCon\n\n# \u30b5\u30a4\u30c8\u304b\u3089\u306e\u5207\u65ad (\u8907\u6570\u306e\u63a5\u7d9a\u3092\u4f7f\u3063\u3066\u3044\u308b\u6642\u306f -Connection $siteCon \u3092\u5fc5\u305a\u3064\u3051\u308b)\nDisconnect-PnPOnline -Connection $siteCon<\/code><\/pre>\n
\u6b21\u56de\u4e88\u544a<\/h2>\n
\u7d30\u304b\u304f\u30b3\u30de\u30f3\u30c9\u306b\u8aac\u660e\u3092\u5165\u308c\u308b\u3053\u3068\u3067\u3001\u500b\u4eba\u7684\u306b\u306f\u5fa9\u7fd2\u3082\u3067\u304d\u307e\u3057\u305f<\/p>\n
\u5165\u529b\u6b04\u306e\u5236\u5fa1\u3068\u304b\u306f\u306a\u3057\u3067\u3001\u6b21\u306f Power Automate \u3067\u4f5c\u3063\u305f\u30d5\u30ed\u30fc\u306e\u8aac\u660e\u3092\u3057\u3066\u3044\u304d\u307e\u3059<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7d4c\u7def \u524d\u56de\u306e SharePoint \u3068 Power Automate \u3067\u7a1f\u8b70\u66f8\u3092\u5b9f\u88c5\u3057\u3066\u307f\u305f\u30e1\u30e2 1 \u3067\u306f\u3001GUI \u3092\u4f7f\u3063\u3066 SharePoint \u4f5c\u3063\u305f\u30b5\u30a4\u30c8\u3068\u30ea\u30b9\u30c8\u306e\u8aac\u660e\u3092\u884c\u3044\u307e\u3057\u305f \u4eca\u56de\u306f\u305d\u308c\u3092 CUI \u3067\u4f5c\u6210\u3057\u307e […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[62],"class_list":["post-3063","post","type-post","status-publish","format-standard","hentry","category-sharepoint","tag-powershell"],"_links":{"self":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts\/3063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3063"}],"version-history":[{"count":21,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts\/3063\/revisions"}],"predecessor-version":[{"id":3395,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts\/3063\/revisions\/3395"}],"wp:attachment":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}