App
857 TopicsCopilot, Access, and VBA
I don't know how many of you use Copilot to assist you with Access. I developed my own application using Copilot and it was extremely helpful. I recommend you give it a try to see if it can help you. Here is an article I wrote on it in case you're interested: https://medium.com/@jmsp4home/did-my-own-spending-income-tracking-software-using-microsoft-copilot-heres-why-and-how-it-went-1aa8b4814cca?source=friends_link&sk=64ebb3ecf7e5b19c05d1731a571b100187Views0likes7CommentsRegarding the "App Catalog" in SharePoint 2019
Hi there, When the customization (ListView Command Set extension: Microsoft Sample: Build your first ListView Command Set extension | Microsoft Learn) was done, and it was uploaded to the App Catalog (http://win-xxxxx:19065/sites/apps), everything was well. And I also can "Add an App" in the "Site Content" But I cannot find any changes in my list in "http://win-xxxxx:19065/", I try to create a new list, and the custom function went well in App Catalog (http://win-xxxxx:19065/sites/apps). Even I want to "Add an App" in "http://win-xxxxx:19065/", I also cannot find the new App in "App you can add". Is there any idea on this? or which steps was ignored? Thanks107Views0likes2CommentsProject Online (CSOM): Encountering 'User Not Found in Active Directory or Project DB'
Issue We are attempting to access Project Online data in Project Permission mode using app-only authentication, specifically to bypass MFA for programmatic access, as we aim for continuous, automated access without any user-interaction. We are using CSOM, using Microsoft.ProjectServer.Client.ProjectContext in .NET 4.8 to connect to Project Online. Despite following several documented approaches with client certificates, client secrets, and OAuth configurations, we keep encountering errors like 401 Unauthorized and User not found in Active Directory or in project db. Below is a summary of our steps. Despite multiple attempts, we consistently receive errors blocking access. We have followed recommended documentation for client credentials, certificates, and permissions but still face access issues. Technology Project Online CSOM in .NET 4.8 Microsoft.ProjectServer.Client.ProjectContext Azure AD (Entra ID) Solutions Attempted Client Certificate Authentication: Configuration: Registered an app in Azure AD (Entra) with a client certificate and set permissions including Sites.FullControl.All. NOTE: we could not select Project permissions (Project.Read, etc.) in the Application Permissions screen, only within the delegated permissions screen. Token Acquisition: We acquired an access token using az account get-access-token --resource=https://.sharepoint.com. Request Attempted: URL:https://.sharepoint.com/sites//_api/ProjectData/Projects Outcome: {"error":"invalid_request","error_description":"App is not allowed to call SPO with user_impersonation scope"} Client Secret with Client Credentials: App Registration: Configured client ID and client secret in Azure AD with permissions for Project.ReadWrite.All and Sites.Selected. Token Acquisition: Called the token endpoint: Endpoint:https://login.microsoftonline.com/{TENANT_ID}/oauth2/v2.0/token Parameters: client_id, scope=https://.sharepoint.com/.default, client_secret, grant_type=client_credentials Access Attempt: URL:https://.sharepoint.com/sites//_api/ProjectData/Projects Response: HTTP/1.1 401 Unauthorized Response Body: "" Outcome: Despite obtaining a valid token, the request returns a “Please sign in” page, rather than an access token. SharePoint AppPermissionRequest Configuration using /sites/pwa/layouts/15/appinv.aspx: Configuration: Set up AppPermissionRequest XML in SharePoint for permissions like: Outcome: This configuration did not make any differences, and did not grant the required permissions in Project Permission mode, as SharePoint app permissions do not seem to cover Project-specific access, it seems. Project Online access remains blocked. <AppPermissionRequest Scope="[http://sharepoint/content/sitecollection]" Right="FullControl"/> Microsoft Graph API Exploration: Goal: Investigated Graph API as an alternative. Outcome: Microsoft Graph lacks Project Online-specific permissions, limiting access to SharePoint and directory data, which does not meet our need for project-specific data access. Microsoft.Identity.Client and client certificate Configuration: CSOM using the following code to login: Outcome: Access fails withUser:<customercontent></customercontent> not found in Active Directory or in project db public static void Login(this ProjectContext context) { var clientId = "xxx"; var clientSecret = "xxx"; var authority = "https://login.microsoftonline.com/xxx"; var scope = "https://xxx.sharepoint.com/.default"; var certificate = new X509Certificate2("c:\\temp\\cert.pfx", "xx"); var app = ConfidentialClientApplicationBuilder.Create(clientId) .WithCertificate(certificate) .WithAuthority(new Uri(authority)) .Build(); AuthenticationResult result = TaskHelper.BlockingAwait(() => app.AcquireTokenForClient(new[] { scope }).ExecuteAsync()); string accessToken = result.AccessToken; context.ExecutingWebRequest += (sender, e) => { e.WebRequestExecutor.RequestHeaders["Authorization"] = "Bearer " + accessToken; }; } Key Questions: Is there a method for app-only authentication in Project Online in Project Permission mode__ that bypasses MFA for automated access? Has anyone succeeded in applying app-only credentials for Project Online access__, specifically in Project Permission mode? Are there any alternative permission configurations__ (like Azure AD settings, conditional access policies, or app permissions) that could facilitate this access? Thank you in advance! Edit: Sorry for the bad formatting.15Views0likes0CommentsBulk Import
Is there a way to bulk update tasks? If you have a list of requests that need to go out, do I have to individually add each task or can I upload an excel with information to create the tasks? Perhaps there is an option using Power Automate to take items from excel to power automate but haven't tried and wasn't sure if there was a built in feature that doesn't require me to build something custom.12Views0likes0CommentsConnecting to Azure SQL Database using SQLAlchemy and Microsoft Entra authentication
Unlock secure, password-free connections to Azure SQL Database using Microsoft Entra Authentication and SQLAlchemy with this in-depth guide. Learn to configure Microsoft Entra as your SQL Server user and connect seamlessly using Python’s SQLAlchemy library—all without hard-coded credentials. Discover why Microsoft Entra Managed Identity surpasses traditional SQL Authentication by enhancing security, simplifying access management, and centralizing identity controls. Perfect for developers looking to boost data protection and streamline authentication workflows in Azure, this step-by-step solution empowers you to safeguard your database while maximizing efficiency and ease of use, while bringing your solution closer to production readiness. Dive in to elevate your Azure SQL security and performance!1KViews1like0CommentsSharePoint site built as Teams App opens all windows using browser instead of within Teams App
Hi, Need help. Problem: SharePoint Site (built as Teams app) opens all links outside Teams App using my default browser. This is the case for all links even those that are set up in SharePoint site to open in the same window. (Used this link to create the Teams App for the SharePoint site:https://techcommunity.microsoft.com/t5/microsoft-teams/add-sharepoint-site-as-a-app-to-the-teams/m-p/2864482) Am I missing any requisite steps?NiezinkJF- tagging you as you may have answers for me. Thank you very much.1.1KViews0likes2CommentsOpening and Viewing Option for Two MS Project Files Simultaneously on Two Screens?
Hi Can two MS Project files be opened on two different screens at the same time? This option is should be there as it is for other usual MS software like Word, Excel etc. Hope this can be fixed as will ease out while working from two parallel files simultaneously. Appreciate if this can be looked at, please asap. Looking forwardSolved142KViews0likes40CommentsImported DOTX template creates error when opening document in app
Hi all, Just created a new library for testing a few things with documents. I imported a fully working sample template (it works on a local disk and network share) to my SharePoint library: When clicking it, it successfully creates a Word document that opens in the Word desktop app, but it's then showing this: Translation: "Word was unable to read this document. It may be corrupted. Try one the following operations: - Open and repair the file - Open the file with the Text Recovery Converter" If I then close it and right click -> Open in browser, it get this popup (first time opening the DOCX): I can then edit my template. Furthermore, if I click on "Edit" ("Modification" here) -> Open in app, it get the same error message as above. This problem is occuring with every template I upload (they are all created with Word M365 version if you're wondering). I want my users to be able to edit a template-generated document from the app, like any other doc. What is going on here? Thanks in advance for your help!416Views0likes3CommentsUser information in Organization assets library Word templates
If you have a Word template in Organization Assets Library that you want to work on all devices (PC, Mac , Word Online etc), what is the best practice to prefill the logged in users information (name, title, department) from Azure directory?920Views0likes1Comment