Use Flow designer to add/remove users from a Microsoft Exchange Distribution List

[David Trotta]

Hi Developer Community,

Does anyone have any experience building a flow in Flow designer to add/remove users from a Microsoft Exchange Distribution List in a cloud environment?  My flow is using the Microsoft Entra spoke and Look up User and Azure AD Connection (Use Default Connection) as the Action Properties.  Then, I'm using the User Principal Name (UPN) as the action input, plus the unique Object ID (Group ID) of the Exchange DL, but it is not working.

I am currently getting the below runtime value under the Output Data when looking at the Execution Details in Flow Designer.

"Action Status": {
"code": 1,
"message": "Error: Unknown Error (Process Automation.bc3088ea0bd4a110cfed40976877b252; line 6)"

Any thoughts?

[Viraj Hudlikar]

Hello @David Trotta 

The error "Error: Unknown Error" with code 1 often indicates a permissions issue for the Azure AD application used by the spoke or an incorrect or missing input format for the User Principal Name (UPN) or Group ID. Double-check the API permissions in Azure and the connection alias setup, and ensure the group ID is the correct object ID (GUID).

If my response has helped you, hit the helpful button, and if your concern is solved, do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Shilpa Wadhwani]

Hi @David Trotta ,

I have the same requirement - building a flow in Flow designer to add/remove users from a Microsoft Exchange Distribution List in a cloud environment?

Did you find a solution to achieve this using the Microsoft Exchange Online spoke or any other solution?

[David Trotta]

Hi @Shilpa Wadhwani ,

No, I still haven't found a solution for this.  I added permissions to the account related to the Microsoft Entra ID spoke in Flow Designer, and confirmed the group (Object ID) is correct, but I'm still getting an error like the one below.

{
    "Action Status": {
        "code": 1,
        "message": "Error:  Unknown Error (Process Automation.bc3088ea0bd4a110cfed40976877b252; line 6)"
    }
}

I am puzzled by this.  I am continuing to try different things.

[Steven Parker]

Any updates on this?

We are talking about doing this, but I have concerns that the graph api may not even have the capability to add or remove users from Exchange Online distribution groups.

I don't see an out of the box activity in Flow Designer that would do this.  Are you using an out of the box activity or something custom?  I was going to build a custom script (rest message api call) in workflow editor to avoid using Flow Designer (because it's awful).