I'm a Project Manager, and I often start my projects with a spreadsheet listing all the team members and stakeholders. My typical workflow involves adding these individuals in bulk to a Microsoft Team and then creating an item for each user in a SharePoint list that I usually call Team Contacts or People Directory.
After the initial setup, I transition to an automated flow that adds items to the SharePoint list whenever a new user is added to the Microsoft Team. Additionally, I sometimes use a third flow to retrieve items from the list and update user profiles and manager assignments to ensure the information remains accurate over time.
One of the challenges I need to account for is handling users who:
- Are not part of my domain and therefore do not have user profiles.
- Do not have a manager assigned in the system.
This approach works but feels a bit complex, and I’m wondering if there’s a more efficient way to structure this process. For example:
- Is there a simpler way to handle exceptions for users without profiles or managers?
- Are there any best practices for creating SharePoint list items and keeping them up to date?
Here’s a screenshot of my current flow:
Conditions
- Condition 1 is set up like this:
- @{outputs('Compose_status_code_for_get_user_profile')} is equal to 200
- Condition 2 is set up like this:
- @{outputs('Compose_status_code_for_get_manager')} is equal to 200
Create item
A few different create items are used to update fields in my list. Here is a screenshot of one of them: