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.
If you would like to continue learning how to use Power Automate, we have an educational blog with many more examples of code.