Power automate SharePoint list update
Greetings, I want my company SharePoint to show data (a priority list) from another companies SharePoint. I want to auto check for updates and changes as well. Can they give me permission to integrate the list on my SharePoint? Or would I need to copy the file, and then power automate so it looks for changes in their list and then updates my list accordingly?Create and share Copilot agents in SharePoint in a few clicks
Go behind the scenes to learn more about Copilot agents in SharePoint, powered by your content. What could be better? Copilot agents are built in Copilot Studio via our new, built-in lightweight agent builder experience in SharePoint. CJ and Karuana discuss the broader vision of Copilot agents and show you how to put this new capability to work within your SharePoint sites in Microsoft 365 - including IT management details and licensing insights. Check out the newMicrosoft 365 Copilot agents in SharePoint adoption hub: https://aka.ms/SharePoint/agents. In addition, review the recent, related blog, "Microsoft 365 Copilot Wave 2: AI Innovations in SharePoint and OneDrive" by Adam Harmetz and Jason Moore. And review this short explainer video, "Copilot agents in SharePoint" taken from the "Microsoft 365 Copilot: Wave 2" event with Satya Nadella and Jared Spataro event broadcast - watch now:Tech Community Live | AMA for SharePoint, OneDrive, Lists, and Stream
Join us for a special Ask Microsoft Anything (AMA) live video stream across four Microsoft contentcollaborationproducts: SharePoint, OneDrive, Lists, and Stream! Our product teams will be answering your questions about future roadmap and recent innovation – and offering insights on what to expect in the coming months. Each team will present five minutes of content to catch you up on the highlights, and to spark what questions you might ask, and then have 10-15 minutes to take your questions. Post your questions at any time – starting your question with the product name to help us navigate it to the right experts; example: “SharePoint: How will Copilot help me create pages and news in the future?” This is a great opportunity to get answers to any questions you may have from recent Microsoft 365 Conference (May 2-4, 2023) disclosures: Review Jeff Teper’s May 2nd (5/2) blog post. Agenda + Experts (all times listed in the Pacific Time Zone (PT): 10:00am Kickoff [MC: Mark-Kashman] 10:05 – 10:25am -- AMA | SharePoint Experts: Dave Cohen (US), Cathy_Dew, and Suyog Gadgil. Huge innovations that will make it simpler to build compelling and engaging pages and sites within your company intranet. Review the 5/2 SharePoint blog. 10:25 – 10:45am -- AMA | OneDrive Experts: Miceile Barrett, Paul Diamond, Gaia Carini, Carter Green, andvilodha. Get the most out of your files with significant updates to the overall OneDrive user interface – a more simple and personalized experience. Review the 5/2 OneDrive blog. 10:45 – 11:10am -- AMA | Lists Experts: Miceile Barrett, LincolnDeMaris, and Harini Saladi. Your information collaboration is poised to get more intuitive, focused, and powerful. Review the 5/2 Lists blog. 11:10 – 11:30am -- AMA | Stream Experts: Marc Mroz, descapa_msft, Paul Diamond, Ignacio Davila, and OwenpMSFT. Video in Microsoft 365 is about to get easier, with enhanced playback, putting videos in pages, and recording professional videos with personality. Review the 5/2 Stream blog. 11:30am -- Wrap up Submit your questions anytime during the hour or post them early in the Comments below.
Patch data from 5 forms in Powerapp to a single line in sharepoint
Hi All, I'm trying to patch data from 5 forms in Powerapp to a single line in sharepoint. I tried using the below formula in the OnSelect for the submit button but it's not working. Any advise? If(Form_approvers.Valid && Form_Payinfo.Valid && Form_eventinfo.Valid && Form_spiltcosts.Valid && Form_receipts.Valid && Form_addline.Valid, Patch(RnRExpenses, Defaults(RnRExpenses), Form_approvers.Updates, Form_Payinfo.Updates, Form_eventinfo.Updates, Form_spiltcosts.Updates, Form_receipts.Updates, Form_addline.Updates))SharePoint: From Concept to Creation to Impact + Live AMA
SharePoint is the world's most flexible content platform, with over2 billion filesadded daily and more than2 million sitescreated each day. It's the only content platform that spans the entirety of your diverse content management needs - from engaging pages and branded site building to powerful workflow, document library, automation and collaboration needs. At this event, we want to shine a light on the latest SharePoint capabilities and share glimpses of what some of our customers are doing with it. Get clarity on what's available, tips and tricks, and the boundaries you can now push with the latest. If you use SharePoint to create sites, publish news, manage workflows, collaborate with peers – or are simply curious about how agents can transform your intranet – this event is for you! Skill up yourSharePoint IQwith the latest on: Simpler authoring & more compelling content – Lower barriers to create professional-looking content and ensure you can harness the best of what the web has to offer for your intranet Greater engagement & reach – Scale your message to meet people where they work. Powerful workflow, automations and agents – Build automated subject matter experts and save your team time while managing and automating content workflows. We will also have dedicated time during the event forlive Q&Awhere you will get to interact with multiple product makers – bring yourquestions and feedback. You won't want to miss this great opportunity to inspire, and be inspired by, our amazing community of SharePoint communicators and creators.We can’t wait to celebrate and learn how you plan to get even more out of your beautiful, smart, high-impact intranet and content management solution. Save the date(Jan 29, 2024) and see you there! Related resources "Ignite 2024: Agents in SharePoint now in general availability” by Adam Harmetz. Microsoft Ignite 2024 breakout session:Reimagine content management with agents in SharePoint. Subscribe to theSharePoint blog. Follow us onsocial. Learn more aboutSharePoint.
Limiting powerapps form person field to members of one sharepoint site returns no values
Hi there, I am working on an app, and I would like to limit the output on a Person field to only the Sharepoint Site Members. Whenever I go into the field in SharePoint and set the limit to our Sharepoint Group members in the List Settings, the dropdown does not show any results. How would I work around this, or what might cause this issue?
Word Doc properties not updated in doc body
Hi, sorry if i am repeating the topic, could not find one that would answer my issue. I have a document template with 2 tables on the page: Table 1 contains info from the template like - Document ID, version, Template approver and Template approval date Table 3 contains info from the procedure - Document ID, version, Document approver and Document approval date. Template is being approved through Power Automate flow. Data in table is updated through flow and all works as expected. However, document after approval flow does not update Document properties in the Table 2, specifically document approver and document approval date. Document ID is updated and version also. I have checked Info of the document, and fields are updated but it is not reflected in the table. If i add it manually again, it does place the correct values, but then my this is seen as change and approval flow needs to be triggered again. Any ideas how to solve this? Thanks.
Sending a PDF file as an email attachment with Power Automate corrupts attachment
I have followed this great tutorial for creating and sending digital certificates to event participants (https://techcommunity.microsoft.com/t5/educator-developer-blog/send-digital-certificate-to-event-participants-in-8-easy-steps/ba-p/3697139), and everything worked except for the last step which is sending the email with the certificate attached.I am able to receive an email with the pdf attached however, the file is corrupted and I'm unable to open it. When I check the pdf file in my share point it is not corrupted so the issue seems to be in the step of sending the email. I tried usingbase64ToBinary(base64(body('Convert_file'))), when I added this I was able to open the pdf attachment but the pdf was empty and the content was erased. Please let me know if there is any way to overcome this issue.
Flow to replace SharePoint site page text web part content from form entry
I wish to trigger a flow from a form and use a response value to replace the text values in a text web part in a specific page in "Site Pages". I have tried 2 options but neither of them work. I had a look at this method but I found it confusing plus I would not be able to share/email the page because of the dynamic nature of the content. I am getting a error on the final action (version 1) or having the content canvas completely removed including canvas header (version 2). TRIGGER (both options): When a MS Forms response is submitted ACTION 1 (both options): Get response details ACTION 2 (for option 1): Get Digest Token (via Send an HTTP request to Sharepoint (POST)) ACTION 3a (option 1): Update Web Part (via Send an HTTP request to Sharepoint (PATCH)) -- RESULT: Action 'Send_an_HTTP_request_to_SharePoint_-_Option_1' failed: Cannot find resource for the request webparts. clientRequestId: 093cb580-33ec-45b8-a305-f0ccd16e5405 serviceRequestId: 00616aa1-b034-4000-219c-1d33e02fd756 ACTION 3b (option 2): Update CanvasContent1 (via Send an HTTP request to Sharepoint (POST)) -- RESULT: No change to web part and page not modified.MGDC for SharePoint FAQ: How to use Excel for analytics
MGDC for SharePoint – Dataset types and features In this post, we’ll discuss how to use Microsoft Excel to consume the data from Microsoft Graph Data Connect (MGDC) for SharePoint. If you’re new to MGDC, get an overview at https://aka.ms/SharePointData. 1. Introduction In most examples on how to analyze the data from MGDC for SharePoint, we use Azure Synapse in combination with Power BI Desktop, which is a very capable tool that can turn your data into coherent, visually immersive, and interactive insights. But keep in mind that, when pulling datasets from MGDC with Azure Synapse, the data becomes available in an Azure storage account as a set of JSON files. From there, you can use many different tools beyond Power BI. In this article, we will focus on how to read and analyze that data using Microsoft Excel. 2. Get the data into Azure storage The first step in the process is to get your data from MGDC. I have a blog post that describes that process at Step-by-step: (Synapse) Gather a detailed dataset on SharePoint Sites using MGDC. Section 1 if that blog shows how to setup the Microsoft Graph Data Connect and section 2 describes how to run an Azure Synapse pipeline to pull the data. If you complete these first two sections, you will end up with your SharePoint Sites data in Azure. You can skip section 3 of that blog, that describes how to get the data into a Power BI dashboard. You will replace that section with the information in this article, which takes the data to Microsoft Excel instead. 3. Bring the data from Azure storage to Excel Next, you need to bring the data in the JSON files from the Azure storage account to your Excel spreadsheet. Fortunately, Excel has the perfect set of tools to bring in that data. You should start with a blank spreadsheet. Select the “Data” tab in the ribbon and use the option to “Get Data”. Then select the option “from Azure” and choose “From Azure Data Lake Storage Gen2”. This will make sure that you’re getting the data in your ADLS Gen2 storage account. > Get Data --> From Azure --> From Azure Data Lake Storage Gen2 Next, you will need to provide the URL to the ADLS Gen2 storage. Provide the full path, with the container and folder in the format: https://account.dfs.core.windows.net/container/folder. The account name is in step 1d of the at step-by-step guide mentioned before. The container and folder names are in step 1f of the guide. You can also find the URL in the Azure Portal, under the Settings/Endpoints section of the storage account. Once you provide the URL and click OK, you will need to authenticate. Select the option to use the storage account key and type in the key you saved in step 1d of the atstep-by-step guide. You can find the key in the Azure Portal, under the “Security + Networking” / “Access Keys” section of the storage account. Once you have typed the account key, click “Connect”. At this point, you want to click on the “Transform Data” button to filter for the specific files you want. This will open the “Power Query Editor” window, where you can apply specific steps to filter the data coming in. The easiest way to filter out the metadata files is to scroll right until you find the “Folder Path” column and filter that column for paths that do not contain the word “metadata”. > down arrow --> Text filters --> Does not contain... After that, you can scroll left to the “Content” column and click on the button to “Combine files”. After that, the query will pull in the content of the files and expand all the columns from the JSON. > Content --> Combine files Finally, you can click on the “Close & Load” button to bring the data into a sheet. & Load With that, you can play with the data in Excel. 4. Create PivotTables Once the data is imported into your Excel spreadsheet, you will be able to create data visualizations from it. The most interesting way to do this is to use Excel PivotTables. For instance, here’s a pivot table with storage (Storage Used) by site type (RootWeb.WebTemplate) on the different dates you pulled data (SnapShotDate). See the sample PivotTable below after some adjustments and formatting. 5. Tips Here are a few additional comments. Distinct types of authentication: As you might have noticed, there are multiple ways to authenticate to get access to the Azure storage account. In addition to using a key to the entire storage account as shown here, you could use Azure to grant specific permissions to a user and log in as that user. This will help restrict access to specific folders and grant limited permissions (like read-only). Create custom columns: To help with your data analysis, you might want to add a few custom or calculated columns. You can in many ways, including transformations in Power Query, formulas in the Excel sheet or in the pivot table itself. You can read more about it at How to create customcolumnsin Power BI (this says Power BI but applies to Excel as well). More than one million rows: If you’re using this to visualize data from the SharePoint Sites dataset, you are likely to have fewer than one million rows, which is the Microsoft Excel limit. If you’re one of the few tenants that will have more than one million sites or if you’re analyzing a larger dataset like Permissions or Files, you can only pull the first one million rows into a sheet. To overcome this, you can load the data into a model and use that to drive your pivot tables. You can read more about it at Loading CSV/text files with more than a million rows intoExcel (this says text files but applies to JSON as well). 6, Conclusion I hope this post helped you understand how to use Microsoft Excel to pull JSON data from an Azure storage account used by MGDC for SharePoint. For more information, visit https://aka.ms/SharePointData.
