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

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

notj 782 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No