Stoetech


Retrieving related (N:N) records with Power Automate

Identifying N:N relationships may not seem possible at first, but since it is so useful, we cannot take no for an answer. Microsoft actually maintains records of N:N relationships in a somewhat unconventional, less user-friendly manner.

Rather than a straightforward presentation, Microsoft creates a makeshift entity storing the intersection of related records. To locate this “entity,” visit https://DOMAIN.api.crm.dynamics.com/api/data/v9.2/, where a screen full of text appears. Utilize the ctrl + f search function to locate the schema resembling entity1_entity2set. The appended “set” at the schema’s end indicates Microsoft’s representation of the N:N relationship. 

 
Follow along with the video below to watch how to do this with Power Automate.

If you would like to continue learning how to use Power Automate, we have an educational blog with many more examples of code.