I’m sure that you can…

But is there a better way to get files from file shares to SharePoint Online? Like Mover https://learn.microsoft.com/en-us/sharepointmigration/mover-plan-migration?WT.mc_id=M365-MVP-9501

I like the post. Can we upload the CSV files from Azure File Shares to SharePoint online using Azure RunBook powershell?

I haven’t tried posting information extracted from Office 365 to a dataverse, but if an API is available to Azure Automation to do the job, then go for it!

I like this post and the idea.

However, is there a way I can iterate through and post them into a dataverse.

I’m running it on Azure Automation runbooks.

Thanks.

The file was originally created as a PowerShell List object and then exported in CSV and HTML formats. Here’s how the CSV file was created:

$Report | Sort “Days before expiration” | Format-Table Group, “Last renewed”, “Next renewal”, “Days before expiration” -AutoSize
# Create data to store in SharePoint Online
# First, the CSV file
$SDate = Get-Date -format yyyyMMddHHmmss
[string]$SourceDocument = “Microsoft 365 Groups Expiration Report ” + $SDate + “.csv”
[string]$HTMLDocument = “Microsoft 365 Groups Expiration Report ” + $SDate + “.html”
$Report | Sort “Days before expiration” | Export-CSV -NoTypeInformation $SourceDocument

# Connect to PnP using the credentials fetched from Azure Key Vault
$PnpConnection = Connect-PnPOnline $SiteURL -Credentials $UserCredentials -ReturnConnection
# Add a document title
$Values = @{“Title” = ‘Microsoft 365 Groups Expiration Report (CSV)’}
# Add the file to the General folder
$FileAddStatus = (Add-PnPFile -Folder “Shared Documents/General” -Path $SourceDocument -Connection $PnpConnection -Values $Values | Out-Null)
$NewFileUri = $SiteUrl + “/Shared Documents/General/” + $HTMLDocument

I like this post and the idea of posting a file directly from Azure Runbooks to SharePoint Online. I have an application I am working on where this would be helpful. One thing I did not get from the above was how/where the file is initially created … how/where do you set the $SourcePath parameter?

$FileAddStatus = (Add-PnPFile -Folder “Shared Documents/General” -Path $SourceDocument -Connection $PnpConnection -Values $Values | Out-Null)

Any chance you could share a code snippet that shows how to do this from within an Azure runbook? Or point me to an example?

Thanks

I will…

I have had a look and think that it is certainly possible to post to a channel via a webhook. However, you run into problems with the amount of data supported by the cards. It is impossible to fit the amount of information included in a report like the groups expiration report and I hit some problems with HTML formatted data too. I’m sure the technique could come in handy in some instances, but not in this situation.

Good idea to use a webhook. I shall investigate.