Power Automate Expand Query To Join SharePoint Lists

Power Automate allows you to use an expand query to join SharePoint lists and retrieve data from related entities. This can be done by using a lookup field in one list to connect it to another list. By sending an HTTP request to SharePoint and writing an expand query, you can combine columns from both tables and return a single array as the result. This is useful for creating reports or combining data from multiple lists. The article provides step-by-step instructions on how to set up the related SharePoint lists, create the expand query, select the desired columns, and run the flow to view the results. Multiple related list columns can also be added to the expand query.

Article 5m Matthew Devaney

---

Login now to access my digest by 365.Training

Login