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

[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?

[Jacob12348771]

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

[twilhelm]

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. 

[Jacob12348771]

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

[Sayan]

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.

[Jacob12348771]

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?

[Sayan]

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

[Jacob12348771]

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?