Trigger a flow when a user is added to a team in dataverse

(2) Share

Report

Posted on by Jacob12348771

Hi,

I am trying to trigger a flow when a user is added to a dataverse team. The following many to many relationship is present between users and teams. I am then attempting to use the relationship table 'teammembership' in a 'when a row is added' dataverse trigger in my flow, however the flow never seems to trigger.

I have created another basic flow with a get row by id on a user record to test the association 'teammembership_association' shown below. I can see the teams the user is a part of being returned in the JSON response. The user in question below is a member of 3 teams. Is there any reason why this trigger is not working as I am expecting?

I have the same question (0)

All responses (8)

Answers (0)

Jacob12348771 22 on at

Like (1)

Report

Re: Trigger a flow when a user is added to a team in dataverse

Hi, any ideas on how best I can solve this?

Was this reply helpful? Yes No
Tracye 6 on at

Like (2)

Report

Re: Trigger a flow when a user is added to a team in dataverse

Were you able to solve for this? I'm trying to do the same thing however the teammembership_association is a M:M relationship so it won't trigger the flow.

Was this reply helpful? Yes No
Jacob12348771 22 on at

Like (1)

Report

Re: Trigger a flow when a user is added to a team in dataverse

Hi, unfortunately I am yet to find a solution to this.

Was this reply helpful? Yes No
Sayan 818 Super User 2025 Season 2 on at

Like (1)

Report

Re: Trigger a flow when a user is added to a team in dataverse

Hey @Jacob12348771

Can you please delete the Trigger and Again reuse it.
If the above solution does not work First Run the Process and While it is Running add user to DataVerse Team.

Click on Test

After Test Click on Run Flow then Add user.

------------------------------------------------------------------------------------------------------------------------------
If my suggestion helps you, please gives it a Thumbs up 👍 and Marks as a Solution ✔️. Which motivates to solve more problems.
Thanks,
Sayan Patra | RPA Developer.

Was this reply helpful? Yes No
Jacob12348771 22 on at

Like (2)

Report

Re: Trigger a flow when a user is added to a team in dataverse

Hi, I have tried the above however unfortunately I am still not able to get the flow to run. Is this a limitation with using many to many relationship tables in the dataverse triggers? I have noticed that when searching for the table it does not appear in the dropdown list, I have to enter the table name as a custom value?

Was this reply helpful? Yes No
Sayan 818 Super User 2025 Season 2 on at

Like (1)

Report

Re: Trigger a flow when a user is added to a team in dataverse

Hey @Jacob12348771

if the table it does not appear in the dropdown list, please check the connection and create a new connection and use it.

Thanks,
Sayan Patra | RPA Developer

Was this reply helpful? Yes No
Jacob12348771 22 on at

Like (1)

Report

Re: Trigger a flow when a user is added to a team in dataverse

Thank you for your quick reply.

I do not believe this has to do with the connection. Although the table does not appear in the dropdown, saving the flow with the 'teammembership' table selected succeeds with the entity succesfully being retrieved. If for example I enter some random text in the table name, the flow does not save with an 'invalid entity' error appearing which I would expect. Therefore as me and @twilhelm seem to have found many to many relationship tables will not trigger the flow to run.

Is there any other way you can see to trigger the flow when a dataverse user is added to a team?

Was this reply helpful? Yes No
Suggested answer

Jelle de Haas 42 on at

Like (2)

Report
Trigger a flow when a user is added to a team in dataverse

Hey,

I faced a similar challenge on a recent project where my flow didn’t trigger either. A Microsoft support engineer suggested using a webhook to trigger the cloud flow, which proved to be the correct solution.

Steps to take:

Create a cloud flow with trigger "When a HTTP request is received". Use a trigger condition:

@equals(triggerBody()?['InputParameters'][2]?['value'], 'teammembership_association')

Register a webhook using the Plugin Registration Tool, pointing to the cloud flow

Endpoint URL: the first part of the HTTP POST URL until the question mark that is generated by the flow trigger.

Create the properties 'api-version', 'sp', 'sv' and 'sig' and copy the values from the HTTP POST URL.

Create a step for the webhook

Message: AssociateEntities

Stage of execution: PostOperation

Bonus: if you want to trigger your flow on the removal of a user from a team, use the step message DisassociateEntities

1 people found this reply helpful.

Was this reply helpful? Yes No