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.