I need to get a weekly report of new opportunities from Dynamics 365, but I am having some trouble getting it. My problem is that all fields are from Opportunity Entity but I need to filter the opportunities by the field 'Country' which is in Account Entity. Here is what I did and what I am getting:
1. After trigger the flow with the action Recurrence:
3. Here is what I am getting in the email:
Try a compose action on the returned items, so you can get an idea of the fields/data returned. That might help you target more specific fields in your html table.
Hi @Anonymous ,
Do you want to add some field values from these two entities to the same table?
Is there any relationship between them? Please provide more details so that we can provide you with the right solution.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.