Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
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 TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I have a situation where I need to upload users (different ones for each opportunity) to be Access Team Members for the opportunities. Thousands of opportunities, 1 Access Team template, different users added to each opportunity.
Anyone know how to do this? I can't seem to find a data import template that makes sense.
Here are several ways you can go:
1. PowerAutomate (Former Flow). Create a table with pairs opportunityid, systemuserid somewhere Power Automate can get data from. Read it, and through CDS - Current Environment Connector call message that adds a user to opportunity access team.
2. Customization + Workflow + My Ultimate Workflow Toolkit. Create an entity with 2 lookups - one for opportunity, one for user. Create a workflow that triggers on create of that entity and using Ultimate Workflow Toolkit adds user to opportunity team (I have a special step for that). Using "Standard Import" import data to your custom entity that causes workflows to trigger and do what you need.
3. Write a custom app that will do what you need.
Create using Power Automate, for OpporutnityID and SystemuserID to get data, then, use CDS to add a user in your team.
Andrew, thanks so much! I implemented your ultimate workflow toolkit and it did exactly what i needed!
Business Applications communities