Power Automate Desktop - Email Anlagen exportieren

# mailbox user
$userid = 'myuser@xxxxxxx.onmicrosoft.com'  
# tenant FQDN
$tenant = 'xxxxxxx.onmicrosoft.com'  
# targetfolder for attachments
$download_folder = 'W:\attachments'  
# ============================
# stop on error
$ErrorActionPreference = 'Stop'  

# install module if it does not exist
if(!(Get-Module -ListAvailable -Name Microsoft.Graph.Mail)){
    # install module for current user
    Install-Module Microsoft.Graph.Mail -Force -Scope CurrentUser
}
# create output folder
if(!(Test-Path $download_folder -PathType Container)){
    New-Item -type dir -Path $download_folder -Force | out-null
}

# import module
Import-Module Microsoft.Graph.Mail

# connect to MG Graph with ReadWrite Permissions to mail scope (GUI-Login)
Connect-MgGraph -Tenant $tenant -Scopes Mail.ReadWrite -NoWelcome

# ======= Possible automated login methods (needs precreated azure app registration with app password or certificate) ==========

# connect with *.pfx certificate from file

#$client_id = 'XXXXXXXXXXXXXXXXXXXXX' 
#$certificate_file = 'D:\user.pfx' 
#$certificate_password = 'GEHEIM' 
#Connect-MgGraph -Tenant $tenant -ClientId $client_id -Certificate ([X509Certificate]::new($certificate_file,$certificate_password)) -NoWelcome

# connect with certificate from user cerificate store by thumbprint

#$client_id = 'XXXXXXXXXXXXXXXXXXXXX' 
#$certficate_thumbprint = 'XXXXXXXXXXXXXXXXXXXXXXXXXX' 
#Connect-MgGraph -Tenant $tenant -ClientId $client_id -CertificateThumbprint $certificate_thumbprint  -NoWelcome

# connect with application credentials (app password)

#$client_id = 'XXXXXXXXXXXXXXXXXXXXX' 
#$client_password = 'XXXXXXXXXXXXXXXXXXXXXXXX' 
#Connect-MgGraph -Tenant $tenant -ClientSecretCredential (new-Object PSCredential($client_id,(ConvertTo-SecureString $client_password -AsPlainText -Force))) -nowelcome

# ==============================

# get unread messages with attachments from inbox folder
foreach($message in Get-MgUserMailFolderMessage -UserId $userid -MailFolderId inbox -All -Property HasAttachments,IsRead,subject,sender,parentfolderid -Filter "isRead eq false and HasAttachments eq true"){  
    # process each pdf attachment
    foreach($attachment in Get-MgUserMailFolderMessageAttachment -UserId $userid -MessageId $message.id -MailFolderId $message.ParentFolderId -All -Filter "contentType eq 'application/pdf' and isInline eq false and endswith(name,'.pdf')"){     
        try{
            # create targetpath in downloadfolder
            $targetpath = join-path $download_folder $attachment.Name
            # generate new file name if file with the same name already exists
            $cnt = 0
            while(Test-Path $targetpath -PathType Leaf){
                $targetpath = join-path $download_folder "$([IO.Path]::GetFileNameWithoutExtension($attachment.Name))_$('{0:D3}' -f ((++$cnt)))$([IO.Path]::GetExtension($attachment.Name))"  
            }
            write-host "Saving attachment '$($attachment.Name)' from message with subject '$($message.Subject)' to '$targetpath'." -F Green  
            # save attachment to download folder
            [IO.File]::WriteAllBytes($targetpath,[Convert]::FromBase64String($attachment.AdditionalProperties.contentBytes))
        }catch{
            write-host $_.Exception.Message -F Red
        }
    }
    # Mark message as read
    Update-MgUserMessage -MessageId $message.id -UserId $userid -IsRead | out-null
}
# disconnect from MS-Graph
Disconnect-MgGraph | out-null

foreach($attachment in Get-MgUserMailFolderMessageAttachment -UserId $userid -MessageId $message.id -MailFolderId $message.ParentFolderId -All -Filter "contentType eq 'application/pdf' and isInline eq false and endswith(name, '.pdf')"){