cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SABA365
Regular Visitor

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

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.

2 REPLIES 2
gsaplx
New Member

Hi,

 

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

 

Regards,

Gabriel

SABA365
Regular Visitor

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.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,502)