web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Ressource-Mangement - Link Onedrive file with contact-fields

(1) ShareShare
ReportReport
Posted on by 18
We are a company that is active in the event business and has to organise personnel for events, among other things.
We use MS Dynamics Sales as our CRM and are very satisfied with it.
 
Up to now, there have been two parallel processes for scheduling freelance staff, which I would like to automate with the new CRM:
 
1. so far, without CRM, an internal employee has downloaded an export of all events from Dynamics and then added all events to an Onedrive document. The events were listed manually one below the other by date and, thanks to the shared document, the free employees were able to enter their names live to the right. This meant that everyone knew who was assigned.
 
2. The internal employee then entered the assigned names in the corresponding contact fields in the CRM at regular intervals so that they were also visible to all internal employees.
 
Of course, this cannot continue and must be automated.

The easiest way would certainly be to give the freelancers access to the CRM, but we don't want to do that because of the licence costs and the confidential information.
We just want them to know when which event is where and to enter their details next to it.
 
As Dynamics is new to us, we have so far focussed on larger topics, not yet on those.
 
Does anyone have any ideas on the best way to solve this?
 
I have the same question (0)
  • Suggested answer
    ran_dale Profile Picture
    37 on at
    Hello,
     
    Exciting use case you have here.
    I spontaneously see two possibilities:
    1. you keep the Excel and automate the export and import of the data with Power Automate. For example, the data is stored on the OneDrive with a flow at night and as soon as someone changes something in a row, this adjustment is written to the CRM.
    2. you work with Power Pages and thus have the option of making the data available externally (with login).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 61

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 52 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans