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
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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,506)