web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Is it possible to crea...
Power Automate
Unanswered

Is it possible to create a flow to check members of an Outlook distribution list

(0) ShareShare
ReportReport
Posted on by 105

I'm new to Power Automate and just started learning. I have an Outlook distribution list containing about 300 names across different departments. Is it possible to build a flow to check every week if all the members in the distribution list are still with the company and have an active account then email me the results?

Categories:
I have the same question (0)
  • jinivthakkar Profile Picture
    4,187 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    @Earl20 I found a similar thread here, please see this :

     

    https://powerusers.microsoft.com/t5/Using-Flows/how-can-we-check-whether-the-0365-user-is-a-valid-user-account/td-p/112873

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

  • Earl20 Profile Picture
    105 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    OK I will try it

  • Earl20 Profile Picture
    105 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    If I enter the UPN name of the distribution list would that just see if the distribution list is active or will it search each name inside the distribution list?

  • RezaDorrani Profile Picture
    12,143 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    Hi @Earl20 ,

     

    check https://youtu.be/WT08hJ1zDyw

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • Earl20 Profile Picture
    105 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    @RezaDorrani thanks. The video shows how I can get the info for the members of a SharePoint group which is awesome and solves another need of mine. My original post is referring to an Outlook group/distribution list that resides in Outlook not SharePoint. After reading my original post I didnt do a good job of explaining in my original post.

     

    I have a distribution list in Microsoft Outlook called RegionalSupervisors @xxxx.org. Within the RegionalSupervisors resides about 300 users/email addresses. When I send an email to RegionalSupervisors it goes to all 300 users individual email mail boxes. I want to be able (if possible) to create a flow to weekly check the profile of each of the 300 email accounts within the RegionalSupervisors distribution list to see if all the users accounts are still active. then send an email to me listing the results (e.g. I receive an email saying Joesmith@xxxx.org is  active, Janedoe@xxxx.org  is active,  RogerJohnson@xxxxx.org is not active).

  • VictorIvanidze Profile Picture
    13,060 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    Hi @Earl20, please explain what do you mean by (in)active account. What's criteria?

  • Earl20 Profile Picture
    105 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    If they are still working at the company. When a person leaves they erase their outlook account

  • VictorIvanidze Profile Picture
    13,060 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    Sorry that's still a bit unclear for me.

    If I go to "Microsoft 365 Admin Center" ( https://admin.microsoft.com/AdminPortal/Home#/users )

    and select Users, then the active users are listed in the "Active users" list and inactive users are listed in "Deleted users" list, correct?

  • Earl20 Profile Picture
    105 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    Im just a user of O365 not an admin. I just trying to see if a flow can be created to email someone which users were in the deleted group since the last time the flow ran

  • VictorIvanidze Profile Picture
    13,060 on at
    Re: Is it possible to create a flow to check members of an Outlook distribution list

    Yes such flow can be created. I recommend you to hire somebody.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard