Sharepoint Lists Integration with Azure Key Vault for Password Authentication?

Question

Sharepoint Lists Integration with Azure Key Vault for Password Authentication?

Anmol Ganju 176

Hi I have a logic app where I am using Sharepoint lists for moving the data from an Azure SQL Databases, currently am using Sharepoint online direct account credentials to connect to sharepoint online, but once this is moved to production I want to eliminate the use of username and password directly, and it can be featched from something like Azure Key Vault or Azure Active directory application maybe, is there any secure way to get this to work or using username and credentials is the only option here?

Jinwei Li-MSFT 4,736 Reputation points Microsoft External Staff

2022-12-13T09:24:46.12+00:00

Hi @Anmol Ganju ,

Good days, thanks for querying in this forum. We’re happy to help you.

From your description, it seems that you want to find a secure way to get this to work or using username and credentials is only option in Azure logic app.

If my understanding is right, we’d love to help you, since our community focus on general troubleshooting and built-in features in SharePoint Online environment, the question you mentioned is related to Azure logic app, we’d suggest you go to Azure Community to post a new thread, which is specific channel to handle such situation. The engineers in related team will focus on your specific scenario and provide specific suggestions. They also have enough environment to help you test it.
If the scenario above is not consistent with yours, you can also post back and point that.

Thanks for your cooperation.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Anmol Ganju 176 Reputation points

2022-12-13T10:39:09.51+00:00

sure thanks I will do that.
Jinwei Li-MSFT 4,736 Reputation points Microsoft External Staff

2022-12-15T08:34:34.76+00:00

Hi @Anmol Ganju ,

Is there any update on this thread?

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

1 answer

Your answer

Jinwei Li-MSFT 4,736 Reputation points Microsoft External Staff

2022-12-13T09:24:46.12+00:00

Hi @Anmol Ganju ,

Good days, thanks for querying in this forum. We’re happy to help you.

From your description, it seems that you want to find a secure way to get this to work or using username and credentials is only option in Azure logic app.

If my understanding is right, we’d love to help you, since our community focus on general troubleshooting and built-in features in SharePoint Online environment, the question you mentioned is related to Azure logic app, we’d suggest you go to Azure Community to post a new thread, which is specific channel to handle such situation. The engineers in related team will focus on your specific scenario and provide specific suggestions. They also have enough environment to help you test it.
If the scenario above is not consistent with yours, you can also post back and point that.

Thanks for your cooperation.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Anmol Ganju 176 Reputation points

2022-12-13T10:39:09.51+00:00

sure thanks I will do that.
Jinwei Li-MSFT 4,736 Reputation points Microsoft External Staff

2022-12-15T08:34:34.76+00:00

Hi @Anmol Ganju ,

Is there any update on this thread?

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 1

@Anmol Ganju Thanks for reaching out.

At the moment, the sharepoint authorization works with the OAuth 2.0 Authorization Code Grant Type, which means, you can only get the authorization code by getting the user sign in to get the code. This behavior of the API is by design. Thus, there is no way to fully automate this and you need to use username and password for the sharepoint connector authentication.

Consider not re-creating api connection after initial manual authentication since there's no need unless cred changes, and only include logic apps in arm template for subsquent deployment.
Consider using HTTP with MSI to call graph API directly.

For connection resource define you can refer to this.
More details : https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-deploy-azure-resource-manager-templates#authorize-oauth-connections

Share via

Sharepoint Lists Integration with Azure Key Vault for Password Authentication?

1 answer

Your answer