Solved: Cannot Update a mail-enabled security groups and or distribution list

Hello Guys,
This question has been posted a few times but I am still not sure if there are any workarounds.
The Problem: I want to add a user to a mail enabled security group in exchange. This feature (or bug) is no more enabled since October 2021. Never the less there must be a workaround right? Could there be an option through azure functions or power shell scripts? Does anyone have a workaround solution?

Categories:

Using Apps Using Formulas

So I finally found a Work around. But it comes with costs: 1) Power Automate Premium licence and 2) Azure AD service.
The idea can be best described in this Blog: https://azurelessons.com/call-azure-function-from-flow/

The longer description

Use "HTTP Request": Add the "HTTP Request" action to send an HTTP request to the script's trigger URL. You need a way to make the PowerShell script available online, such as using services like Microsoft Power Platform, Azure Functions, or another hosting service.

Configure the HTTP Request: In the "HTTP Request" action, you need to configure the method (POST), the URL of the hosted script, and any necessary headers or data.
Create an Azure Function: In this function add the Power Shell script.

Process the Response (optional): If the PowerShell script returns a response (such as a success status), you can process the response in Power Automate and trigger corresponding actions.

Trigger the Flow: Select a trigger that initiates the flow, such as when an email arrives or an item is added to a list.