Unanswered

How to create a Weekly Opportunity Summary with Opportunity Products (Dynamics 365 + Microsoft Flow)

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I've been doing some experimenting with using Microsoft Flow with Dynamics 365 to generate a weekly email summary of newly created Opportunities. I see that there's a handy template for this, but I'm also wanting to include the information from the Opportunities associated Opportunity Products (so their child records basically). I've run into a bit of a roadblock trying to figure this out so would appreciate some help.

2019-07-25 16_36_08-Edit your flow _ Microsoft Flow.png

I'd be wanting to include the Opportunity Products in the HTML table that gets added to the email body - noting that their can be multiple products associated to any one opportunity.

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous

Please see the solved thread below where I have shown how you can access related records for a record of a parent entity.

https://powerusers.microsoft.com/t5/Building-Flows/Sales-Rep-from-Dynamics-to-HTML-Table/m-p/291411#M30604

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @yashag2255

Thanks for your reply - I tried following the thread you linked and I seem to across an error with getting the child records:

Here's the Apply to each action for reference:

Any ideas?

Thanks,

Was this reply helpful? Yes No