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

Samuel Z Guzman 0 Reputation points
2024-09-23T20:56:11.85+00:00

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?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,113 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,652 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. hossein jalilian 6,830 Reputation points
    2024-09-23T22:46:25.2266667+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.