So the requirement is that I have around 4 entities with 1:N relationships and I need to extract it into a single line for each combination. This would be like using a Select statement with 'Joins' or 'In' constructs in SQL. Is there a way of doing something similar in Flow?
Please let me know
If you can save your query in a stored procedure, please check if this template helps you
Hello, Thanks for your reply.
Im sorry but I am still quite very new to power automate and the whole d365 thing... so it is possible to query data from entities in CDS using good old sql?
Sorry I didn't understand that you are using CDS, so basically you can use the CDS(Current Environment connector) to query CDS and the FetchXML is a very nice and easy feature to use while querying CDS.
I will provide you with some links below
Thanks again for your reply.
The problem is I want to extract data from multiple related entities and store the data in a single row in another entity, which will be used for reporting.
Basically I Have Entity1 Entity2, Entity3, Entity4 and I would like a couple of fields from each. if it were a 1:1 relationship I could (probably) work with for each loops but it isnt, so i do not think the for each loop wil work. the FetchXML example will only return data from one entity, unless I am missing something, you cannot return data from multiple entities using the List Records connector?
By using query, you can get a record that relates to another entity.
so, use "Get a record" action with query to all entities, and then store data in a single row.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!