Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Receive a weekly email summary of new Dynamics 365 opportunities - Template tweak

Hi I'd like to make two small tweaks to the default "Receive a weekly email summary of new Dynamics 365 opportunities" template but I keep running into a hiccup, any help woudl be appreciated.


I want to filter the results to only show 'Open' Opportunities instead of all Opportunities including closed.


I want to find a way to add the account name and resolve it to the actual account name in Dynamics, at the moment when I choose Account from the 'Dynamic Content' is shows the ascii name instead of resolving that to the actual account name.


Any help woudl be greatly appreciated.




Community Support
Community Support

Hi @CarlFarmer


How would you check if the Opportunities is Open or closed in microsoft flow?Or according to which field you could know the Open or closed situation of Opportunities?

Could you please share a screenshot of the flow to choose Account from the 'Dynamic Content' is shows the ascii name?


Please share more details so we would try to provide a proper workaround for you.


Best regards,




Alice, thanks for the reply.


The create HTML section is where the Flow pulls the values from Dymanics.



The status label value relates to 'Won', 'Lost' and 'Open'




That produces this report with a mix of Won, Lost and Open entries.




I would like to filter this to just 'Open' and nothing else.




If I add the 'Account' field to the HTML option below.




It adds the entry below to the report but does not resolve the account name to the ID.

I guess it needs some sort of lookup code?




Any help on either or both of these queries would be greatly appreciated.




Hi @CarlFarmer,


You could add a Filter Array action under the list records action to filter Status Lable to just 'Open' and nothing else.

The screenshot of the flow should as below:




Best regards,


Hi, I am struggling with how to add a Filter Array?

It looks like you have dropped it in between the List Records and Create HTML table sections but I can see how to do that.

When I click the plus sign I get the options beow and none of these seem to give me a Filter Array section to add.




Sorry if this seems like a really basic question!




Hi @CarlFarmer


Please choose add an action, and the you could input the "Filter Array" in the input field to search for the  "Filter Array" action:




Best regards,


Hi, unfortunately that did not have any affect on the output.

The flow fan successfully without error but the output was exactly the same.


I suspect the filter needs to be applied in the list records (Filter Query) section below but I don't know how to format the syntax.

I tried taking the syntax the 'Filter Array' option you suggested and entering it here but it failed immediately.


Thanks for your help.





Did we ever have a solution for this issue? I am having a similar issue when I add the Owner column from the Opportunity it does not display the name rather than the ID much like the Account issue you reported.



Any updates on anything would be helpful,





I'd like to know too. I want to add owner and account to the table but just get the GUID instead and can't figure out how to add the labels. 

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,445)