Linking Access to Excel does not work
I have created a simple Access that is connected to a linked table to an Excel file as a data source. I can run the Access without any problems. It accesses the data and everything is fine. But when my colleague wants to run the Access, she gets the following error message "Microsoft Access “C:\Users\User\ [Source Path] .xlsx” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." We use OneDrive/SharePoint in our company and the colleague has access to the folder where the Excel and Access files are located. But it doesn't work. I think it's the path, as it seems to be local. But I don't understand why. This Access in turn serves as a source for another Excel (the target file). There it has a similar error message: ‘’Microsoft Excel [DataFormat.Error] “ [File Name] .accdb” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." I can open and run both the Access and the target Excel without any problems. Thanks a lot in advance. I appreciate your help a lot.Navigating the Cloud: The Differences Between OneDrive and SharePoint
Introduction As a leader, you know how crucial it is to have access to business-critical documents, especially when you're on the go. Cloud storage has become a necessity for any growing organization. You might already be familiar with other cloud applications like Google Drive or Dropbox. So, cloud storage is nothing new to you. However, you may have heard about storage options with SharePoint and wondered what the difference is between the two. Which one should you use, and in what scenarios are they the better options? Don't worry, we've got you covered. We'll explore all of that in this blog. Let's get started! Comparisons Between OneDrive & SharePoint First, we need to talk about the differences between the two applications. SharePoint is built for the purposes of being an intranet site. SharePoint has multiple robust capabilities and features. For starters, SharePoint can utilize document libraries for file storage. See the comparison below to learn more: SharePoint OneDrive Storage Storage Centralized storage for team and organizational files. Personal cloud storage for individual files and documents. Supports large-scale document management and collaboration. Accessible from any device with an internet connection. Integrated with Microsoft 365, providing seamless access to files across various applications. Integrated with Windows, providing a seamless user experience. Sharing Sharing Facilitates real-time collaboration with co-authoring and version control. Easy sharing of files and folders with others. Allows for secure sharing within and outside the organization. Supports real-time collaboration on documents. Provides robust permissions management to control access to files and folders. Provides secure sharing options with password protection and expiration dates for shared links. Syncing & Sharing SharePoint and OneDrive offer syncing and sharing capabilities that enhance productivity and collaboration within organizations. With SharePoint, users can sync files and folders to their local devices using the OneDrive sync app, ensuring that they have access to the latest versions of documents even when offline. This feature is particularly beneficial for teams working on collaborative projects, as it allows multiple users to work on documents simultaneously and ensures that everyone is on the same page. SharePoint also provides robust sharing options, enabling users to securely share files and folders with colleagues both within and outside the organization. Permissions can be set to control access levels, and real-time collaboration is supported, allowing multiple users to edit documents at the same time. On the other hand, OneDrive offers personal cloud storage for individual files and documents, making it easy for users to access their files from any device with an internet connection. OneDrive's sharing capabilities are straightforward, allowing users to share files and folders with others and set permissions to control access. Both SharePoint and OneDrive provide secure and reliable platforms for storing and sharing documents, but SharePoint is more suited for team collaboration, while OneDrive is ideal for individual file management. Best Practices Offline Access: Take advantage of OneDrive's offline access feature to work on files even when you don't have an internet connection. Version History: Utilize the version history feature to track changes and restore previous versions of your files if needed. Workflows and Automation: Leverage SharePoint workflows to automate business processes, such as document approvals and task assignments. Intranet and Communication: Create an intranet site on SharePoint to share company news, announcements, and resources with employees. Conclusion In conclusion, this overview has provided insights into the cloud storage solutions available with your Microsoft Business Licenses. OneDrive is an excellent option for personal storage, enabling employees to access and manage the documents they are responsible for. On the other hand, SharePoint offers a more comprehensive solution for sharing documents across teams, departments, and the organization as a whole. Additionally, SharePoint seamlessly integrates with Microsoft Teams, allowing for direct access to files, folders, and resources associated with SharePoint Sites. For further information on how to implement a storage plan for your organization, please refer to the resources below. Hyperlinks Introduction to SharePoint and OneDrive in Microsoft 365 for administrators - SharePoint in Microsoft 365 | Microsoft Learn OneDrive service description - Service Descriptions | Microsoft Learn Overview of OneDrive in Microsoft 365 - SharePoint in Microsoft 365 | Microsoft Learn OneDrive help & learningBook of Archimedes, Copilot and SharePoint Agents
1. Introduction The Book of Archimedes is a single PDF that contains all posts in the Microsoft Graph Data Connect for SharePoint blog. This includes 40 articles and nearly 400 pages, which is handy for searching for specific keywords quickly across the many articles. The PDF is provided as an attachment to the main MGDC for SharePoint article at https://aka.ms/SharePointData. You can also download it directly from Book of Archimedes. 2. Using the Book with Copilot Beyond searching inside the PDF, you can feed the Book of Archimedes as grounding to your favorite AI tool to get answers to your questions about MGDC for SharePoint. Let's look at an example. You can use this with Copilot or any AI tool that accepts attached files. In my case, I used https://copilot.cloud.microsoft/ to access my work Copilot, the secure and compliant Copilot integrated with my enterprise account. I start with the “+” button and then the “add content” button. Then I used the up-arrow icon to “upload from this device” and selected the local copy of the Book of Archimedes I downloaded earlier. After that, I added my question as a prompt. I tried “What is Project Archimedes?” I got a summary of Microsoft Graph Data Connect for SharePoint, including key scenarios. From there, I could ask any question. If the book contains the answer, Copilot will find it for you. Project Archimedes is the early codename for Microsoft Graph Data Connect for SharePoint. This project aims to deliver rich data assets to OneDrive and SharePoint tenants, enabling them to run their own analytics, derive insights from their data, and understand how they use these products. The data is transferred to an Azure account owned by the tenant, where tools like Azure Synapse, Power BI, or Microsoft Fabric can be used to transform this data into insightful reports and dashboards [1]. Key Scenarios of Project Archimedes: Security: Understanding permissions in SharePoint and OneDrive tenants to ensure content is properly protected. Capacity: Understanding site lifecycle, ownership, and storage used by SharePoint sites and OneDrives. Sync Health: Ensuring users are properly using OneDrive for Business to protect their files by synchronizing them with the cloud [1]. Datasets Provided: Sites: Information about SharePoint sites. Groups: Details about SharePoint groups. Permissions: Information about sharing permissions. Files: Data about files stored in SharePoint and OneDrive. File Actions: Details about actions performed on files. Sync Health: Information about devices running OneDrive Sync. Sync Errors: Details about errors encountered by OneDrive Sync clients [1]. Example Use Cases: Security Scenario: Answering questions about oversharing, external sharing, sensitive data sharing, and permissions. Capacity Scenario: Tracking storage usage, site lifecycle, and identifying large or inactive sites. Sync Health Scenario: Monitoring device health, folder backup status, and sync errors [1]. For more detailed information, you can refer to the Book of Archimedes which contains comprehensive guides, FAQs, and step-by-step instructions related to Microsoft Graph Data Connect for SharePoint [1]. [1]: Book of Archimedes.pdf The more impressive capabilities of Copilot are shown when you ask for something that is not just a direct quote from the Book. For instance, I asked about pricing for a specific scenario: "If a tenant has 1,000 SharePoint sites, how much would it cost to get the SharePoint Sites and SharePoint permissions for that tenant using MGDC?" To estimate the cost of getting the SharePoint Sites and SharePoint Permissions datasets for a tenant using Microsoft Graph Data Connect (MGDC), you can follow these guidelines: Pricing Information: SharePoint Sites and Permissions: The price to pull 1,000 objects from the available MGDC for SharePoint datasets (Sites, Groups, and Permissions) in the US is $0.75, plus the cost for infrastructure like Azure Storage, Azure Data Factory, or Azure Synapse [1]. SharePoint Files: This dataset is billed at $0.75 per 50,000 objects due to its typical high volume [1]. Estimating Costs: Number of Objects: Sites: The number of objects in your SharePoint Sites dataset will be equal to the number of sites in your tenant. Permissions: The average number of SharePoint permissions per site is around 61 [1]. Cost Calculation: Example Calculation: For a tenant with 1,000 sites: Sites Dataset Cost: $0.75 Permissions Dataset Cost: $45.75 Total Cost: $0.75 + $45.75 = $46.50 Additional Costs: Azure Storage: Costs for storing the data in Azure Storage. Azure Synapse: Costs for running pipelines to move the data. For more precise estimates, you can sample the dataset to get a total object count without pulling the entire dataset [1]. [1]: Book of Archimedes.pdf Copilot will also answer questions in other languages. You just ask the question in whatever language you want, and it gets detected… Here’s an example using Brazilian Portuguese. I asked "Quais são os datasets que fazem parte do cenário de segurança?" Os datasets que fazem parte do cenário de segurança no Project Archimedes são: Sites: Informações sobre os sites do SharePoint. Permissions: Informações sobre as permissões de compartilhamento. Groups: Detalhes sobre os grupos do SharePoint. Esses datasets ajudam a entender se o conteúdo está devidamente protegido, respondendo a perguntas como: Está ocorrendo compartilhamento excessivo? Está ocorrendo compartilhamento externo? Dados sensíveis estão sendo compartilhados? Quanto compartilhamento ocorre por rótulo de sensibilidade? Dados sensíveis são compartilhados com usuários externos? Quais domínios externos estão sendo compartilhados? Quais sites foram mais compartilhados? Quais níveis de compartilhamento estão sendo usados? Quais permissões um usuário específico possui? Quais extensões de arquivo são mais compartilhadas? Quanto compartilhamento ocorre no nível de Web, Pasta, Lista ou Arquivo? Esses datasets são fundamentais para garantir a segurança e a conformidade dos dados dentro do ambiente do SharePoint e OneDrive [1]. [1]: Book of Archimedes.pdf 3. Using the Book to create a SharePoint agent You can also use the book to create a SharePoint agent. This will make it easy to ask questions about Microsoft Graph Data Connect for SharePoint without having to upload the PDF every time. To start, upload the Book of Archimedes to a SharePoint document library. Next, select the file and use the option to “create an agent”. That’s it. Your agent is created, and you can start using it immediately. The agent shows up in the document library as a file with the “.agent” extension. You can simply open that file in SharePoint to run the agent. Once you open the agent, it offers you a text box to ask questions. Here is the agent response to “What are the main questions about SharePoint capacity that MGDC for SharePoint can answer?” The Book of Archimedes provides detailed answers to several key questions about SharePoint capacity using Microsoft Graph Data Connect (MGDC). Here are the main questions it addresses: Key Questions about SharePoint Capacity: How much storage is being used by SharePoint sites? This includes understanding the total size of the latest versions of files, previous versions, metadata size, and deleted files in the recycle bin 1. What are the different storage sizes reported for a SharePoint site? Storage Used: Includes all storage, metadata, previous versions, and recycle bins. Total Size: Includes metadata and previous versions but excludes recycle bins. Metadata Size: Storage used by file metadata. Total File Stream Size: Size of the latest versions of files. Previous Versions Size: Size of previous versions of files. Recycle Bin Size: Size of deleted files in the recycle bins 1. How can administrators check the amount of storage being used by SharePoint sites? SharePoint client UX: Viewing storage while using SharePoint as a site user or Site Collection administrator. PowerShell cmdlets: Using command-line tools to query site storage information. SharePoint Admin Center reports: Viewing usage reports in the Admin Center. Microsoft Graph Data Connect: Pulling detailed datasets for SharePoint sites and OneDrives 1. How can administrators create test sites to understand storage reporting tools? Creating different types of test sites (empty site, site with files, site with deleted files, site with previous versions) and analyzing how storage sizes are reported 1. How can administrators estimate Azure costs for MGDC usage? Estimating the number of objects (sites, groups, permissions, files) and understanding the billing rates for different datasets 1. How can administrators use MGDC to run detailed analysis of SharePoint and OneDrive storage metrics? Using detailed data in MGDC to analyze storage metrics and understand the impact of metadata, versions, and deleted files 1. Tools and Templates: Capacity Template: Includes instructions, ARM template, Azure Synapse pipeline template, and Power BI template to help administrators use MGDC datasets for capacity analysis 1. Conclusion: The Book of Archimedes provides comprehensive guidance on leveraging MGDC to gather, store, and analyze SharePoint data, ensuring effective data management and security. It is a valuable resource for administrators and developers working with SharePoint and OneDrive data using MGDC 1. Would you like more specific information on any of these questions or tools? 1: <File>Book of Archimedes</File> As we did with Copilot, you can also ask any question on a topic addressed in the book. You can also use languages other than English. You can experiment with editing the agent to rename it, change the description, add more sources, adjust its behavior, offer sample starter prompts, include specific instructions or even customize with Copilot Studio. Just use the option to "edit the agent". You can also share the agent just like you share any file in SharePoint. You can learn more about SharePoint agents in this YouTube video by Vesa Juvonen: https://www.youtube.com/watch?v=pYvK76SVEv4 4. Conclusion I hope you enjoy using the Book of Archimedes as grounding for your AI tools. As usual, remember that AI tools may make mistakes and you should always double-check the answers you receive. There is also a chance that a particular AI tool might not be able to handle a large document like the Book of Archimedes, currently weighing in at around 10MB.Quickly add approval workflows to any list or library in Microsoft 365
Leverage the power and simplicity of lightweight approvals on any list or library with a few simple clicks! SharePoint and Teams seamlessly integrate across files, lists, loops, and pages. And now, we’re excited to release the latest integration. SharePoint + the Teams Approvals app bringing you fast, easy approval-tracking business solutions – to any list or library. A single toggle gets you started: Create, approve, reject, and cancel – without leaving your content or the context of your conversations. Whether you need to approve a purchase order, a vacation request, project milestones, or a blog post, Approvals in lists and libraries help streamline the process and collaboration among your team members.
Basic email attachment to sharepoint flow not working
Hey Everyone! First off, I have to preface this request by mentioned that I am a complete Flow newbie. My background is typically on the Network side of things, so messing around this this has been on an adhoc nature, with no exposure to it before. I'm working on creating a Flow, which I believe should be fairly basic. I want to monitor my inbox, for emails from a specific sender, and save attachments to a Sharepoint folder. This is my Flow configuration: This current configuration doesn't appear to be working, no attachments from the sender have been saved into the specified folder. I've verified that both my Email and Sharepoint connections are linked. When I do the test, I see the expression as false when scanning for emails, see photo below: Would anyone have any thoughts or ideas on why this wouldn't be working? any help would be appreciated! Thanks, Mike
SharePoint form customized with Power Apps not displaying
We have a SharePoint list with a form that was customized using Power Apps a few years ago. Recently, I was informed that the form is not loading. I don't know how long it has been broken, or if it started after a change to anything in the environment. I'm able to replicate the issue using Chrome and Edge. In Edge, it displays a blank screen, in Chrome, it shows "apps.powerapps.com refused to connect". In the browser Dev tools I am seeing the following error: Refused to frame 'https://apps.powerapps.com/' because an ancestor violates the following Content Security Policy directive: "frame-ancestors 'self' https://*.powerapps.com". We've made some adjustments to the CSP settings in Power Platform Admin for the Default environment, but have not been able to resolve this yet. The current setup we are trying today is in the image below. I was hoping that by removing all of the sources, we might be able to get it to work, but no luck thus far. Previously, we had some domains entered in Source, like 'self', and *.powerapps.com, and even added some other ones yesterday. It doesn't seem to change the exact text of the error I'm seeing in the browser dev tools, which makes me wonder if there's a long timeframe between those changes and when they are fully in effect, or maybe I'm going down the wrong path entirely. If anyone has some additional troubleshooting guidance, I would greatly appreciate it. Thanks! Brian
