Power Platform Community Forum Thread Details

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: