Work or School Accounts Now Enabled in Community!
On May 12 Work or School Accounts were enabled in Community, along with Microsoft accounts (MSA). This allows seamless navigation between Community, Dynamics 365 applications, and Azure Active Directory enabled sites while logged into your Work or School account.
Read more | Managing Accounts
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I am working with a flow template, Receive a weekly email summary of new Dynamics 365 opportunities. I brought in Account, Owner and Created by Columns in the HTML table however when the flow is run, then In the email the table is showing the GUIDs for the Accounts, Owner(User) and Created by(User).
I want to display the actual values of the Account Name, Owner Name and Created by Name in the columns. Is there anyway to do this?
Any help on this will be greatly appreciated.
Do you use the Dynamics 365 connector?
The (premium) Common Data Service connector will resolve the names.
If you can't/don't to use that connector, you should add extra actions to get record of Account, User (Owner) and User (Created by). Add the Name field from that actions to the html table.
I am using Dynamics 365 connector, with List Record Action. i don't have Premium CDS connector. Can you please explain where should i Add extra action Get Record for Account and users? Should I add the Get connector after List Record and before Create HTML?
This inspired me to write a blog post with the solution for this.Link: 2die4it.com/.../schedule-daily-email-with-summary-of-opportunities-from-dynamics-365-ce-in-flow
Please Verify my answer, thanks! ;-)
Thanks for your blog, I assume you have used CDS connector for this flow however, in Free addition List Opportunity record connector is not available. It would be really helpful if you can lists the steps for Get Records for this flow.
I've used only the Dynamics 365 connector, since you don't want to use the CDS connector.
The List Opportunity records is the same List records connector you're using, I just renamed it.
My blog post describes all the actions you need. The Get record action are part of the Apply to each loop.
Thanks for your quick reply. I have now replicated your steps but I am getting an error on The Filter Query. I am using the following Expression
createdon ge formatDateTime(body('Get_past_time'),'yyyy-MM-dd')
Error code is:
"message": "Syntax error at position 16 in 'createdon ge2019-02-07'.",
"debugInfo": "clientRequestId: 3541999d-4cb6-446f-8f17-93ad132823e0"
See scenario #2 at:
Hi Stefan, Thank you very much for your help on this.
I have one more question. Is there any possibility to filter the report by a business unit. For example I want to send a report of the opportunities for each business unit separately. At the moment the flow is fetching all the opportunities records from the entire organisation.
You could set the filter on business unit in the List records action like this: _owningbusinessunit_value eq 15BEAA01-9716-E611-80E3-D89D6763EFEC (guid of bu)
Business Applications communities