July in HLS: Power Platform, SharePoint Spaces, Teams, Surface Hub 2, NurseHack4Health and Security!

July in HLS: Power Platform, SharePoint Spaces, Teams, Surface Hub 2, NurseHack4Health and Security!

This article is contributed. See the original author and article here.

6a00d8341e18e853ef010536bcdc5e970b-600wi.jpg

Welcome to the monthly Healthcare and Life Sciences blog recap, July edition! Check out the resources below:

 

Webcasts Recorded:

  • Voices of #HealthcareCloud
    • The Power of the Platform: Watch as Microsoft showcases 3 unique solutions for the clinical, operational and financial sides of the business for providers:
  • CollabCasts with Sam Brown
    • Virtual Events Using SharePoint Spaces: Have you been looking for ways to create virtual events, conferences, employee on-boarding, facility tours, or even training? On Wednesday, July 8th, at 12 noon eastern, Microsoft’s Healthcare and Life Sciences Teams Technical Specialists Michael Gannotti and Sam Brown introduced SharePoint Spaces, showed a live demonstration of a Virtual Conference, and gave you the resources to get started on your own.
    • Microsoft Teams in Health and Life Sciences Event: On Wednesday 7/29 at 12 noon EST, Microsoft, Kinly, Pexip and two of their healthcare customers (MVP Health and Becton Dickinson) teamed up to show how Teams integrates with your existing workflows and technologies to drive more productivity. Check it out to see a live demo of Microsoft’s new 85″ Surface Hub 2, great insights from our customer panel, and more!
  • Social Sessions with Mike Gannotti
    • Episode 9 – Alfred Ojukwu – Session 2 of 2: Last month, Mike and Microsoft’s Alfred Ojukwu discussed Microsoft Surface devices. This month, they switched gears to address a topic with significant implications for individuals’ careers aspirations: having a personal board of directors. This is a subject that Alfred is passionate about and which he frequently speaks on within Microsoft as well as to outside entities.

 

Industry Expert Posts:

  • Confessions of Health Geeks Podcasts
    • Secrets I found out 1 year in at Microsoft: The tables are turned and the producer becomes the presenter! Andrea McGonigle, Microsoft’s National Managing Director of Health and Life Sciences, interviews Claire Bonaci, Microsoft’s Director of Business Development in Health and Life Sciences and producer of the “Confessions of Health Geeks” podcast. Listen in as she reflects on her experiences within her year here at Microsoft.
    • Empowering Nurse Innovation in the NurseHack4Health: First Virtual Hackathon: The World Health Organization designated 2020 as the Year of the Nurse and Midwife to raise awareness of nurses and midwives’ significant and varied roles in healthcare. On May 15, Johnson and Johnson, Sonsiel, Dev Up and Microsoft partnered to host NurseHack4Health, giving nurses and clinicians an opportunity to define new ways to save lives. Microsoft’s Chief Nursing Officer Molly McCarthy talks with the winners of the hackathon about their solutions.

       

 

Security Resource:

  • Microsoft Security Matters Newsletter – June 2020 – Jeremy Windmiller, Enterprise Security Architect: Jeremy has been providing a newsletter to customers that consolidates resources for Microsoft Security Products and Services. Check out the June newsletter.

 

July’s HLS Blog Contributors:

claire.jpg

Claire Bonaci, Director, Business Development, Health and Life Sciences

 

gannotti.jpg

Michael Gannotti, Principal Technical Specialist, Microsoft Teams

 

jeremy.jpg

Jeremy Windmiller, Microsoft Senior Technical Specialist, Security and Compliance

 

vasu.jfif

Vasu Sharma, Microsoft Customer Success Manager

 

shelly.jfif

Shelly Avery, Senior Technical Specialist, Microsoft Teams

 

 

 

 

Thanks for reading and let us know how else our Microsoft team can help!

IMG_8280 (2).jpg

Sam Brown, Technical Specialist, Microsoft Teams

Planning for cross-agency collaboration in Microsoft 365

This article is contributed. See the original author and article here.

Outside collaboration? From our agency? Microsoft 365 can solve this challenge, but the mere mention of “guest access” and external sharing has many audit and regulatory teams reaching for the “off” switch and leaving it there. Especially in the Government Community Cloud environments of Microsoft 365 (GCC, GCC High and DoD), management of external sharing and the risk it can introduce are not so easily understood or implemented. The current variances in features between GCC and the higher level GCC High and GCC DoD can seem even more complicated. We will review the layers of management controls—and the roles that should be managing them—to help you formalize your guest access strategy for Microsoft 365 now, and for the future.

 

Join us on August 3rd from 11am to 12:30pm EST as John Peluso, CTO for AvePoint Public Sector and Microsoft Regional Director, shares with us how we can make this happen.

 

Register here – https://www.eventbrite.com/e/m365-for-government-dc-users-group-august-2020-meeting-tickets-115127754212

 

This post will be updated with recording and presentation materials after the event.

 

Reach out and connect with John: 

 

User Group Resources

YouTube Channel- https://www.youtube.com/channel/UCVqVP1OxUaBec5J1pvnhYEg

LinkedIn Community – https://www.linkedin.com/groups/12368085/

25+ updates for Microsoft Teams for Education for Back to School | July 2020

25+ updates for Microsoft Teams for Education for Back to School | July 2020

This article is contributed. See the original author and article here.

2020 has been wild. COVID-19 has reached all corners of the world, impacting and interrupting the way educators teach, students learn, parents support learners, and how we lead our daily lives. Microsoft Teams for Education has been right there alongside educators, students, and families during these often challenging times with new changes and improvements announced in June and July to help schools adapt to learning during a pandemic.

 

Thank you for sharing your feedback, triumphs, and difficulties with us along the way. We’re humbled by the ingenuity you bring to improving student outcomes every day and the trust you extend to Microsoft Teams as a part of your learning community. Each new and improved feature we design is inspired by you, and for you.

 

Now, we’re thrilled to share even more Teams updates for those headed into a new school year or those in the middle of their year. Whether your school is learning remotely, adopting hybrid learning, or adjusting plans week-to-week, we’ve got you covered to:
1) Run engaging classes through online meetings
2) Maintain student safety with control of meetings and classrooms
3) Easily deploy and manage Teams for your school or institution
4) Do more with Assignments in Teams
5) Keep learners engaged and collaborating in the classroom
6) Nurture social and emotional wellbeing outside of the classroom
7) Train yourself in Teams with additional resources

 

Let’s dive in! (If you’re just looking for a list without extra description, click here to jump.)

 

 

1) Run engaging classes through online meetings
Different choices on how to see each other and engage in online classes
Not every class or discussion has the same needs. That’s why you’ll have different options to view your class on desktop and mobile. Turn on Large Gallery view (aka a 7×7 video grid) to see everyone all at once, Together Mode for classroom discussions (read more about the science and use cases here), or Dynamic view to easily track the content or person currently speaking in class. And if a student is signing in from a mobile device, they’ll be able to see more videos on iOS or Android devices, such as 2×4 and 3×3, too.

When: Expected in August

Together Mode makes it easier for students to focus on body language and nonverbal cues.Together Mode makes it easier for students to focus on body language and nonverbal cues.

 

Dynamic view gives a responsive layout for participants and content.Dynamic view gives a responsive layout for participants and content.

 

Updated Attendance Report option
Educators will soon have the new option to download Attendance Reports after a class meeting is over in the meeting chat and channel thread. Only the meeting organizer has access to the Attendance Report, which will cover Join Time and Leave Time, Email Addresses, along with the Duration so educators can more easily track student attendance as well as engagement. This feature is not on by default now and must be enabled first by IT Admins. Learn how to enable Attendance Reports in the Admin Portal here.

When: Expected in early September

Real-time visual collaboration in online classes, with control over when students can add to the whiteboard
Visual collaboration tools can make meetings and teaching environments more effective and inclusive. Whiteboard in Teams now has new features including faster load times, sticky notes, text, and drag-and-drop capabilities. These features enable students who don’t have access to a touch or pen device to participate in whiteboarding sessions during Teams meetings. Plus, educators will also have the option to present the digital whiteboard without students having access to drawing on the board during class.
When: Available now

Whiteboard in Teams for Education gives educators a digital whiteboard for real-time drawing and collaboration.Whiteboard in Teams for Education gives educators a digital whiteboard for real-time drawing and collaboration.

 

Allow more students to join large lectures
Starting this month, Teams meetings are now available for up to 300 attendees (up from 250). By the close of 2020, Teams meetings will grow to support up to 1,000 students. When you want to bring in more students or faculty to watch a presentation or discussion, Teams will also support a view-only meeting experience for up to 20,000 participants.
When: Available now and later this year

Break into collaboration with virtual breakout rooms
We heard lots of requests for this one and we’re listening. Educators hoping to split students into smaller groups and discussions for collaborative learning can begin using virtual breakout rooms early in the final quarter of 2020. Educators will be able to pick the number of breakout rooms they’d like, either randomly or manually assign students, move students from one room to the other, send announcements to each breakout group, and bring students back all at once to the main class they’re ready. Breakout rooms will be available in non-channel meetings like scheduled meetings or meet-now.
When: Early in the final quarter of 2020

 

 

2) Maintain student safety with controls in meetings and classrooms
Have more control before, during, and after an online class
Students have a way of finding the loopholes, including in online synchronous learning. With Hard Audio Mute, educators can keep collaboration to the right moments and mute students when it’s time to focus. Meeting options will be in place to prevent attendees from unmuting themselves. Mute all participants directly from the Participant pane and control students’ ability to mute and unmute their audio.
When: Early September

Hard audio mute helps educators keep collaboration to the right moments.Hard audio mute helps educators keep collaboration to the right moments.

 

IT Admins will soon have the option to control when students can join meetings by policy. This helps keep classrooms and student-to-student interaction secure to designated, supervised time. (For this policy to work, students must have an updated version of Teams.) To help educators have time to prepare their virtual classroom and prevent students joining without permission, Student Lobby gives educators control over when students are admitted to a scheduled meeting.

When: Student Lobby is available now and meeting policies for IT Admins are coming in August.

Student Lobby gives educators time to set up their class and prevents students from joining a meeting until the educator is ready for them.Student Lobby gives educators time to set up their class and prevents students from joining a meeting until the educator is ready for them.

 

And finally, although there are some pretty awesome #MicrosoftEDU custom video backgrounds, IT admins now have the opportunity to create a custom video background policy (click here for specifics on the policy).
When: Available now

For more Teams online meeting safety guidance, visit these resources for educators and administrators.

Team owners can delete a cross-post
If a student gets a little too enthusiastic and posts inappropriate content across multiple channels, a team owner can now delete cross-posts. Classroom management in just a few clicks.
When: Available now

 

 

3) Easily deploy and manage Teams for your school or institution
Simplify grading with SDS and OneRoster compliant SIS
Say goodbye to the old copy-and-paste routine for grades. With the new GradeSync to OneRoster API, Teams automatically sends grades entered by educators in Assignments to their OneRoster compliant SIS.
When: Early August

Easier Teams policy management for all of your users
Using Group policy assignment, IT Admins can save time and reduce the complexity of managing groups of students or faculty. Instead of changes done student-by-student or in batches, IT Admins will be able to use groups (first-graders or fifth-graders, for example) and implement multiple policy definitions at the same time. If a user is in more than one group, the order that the policies take effect can be ranked. This is great for users who may have mixed roles, such as a university student who is also a part-time employee at their university. And there’s no script involved! The starting six policies (Calling, Call Park, Channel, Meeting, Messaging, Meeting Broadcast) will be available in the Microsoft Teams Admin Center. Read more about group policy assignment and ranking.
When: Early August

Group policy assignments in the Microsoft Teams Admin Center.Group policy assignments in the Microsoft Teams Admin Center.

 

More class team creation and management control
Soon, there will be even more (and even more awesome) options for team creation. First, School Data Sync (SDS) is adding back automatic class team creation! Admins can once again automatically bulk-create both M365 Group and class teams for their educators, saving their time and focus for teaching. Even though classes are created automatically, educators maintain control over when students are admitted and can view class content. This allows educators additional time and control to set up their classes before admitting their students into the class team. To schedule Class Team Deployment Assistance with the EDU Customer Success Team, complete the form at https://aka.ms/sdssignup.
When: August

Educator-led team creation is another great deployment option that alleviates work for educators while still granting them control over which classes they want to create and use. Admins can create M365 groups for classes based on student and educator roster information, and the educator will be notified of their suggested class teams. The educator can then decide whether or not to create teams for their suggested classes. This provides flexibility and prevents class teams from being automatically created and turned on when they aren’t needed. This solution is recommended for large tenants (>500,000 teams). To learn more about this feature, please visit the Create a team from suggested class tab.
When: August

Educator-led team creation gives educators control and flexibility over team creation for class.Educator-led team creation gives educators control and flexibility over team creation for class.

 

The Early Class Access API gives additional control to IT Admins to support and create teams with educators. First, IT Admins decide whether or not a class team will be “locked” for early educator access or give immediate student access. Next, Admins use a query to see which teams are active or not activated yet. Then, if needed, IT Admins can activate the class team on the educator’s behalf. Please refer to this documentation for more information about Early Access Class Teams.
When: August

For more information, please read these recommended methods and best practices for creating class teams.

 

 

 

4) Do more with Assignments in Teams
View assignments across all classes and get to them quickly (again)
Being able to see what’s upcoming, whether you’re an educator or student, is super important to getting a handle on your week…month…or year. Soon, both educators and students will once again be able to view upcoming and turned in assignments by class or view them across all classes. Just visit Assignments in your app bar on the left hand side of Teams to view assignments across all classes.
When: August

Quickly preview a linked resource
In addition, when an educator adds a link as an assignment resource, students will be able to see a thumbnail preview before clicking to the site or resource.
When: August

More flexibility and settings for educators
Tackle unconscious bias and even the playing field in class with Anonymous Grading. When enabled in the assignment detail view, students’ names are anonymized and avatars are temporarily removed, presenting a random list of students. This allows educators to review work with identities hidden, no shuffling of paper involved.
When: August

Anonymous Grading helps remove unconscious bias and even the playing field in class.Anonymous Grading helps remove unconscious bias and even the playing field in class.

 

Instead of setting things up on an assignment-by-by-assignment basis, educators can now manage a set of Assignments settings in the Assignments tab. Assignment settings allow educators to set default due times, set preferences of what happens when a new student is added to the class, change where notifications for the assignment will be posted (like an Assignments specific channel), and turn off turn-in celebrations if they’re not age-appropriate for older students. (Settings changes will apply to new assignments created after the settings have been saved.)
When: August

Assignment settings allow educators to set preferences.Assignment settings allow educators to set preferences.

 

More languages supported in Assignments
Assignments is growing even more globally inclusive with additional languages supported including Croatian, Estonian, Greek, Hungarian, Indonesian, Latvian, Lithuanian, Romanian, Slovenian, Ukrainian, and Vietnamese.

When: Available now

 

Overall improvements to make Assignments better
Kicking off with simplified terms and an icon refresh, several changes will be made to improve readability and functional association for educators. Assignments will soon be able to support larger file sizes (up to 500MB) and more than 10 attachments at a time. There will also be large class UI improvements that improve the speed of viewing and creating assignments for classes of up to 200 students. Lastly, we’re making it easier to tell when students are no longer enrolled in the class and ensuring that they don’t receive assignments after they leave the class.
When: Large class UI improvements available now, others in August

 

 

5) Keep learners engaged and collaborating in the classroom
Class Materials is now available on Android
With students working from a variety of devices, including many mobile devices, it’s important that they have access to the core curriculum. To make learning more equitable, the Class Materials folder is now available on Android.
When: Available now

More reasons to feel pretty great about turning in an assignment
If your students are already fans of the dangling pizza slice or swinging sloth animation that play after they click Turn in, they’ll feel extra celebratory after they experience the new turn-in celebrations launching this August. Turning in work is a big deal. We’ve heard from students that Teams’ whimsical animations bring a ‘lil sprinkle of magic to their school day, granting some extra motivation to meet due dates and influence student outcomes. At a time when students may feel disconnected from their vibrant classroom life, the surprise of, say, a disco ball spinning down to sparkle on their screen reminds them to pause and pat themselves on the back for a job well done.
When: August

New Assignment turn-in celebrations sprinkle a little magic into the school day

 

D2L’s Brightspace Course Connector
D2L’s Brightspace is a learning management system for K12 and higher education teaching. With the D2L Brightspace Course Connector for Microsoft Teams, educators will be able to sync rosters, create private channels for course sections and link back to their course homepage through a tab in Microsoft Teams.
When: August

 

 

 

6) Nurture social and emotional wellbeing outside of the classroom
Gather reflections on how students are feeling and doing in real-time
Emotions are a big part of life at school. How students feel impacts their readiness to learn, their mental wellbeing, and their behavior toward their teachers and their peers.

To communicate in emotionally supportive ways, we rely on many nonverbal cues and real-life opportunities for interaction. If your school is learning remotely, in a hybrid model, or somewhere in between, it can be harder to pick up on the social cues of how students and faculty are feeling.

The Reflect messaging extension gives educators and staff another social and emotional connection with their students and colleagues. Through quick check-in questions and polls, students and colleagues can share how they are feeling in general, or about a specific topic, such as learning from home, an assignment, current events, or a change within their community. Using Reflect to check in with others can help you better understand wellbeing and open a dialogue for social-emotional learning (SEL) with your students by giving them an opportunity to practice self-expression and naming their emotions.

Educators can choose to make the reflection fully anonymous, private to them, or viewable to the entire class. IT administrators can install the Reflect extension from GitHub and then make it available to educators in their organization in the message extension menu. Once installed, the extension provides suggested check-in questions and the ability to add custom questions that students can respond to in a poll-like experience. Check for more scenarios and use cases here.
When: Early August

Reflect messaging extension helps educators stay connected to students’ wellbeing.Reflect messaging extension helps educators stay connected to students’ wellbeing.

 

 

 

7) Train yourself in Teams with additional resources
Learn about Teams and how to get started:

  1. Quickly learn about Teams and common classroom scenarios with clickable interactive demos for educators, families, and IT Admins (in English).
  2. Check out the Quick Start Guides if you’re an Educator (PDF), Student (PDF), or IT Admin.
  3. Train yourself with Professional Development with the popular Microsoft Educator Community course, Transform Learning with Microsoft Teams.
  4. Watch helpful “how-to” videos with Teams Quick Tip videos on YouTube (or pick from a different Teams video playlist here).
  5. Sign up for the live Microsoft Teams for Edu digital readiness event for both educators or IT Admins on August 11 and 12 that dives into common scenarios, use cases, and how to get ready for the school year at https://aka.ms/TeamsEDULive. (In English, sessions will be recorded.)

Plus, check out these additional resources:

  1. Resources for parents, guardians or family members looking to support student learning: https://education.microsoft.com/resource/755e5a8b
  2. Teams online meeting safety guidance for educators and administrators.
  3. The Teams help homepage. You can also click Help in your Teams app at any time for extra how-tos and support!

And for those that love lists, here’s a quick review of all the features we shared along with their launch dates:
1) Run engaging classes through online meetings

Large Gallery view (aka 7×7) – expected in August
(New) Together Mode – expected in August
(New) Dynamic view – expected in August
(New) See more videos on iOS or Android devices – expected in August
(New) Attendance Report post-meeting download – expected in early September
(New) Whiteboard in Teams features – available now
(New) Digital Whiteboard without student access – available now
(Update) Teams meetings now 300 interactive participants – available now
(New) Teams meetings up to 1,000 interactive participants – coming in the last quarter of 2020
(Update) Virtual Breakout rooms – no later than early Q4 2020

2) Maintain student safety with control of meetings and classrooms

(New) Hard Audio Mute – expected in early September
(New) Control when students can join meetings – expected in August
(New) Students Wait in Lobby – available now
(New) Custom video background policy – available now
(New) Delete cross posts – available now

3) Easily Deploy and manage Teams for your school or institution

(New) GradeSync to OneRoster API – expected in August
(New) Group policy assignment – coming soon
(Update) SDS adding back team creation– expected in August
(New) Educator-led team creation – expected in August
(New) Early Class Access API – expected in August

4) Do more with Assignments in Teams

(Update) View assignments across all classes (again) – expected in August
(New) Link thumbnail preview – expected in August
(New) Anonymous Grading/Marking – expected in August
(New) Assignment settings – expected in August
(New) Four additional overall improvements – expected in August
(New) New Assignment languages supported – available now

5) Keep learners engaged and collaborating in the classroom

(New) Class Materials on Android – available now
(New) New Turn-in celebrations – expected in August
(New) D2L’s Brightspace Course Connector – expected in August

6) Nurture social and emotional wellbeing outside of the classroom

(New) Reflect messaging extension – expected in early August

 

You’ve got this. And we’re right here if you need us.

 

Recorded Live Event with Customer Panel: Microsoft Teams in Health and Life Sciences

Recorded Live Event with Customer Panel: Microsoft Teams in Health and Life Sciences

This article is contributed. See the original author and article here.

Untitled picture.png

Microsoft Teams in Health and Life Sciences

On Wednesday 7/29 at 12 noon EST, Microsoft, Kinly, Pexip and two of their healthcare customers teamed up to show how Teams integrates with your existing workflows and technologies to drive more productivity.

 

We heard from Microsoft’s Chief Nursing Information Officer Kathleen McGrow, as well as two customers, Becton Dickinson and MVP Health, about their Teams journey and how it fits into their daily workflows. Pexip talked through how they can help you join Teams meetings from legacy video systems. We got a demo of Microsoft’s new 85″ Surface Hub 2, and discovered how Kinly can help optimize your Teams collaboration strategy. Check out the recording below:

 

 

 

The Agenda

12:00

Keynote: How Teams fits into your healthcare setting (Microsoft)

12:30 Connecting legacy video systems with Teams (Pexip)
1:00 Developing your Teams strategy (Kinly)
1:30 Collaborating with Surface Hub 2 – (Microsoft)
2:00 Customer Panel (Becton Dickinson, MVP Health Care)
2:30 Open Q&A

 

 

The Presenters

 

0.jpg

Kathleen McGrow, DNP, Chief Nursing Information Officer & Industry Executive at Microsoft (LinkedIn)

 

Frank Buchholz.jpeg

Frank Buchholz, Sr. Product Marketing Manager – Surface at Microsoft (LinkedIn)

 

0 (1).jpg

Olly Henderson Sales Director – Microsoft Lead US at Kinly (LinkedIn)

 

Andrew Reitter.jpeg

Andrew Reitter, Sr Director of Business Development at Pexip (LinkedIn)

 

 

Anthony Kay, Telecommunications Engineer at Becton Dickinson (LinkedIn)

 

David Swits.jpeg

David Swits, Sr Leader, Cloud & Infrastructure Services at MVP Health Care (LinkedIn)

 

0 (2).jpg

Jeremiah Brown, Leader, Cloud Services and Microsoft Technologies at MVP Health Care (LinkedIn)

 

As the producer, I think this was some of the best content that we have on the blog and I can’t thank all our of the presenters enough! We know it was a long event, but check out the agenda above along with the recording to fast forward to the relevant pieces for your organization. We are happy to have a more focused follow up based on which portions were most helpful!

0 (3).jpg

Sam Brown, Microsoft Teams Technical Specialist

 

How to Manage SharePoint via PowerShell – Part 2

How to Manage SharePoint via PowerShell – Part 2

This article is contributed. See the original author and article here.

Following part 1 of How to Manage SharePoint via PowerShell, we’ll now look at getting started to interact with lists, libraries, and permissions.  Let’s get started!
 

How to get the information you need?

To get all the lists & libraries in a site, run Get-PnPList. Note there’s no Get-PnPLibrary cmdlet because under the hood, everything is a “list”. If you wish to differentiate what you want (list, library, or any other type available), you can use the ‘BaseTemplate’ property.
 
Connect-PnPOnline -Url "https://m365x141782.sharepoint.com/sites/Mark8ProjectTeam"
Get-PnPList | Where-Object {$_.BaseTemplate -eq 101}​
 
Where did I get this 101 number? Here’s a handy link for your future scripts, refer to the Template Id column: ListTemplateEnumeration.
 
Get all the files in multiple libraries
We use PowerShell for bulk actions right? So let’s loop through multiple libraries within a site, and retrieve all the files.
#Connect to the targeted site
Connect-PnPOnline -Url "https://m365x141782.sharepoint.com/sites/Mark8ProjectTeam"

#Declare variables
$results = @()
$allLibs = Get-PnPList | Where-Object {$_.BaseTemplate -eq 101}

foreach ($lib in $allLibs) {      
    #Store all docs in a variable
    $allItems = Get-PnPListItem -List $lib.Title
    
    foreach($item in $allItems){
        $results += [PSCustomObject][ordered]@{
            FileName    = $item["FileLeafRef"] 
            CreatedBy   = $item.FieldValues.Author.LookupValue
            CreatedDate = [DateTime]$item["Created_x0020_Date"]
            FilePath    = $item["FileRef"]
        }
    }
}
$results​

GetAllfiles.png

 

The properties are entirely up to you to decide. If you need all the files, for all sites, just add another loop. Be aware that if you have thousands of sites/libraries/documents, this might not be the best idea from a performance perspective.

Filtering results with conditions

In this scenario, we’d want all the files where the size is above 50MB for instance. Maybe there are videos in your SharePoint environment(s)?
#Connect to SPO Site
Connect-PnPOnline -Url "https://m365x141782.sharepoint.com/sites/Mark8ProjectTeam"

#Store in variable all the document libraries in the site
$docLibrary = Get-PnPList | Where-Object { $_.BaseTemplate -eq 101 }

foreach ($docLib in $docLibrary) {
    #Get list of all folders in the document library
    $AllItems = Get-PnPListItem -List $docLib -Fields "SMTotalFileStreamSize"
    
    #Loop through each files/folders in the document library for files >50Mb
    foreach ($item in $allItems) {
        if ((([int]$item["SMTotalFileStreamSize"]) -ge 50000000) -and ($item["FileLeafRef"] -like "*.*")) {
            Write-Host "File found:" $item["FileLeafRef"] -ForegroundColor Yellow
        
            [PSCustomObject]@{
                FileName         = $item["FileLeafRef"] 
                FilePath         = $item["FileRef"]
                SizeInMB         = ($item["SMTotalFileStreamSize"] / 1MB).ToString("N")
                LastModifiedBy   = $item.FieldValues.Editor.LookupValue
                EditorEmail      = $item.FieldValues.Editor.Email
                LastModifiedDate = [DateTime]$item["Modified"]
            }
        }
    }
}
​
This script is a bit special because we needed to filter even more with ($item[“FileLeafRef”] -like “*.*”) to return the appropriate results and skip the folders.
 

Create custom permissions on multiple sites

Custom permissions are created when Full Control is too much, and Read-only is not enough. So, it might happen that you need to create your own. In this scenario, let’s create a custom permission BUT on multiple sites by importing a CSV file.
 
Note: The CSV file contains a header called “SiteUrl” (without the quotes)
#Connect to SPO admin center
Connect-PnPOnline -Url https://m365x141782-admin.sharepoint.com

#Import sites from .csv
$mySites = Import-Csv -Path '<YOUR_FILE_PATH>'

#Create all for each site
foreach ($site in $mySites) {    
    #Connect to each site
    Write-Host "Connecting to $($site.SiteUrl)" -ForegroundColor Green
    Connect-PnPOnline -Url $site.SiteUrl
    
    #Create the NEW permission level (clone the 'READ' default permissions)
    $PermToClone = Get-PnPRoleDefinition -Identity "Read"
    $addPnPRoleDefinitionSplat = @{
        Include     = 'ManagePersonalViews', 'UpdatePersonalWebParts', 'AddDelPrivateWebParts'
        Description = "Copy of Read + Personal Permissions"
        RoleName    = "myCustomPermLevel"
        Clone       = $PermToClone
    }    
    Add-PnPRoleDefinition @addPnPRoleDefinitionSplat
}
If the format of this script is not familiar to you, I’m using splatting. which allows to pass parameters with a slightly different syntax. Want to know more? check out this Microsoft documentation.
 

Conclusion

There you have it. I hope this will get you get started on how to manage your SharePoint environment(s) using PowerShell, and if you want to know more, feel free to leave your comments below :)

Happy scripting!