Answers.Body: <p>If you want to show CiviCRM data in Office 365, I would rather considering using Microsoft Power BI.</p>
  <p><a href="https://civicrm.stackexchange.com/a/39681">https://civicrm.stackexchange.com/a/39681</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-24T09:53:33.453Z
Answers.Text: Thanks for that suggestion. We want to use CiviCRM as the authoritative source of contact details in SharePoint rather than someone maintaining another list. The idea of a data processor (I need to learn what that is) seems a good one. I've been exploring REST. I haven't discovered how SharePoint could read JSON or even if it can.
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-22T17:23:36.037Z
Answers.LastActivityDate: 2021-06-22T17:23:36.037Z
Answers.UserDisplayName: Flying
Body: <p>We run both CiviCRM and SharePoint. I've looked at the CiviCRM SharePoint extension, but:</p>
  <ol>
  <li>It didn't work - it gave errors.</li>
  <li>We are looking at exposing CiviCRM contacts in SharePoint - we don't need document sets, but just an external list with the CiviCRM data.</li>
  </ol>
  <p>It looks as though SharePoint likes to get external data via the Odata format. Has anyone any experience of that?</p>
  <p>I suppose it might be possible to devise something that populated SharePoint list from contacts, perhaps based on the SharePoint extension.</p>
  <p>Any suggestions?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-06-16T20:27:28.020Z
Comments.Text: maybe add the errors you got?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-06-18T17:14:59.697Z
Comments.Text: I tried re-installing CiviCRM SharePoint, but can't set it up because you need to log in on the CiviCRM SharePoint setup screen. That didn't work because the library is a required field and you can't get that until you have logged on, so Catch-22 applies, it seems. Either  that or there is an issue with MFA and the SharePoint account.
Comments.UserDisplayName: Stephen Palmstrom
Tags: <contacts>
Title: CiviCRM and SharePoint
ThreadText: # CiviCRM and SharePoint
  
  (Asked by: username_0 on 2021-06-16)
  
  We run both CiviCRM and SharePoint. I've looked at the CiviCRM SharePoint extension, but:
  
  1. It didn't work - it gave errors.
  2. We are looking at exposing CiviCRM contacts in SharePoint - we don't need document sets, but just an external list with the CiviCRM data.
  
  It looks as though SharePoint likes to get external data via the Odata format. Has anyone any experience of that?
  
  I suppose it might be possible to devise something that populated SharePoint list from contacts, perhaps based on the SharePoint extension.
  
  Any suggestions?
  
  **Tags:** contacts
  
  > **Comments:**
  > **username_1**: maybe add the errors you got?  
  > **username_0**: I tried re-installing CiviCRM SharePoint, but can't set it up because you need to log in on the CiviCRM SharePoint setup screen. That didn't work because the library is a required field and you can't get that until you have logged on, so Catch-22 applies, it seems. Either  that or there is an issue with MFA and the SharePoint account.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2021-06-22. Score: 1
  
  If you want to show CiviCRM data in Office 365, I would rather considering using Microsoft Power BI.
  
  <https://civicrm.stackexchange.com/a/39681>
  
  > **Comments:**
  > **username_0**: Thanks for that suggestion. We want to use CiviCRM as the authoritative source of contact details in SharePoint rather than someone maintaining another list. The idea of a data processor (I need to learn what that is) seems a good one. I've been exploring REST. I haven't discovered how SharePoint could read JSON or even if it can.  
  
  ---
  
  