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:
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.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Find your favorite faces from the community presenting at the Power Platform Community Conference!