Inspired by https://docs.microsoft.com/en-us/microsoft-365/community/identifying-your-sharepoint-champions we should provide a sample to quickly share a weekly champion to teams as an adaptive card. The script itself could be straight forward:

Use:

m365 spo report activityuserdetail --period D7 --output json 

And implement a sort by Viewed Or Edited File Count

Or use:

m365 teams report useractivityuserdetail --period D7 --output json 

And implement a sort by Team Chat Message Count

Or use:

m365 tenant report activeuserdetail --period D7

Ans sort by one of the following: Exchange Last Activity Date,OneDrive Last Activity Date,SharePoint Last Activity Date,Skype For Business Last Activity Date,Yammer Last Activity Date,Teams Last Activity Date

In general it would depend on the scenario what would fit best (we could potentially do a sample that highlights the teams champion of the past week or SPO champion of the week) or we could combine both and pick the top from both and post it to teams. We can choose to implement the sending of the adaptive card using two different approaches:

• With webhooks https://techcommunity.microsoft.com/t5/microsoft-365-pnp-blog/how-to-send-adaptive-cards-with-cli-microsoft-365/ba-p/2143466
• With Logic Apps https://techcommunity.microsoft.com/t5/microsoft-365-pnp-blog/run-reports-on-your-tenant-using-the-cli-for-microsoft-and-azure/ba-p/2377851

@pnp/cli-for-microsoft-365-maintainers do we feel that a sample script would be sufficient? After drafting this one up it feels like a blogpost on the tech community makes a bit more sense as the sample script would be 1 or 2 lines..