Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Get list of all shared mailboxes and distribution lists in power app

(2) ShareShare
ReportReport
Posted on by 18

Hi,

I am designing power app which will have couple of forms for users in my organization to request permission/membership on shared mailbox or distribution list.

I have created couple of screens and designed forms to collect user request. There are dropdown lists where user is suppose to select name of shared mailbox and distribution list.

 

Now I want to get list of all shared mailboxes and distribution lists from exchange online and populate these two dropdowns, however I am not able to find a connector which can provide required information. As an alternative I thought to write a scheduled PowerShell script using EXO V2 module and then populate details in a SharePoint list, then use SharePoint list to populate dropdowns. In this approach I created an unattended script and used app only authentication following steps mentioned in this article https://docs.microsoft.com/en-us/powershell/exchange/app-only-auth-powershell-v2?view=exchange-ps , but it says that The EXO V2 module uses the Active Directory Authentication Library (ADAL) to fetch an app-only token using the application Id, tenant Id (organization), and certificate thumbprint. And ADAL will retire in June 2022. So use MSAL instead.

 

I checked in graph api documentation, it seems that there is not any api as of now which provides such details from exchange. All I can find is list of groups, can not differentiate if it is shared mailbox.

 

Is there any better way to achieve this requirement with minimal customization? I would really appreciate experts comments here.

 

Thanks in advance.

  • SABA365 Profile Picture
    18 on at
    Re: Get list of all shared mailboxes and distribution lists in power app

    Hi,

    Unfortunately not.

    We decided to go with unattended PS script with EXO V2 module. I contacted some experts regarding ADAL query, as per them solution will continue to work after its retirement, but Microsoft will stop support.

  • gsaplx Profile Picture
    6 on at
    Re: Get list of all shared mailboxes and distribution lists in power app

    Hi,

     

    I'm looking to achieve something very similar, have you found a solution to this?

     

    Regards,

    Gabriel

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard