Ultimate Department Site Strategy using both Teams and SharePoint | E011 

hey Paul, I really do appreciate this. This is my mission, to explain this tech in a more digestible way with real-world scenarios. thank you for the feedback!

I love the annual audit idea, speed would be the most important thing for most clients. An annual audit to clean up security groups is a must, just to kind of get rid of the dead weight. In Azure (Entra ID) AD you can see all the groups a user is tied to... So as part of my offboarding process, I will be looking at the groups from a user level. And tackle it that way. Then I will also ensure that if I remove that user from the group, the group is not empty. I'm not sure how you guys do it there, but for some clients when a user gets off-boarded, the manager takes over the OneDrive and their access for a period of time. Once that grace period elapsed then IT jumps in and starts removing the user from the respective groups . I think you're spot-on to put the responsibility on the department, to ensure that they are replacing the offboarded user with a new user within their area. We see this a lot with power apps and power automates created by the off-boarded user. This becomes an exponential problem when you have citizen development going within the organization. So I think the role from IT, security, is providing the manager of that department the information or tool, which enables them to easily identify the assets that need to be updated

Awesome! Thanks for watching.

Thank you very much

Glad it was helpful!

Thanks for watching...yes for the leave request sample I think the document library woild be just fine for this...if they need to complete a document. Else I would use a SpList to capture the details of the request and use Power Automate to route for approval/notifications

@@DeShonClark Thanks, DeShon

wonderful idea...I bet it would be much cleaner on the MS Teams side...not sure about the multiple site collections structure though...may be messier on the SharePoint side....I'll take a crack at it

Thanks for watching. I need to do a 2023 version of this

Thanks for watching! I appreciate the feedback

Thanks Motmot, I really do appreciate the feedback

This is a very cool way to solve for a common requirement. I don't know if I can fully understand your strategy without actually speaking to you and see it in practice. But it sounds like you're going the right track. One of the things I'm starting to get a better appreciation for is DLP policies. There's a lot of control and options to help keep confidential documents inside the org and preventing them from being shared externally regardless of permissions.

Thanks for watching, yes I get this from users as well. I usually point them to the sync feature in MS teams to work with the documents in an windows explorer fashion.

hey Kate, checking in to see how your webinar site is coming. This is an very awesome idea! Can you give us an update?

Thanks for watching...those , my friend, are highlighted content web parts. They are filtering by document types and by managed properties

Hi there! I apologize for the confusion. Regarding the issue with the "Relevant Sites" not resolving, it could be due to a temporary glitch or an issue with your network connection. I recommend trying again later or using the SharePoint link instead, as you've mentioned it worked for you. As for the issue with moving the document from your team site to the new shortcut folder, it's possible that there might be a permissions issue. Double-check that you have the necessary permissions to access and modify the folder. If the issue persists, it would be best to reach out to your site administrator for assistance. Let me know if you have any other questions or issues. I'm here to help!

This is doable in Power Automate...let me see if I can give it a swing.

​@@DeShonClarkHello, The issue we discussed before are indeed feasible. ​ I have now successfully patched the contents of the three fields in sharepoint A (height, weight, Attachments [there are multiple attachments, they may be pictures or files]) to sharepoint B through power automate in a newly created json column. because I want to store the three columns in sharepoint A in a json column in sharepoint B.

@@DeShonClark BUT can I ask you a question? How can I successfully reading the json attachments in powerapps.Because I want to storage the attachments info in json at first.and then reading the files by json column insteated of Attachments column provided by sharepoint.

[ { "Height": "165", "Weight": "95", "Attachments": "[{\"Name\":\"Attachment into JSON test (3).csv\",\"CONtentBytes\":{\"$content-type\":\"application/octet-stream\",\"$content\":\"77u/VGl0bGUsQXR0YWNobWVudCBKU09OLEF0dGFjaG1lbnRzDQoiTmFtZSIsLCIxIg0K\"}},{\"Name\":\"image (46).png\",\"CONtentBytes\":{\"$content-type\":\"image/png\",\"$content\":\"iVBORw0KGgoAAAANSUhEUgAAAtAAAAEDCAIAAACTd6TXAAAgAElEQVR4Aey9B3Ak2XnnCc6QImWo3aPMas9sbIQudHt3u3enO8XxpFjptLuxWq2klYkQRUp7okitLCVSJGe6p3u8656ZnpkG0A3vvUehvPfeV6Up771DwTbQ6Eabi5euMrOygELPDHdmmBX/yH75KlFV+IBC/fr/fe97wAAAABJRU5ErkJggg==\"}}]" }] because the json coding is too long,this the part of the json column of one item . I really want to know how to successfully read these files in powerapps. Can you give me an idea? Thank you very much. @@DeShonClark