how can I authenticate with a service principal in sharepoint using logic apps to move data

Question

I created a logic application that reads excel tables and lists from a sharepoint, I authenticated with my user, but now I must authenticate with a service principal for security and independence, is it possible to do this? How can I do it?

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

Yes, it's possible to authenticate with a service principal in SharePoint using Logic Apps.

• Go to Azure Active Directory in the Azure portal, create a new App Registration and note down the ApplicationID and Directory ID.
• In the App Registration, go to Certificates & secrets, create a new client secret and save it securely.
• In the App Registration, go to API permissions, add the necessary SharePoint permissions and grant admin consent for these permissions.
• Go to your SharePoint site, add the app to the site by navigating to Site contents > New > App then choose An App to add and select your registered app.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful