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.
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.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.