Unanswered

I can't get the information from Dynamics

(0) Share

Report

Posted on by Community Power Pla...

Hello,

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:

formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd')

formatDateTime(utcNow(),'yyyy-MM-dd')

Edición de un flujo Power Automate - Google Chrome.jpg

Edición de un flujo Power Automate - Google Chrome1.jpg

3. Here is what I am getting in the email:

Weekly Report Of New Opportunities - Mensaje (HTML).jpg

All responses (3)

Answers (0)

Jcook 7,770 Most Valuable Professional on at

Like (0)

Report

Re: I can't get the information from Dynamics

Hello,
Those are the GUIDs for the lookups to the main entity.

My suggestion is to do a List records without a filter, this is so you can see what this returns. And than filter on the fields that you want.

Additionally you might need to use that GUID to do a get record and get the appropriate information.
—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
v-bacao-msft on at

Like (0)

Report

Re: I can't get the information from Dynamics

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.

Best Regards,
notj 780 on at

Like (1)

Report

Re: I can't get the information from Dynamics

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.