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 @mvalenciam ,
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.