Browser Sign in Sharepoint Authentication within Alteryx App

Question

Hi everyone,

was hoping you could help me with something. I'm building an app currently that a range of users will be running. Part of the app involves importing data from a SharePoint file, however when other people are running the app they are encountering the SharePoint authentication failed error, understandably. I was wondering if there is a way to offer browser sign in functionality to app users? I had a quick play with the DCM interface tool but seeing as we use browser sign in, I'm not sure how helpful that will be.

Thanks for your help.

dreldrel · Answer

Thanks for sharing! This very informative

Driftboss3d · Answer

Hey, I ran into the exact same issue with SharePoint auth in a multi-user app — super frustrating at first! What worked for us was switching to a browser-based OAuth flow so each user could authenticate via their own browser session (kind of like giving each driver their own car in Drift Boss — no more crashes). Definitely worth looking into if you want smoother onboarding!

roxanne41watts · Answer

Hi there! I understand how frustrating authentication issues can be. To enable browser sign-in functionality for your app users, you can use the Microsoft Authentication Library (MSAL) for JavaScript. This library allows you to integrate browser-based sign-in with SharePoint. Here's a high-level overview of the steps you'll need to follow: Register Your App: Register your app in the Azure portal to get the necessary credentials (Client ID, Client Secret, Redirect URI). Install MSAL.js: Add the MSAL.jslibrary to your project. Initialize MSAL: Create an instance of the PublicClientApplication class with your app's configuration. Sign-In: Use the loginPopup() or loginRedirect() method to initiate the sign-in process. Access SharePoint: Once authenticated, use the acquired tokens to access SharePoint resources. Here's a basic example to get you started: SharePoint Authentication Replace YOUR_CLIENT_ID, YOUR_TENANT_ID, and YOUR_REDIRECT_URI with your actual values.