Automate your tasks with the Automate tab—now in Excel for Windows and Mac
The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.
Excel Does Not Sync Until Opened
I created a form linked to an Excel spreadsheet in SharePoint as well as a Power Automate approval flow triggered on submission. In addition to sending out confirmation/approval emails, the flow also updates the associated Excel spreadsheet with the approval/denial. The flow was working fine until last week but since then has failed 2 consecutive times. The failures appear to be related to the flow unable to find the automatically generated submission ID in the Excel spreadsheet. When I open the linked spreadsheet, the submission is not immediately present at first but the file does sync at that point and the entry appears. When re-triggered after the sync, the flow completes successfully. Not sure if it is related, but MS form/linked spreadsheets have been updated by Microsoft recently and I was prompted to go through an update process for synced Excel spreadsheets. I completed the update with this specific form last week after the flow failed for the first time. TLDR - my form only syncs with the spreadsheet once opened. Any ideas how to get MS Forms to update the spreadsheet in real-time as opposed to when it is opened?
Conditional Form Questions - For multiple answers in a "choice" question type
Hi I've been trying to find a way to have nested conditional questions in a form so only appropriate questions are being asked based on previous responses. (It doesn't look like branching is the answer to this situation) I have the following question in a form; What I'm trying to achieve here is when a responder selects option 1, a new section of questions appears for them to fill out. If more than 1 option is selected, then a set of questions should appear for each response (but should not be shown if the option is not selected). For example, in the image below, this section should only show up if option 1 in the above question is true/selected, then questions 6&7 should only appear if their respective response in question 5 is selected. The output from this form will be piped into a power automate flow and therefore we want finer granularity in the questions. If this is currently doable, can someone please enlighten me? If this isn't currently doable, can someone please tell me a good way of submitting this as a feature request as I think it would make Forms a much more powerful tool?Microsoft Teams: Capture Chat Messages and Replies
You may have the need to archive chat messages or capture chat sessions for further processing. Activities like summarizing the conversation, extract action items, or suggesting meeting times can be done by analyzing the chat conversation. This starts with extracting the conversation using the Microsoft Graph APIs. This post describes a solution for extracting both the initial message and follow-on replies.Integrating ServiceNow with Microsoft Teams Approvals via Power Automate
As more and more organizations move towards remote work, communication and collaboration tools have become essential for seamless and efficient workflows. Microsoft Teams is one such tool that allows teams to communicate, collaborate, and stay productive from anywhere. Teams Approvals is a feature within Microsoft Teams that enables users to create, manage, and track approvals directly within Teams. On the other hand, ServiceNow is a powerful platform for managing workflows, incidents, and service requests. Integrating Teams Approvals with ServiceNow can streamline approval processes and improve overall efficiency.
New Form Submissions not Pulling to Power Automate
I have form submissions set up to trigger a Power Automate flow and the flow has suddenly stopped working after years of use. Here are a couple things I have noticed in my troubleshooting: It seems that somehow not all new form submissions are being registered by MS Forms. When I look at the number of responses on the Form Responses tab, there are several missing compared to the number when I open the responses in Excel (1146 compared to 1158+). I have entered a subsequent form ID (1160) into my flow and the flow was successful. This was the original flow: Any insight that can be offered is much appreciated. Thanks!
Reference Microsoft Flow triggers and actions
Hi all, I had to make this this morning so I thought I would share. I couldn't find a definitive reference for all of the controls that there available in Microsoft Flow, so I took a bunch of screenshots, for the app connections that I regularly use. These are Planner, Sharepoint, Teams, Outlook, Forms, Office 365 Users, Excel Online (OneDrive) and OneDrive. If anyone has a better reference do let me know, but otherwise these attachments are free to use.
Extend M365 Archive Quota capacity
In my organization, we are currently on the O365 E5 License with default 100GB mailbox size per user and 1.5TB archive quota. However, due to organizational policy and regulatory requirements, we are expected to keep all the data from inception. Hence, the requirement for a solution to extend our archive size from 1.5TB. From the official Microsoft documentation, https://learn.microsoft.com/en-us/office365/servicedescriptions/exchange-online-archiving-service-description/exchange-online-archiving-service-description#archive-storage-quota the maximum expansion of the archive mailbox is 1.5TB. Is it possible to extend the archive storage to an Azure blob? Like an automated script that moves the data from the Archive mailbox for each user to the Azure blob or any other storage service that does not have storage size limitation. I am open to suggestions. ThanksAccessing Quiz Score in Power Automate (Forms API, Sync)
We've been utilizing the Forms API to download the Excel file and retrieve user scores in Power Automate, since the standard response (Get Response Details) connection doesn't provide the user's score. Lately, we've faced issues with this API; it used to operate with Power Automate but hasn't been working for the past week. Connection: Send an HTTP request to SharePoint { "status": 401, "message": "{"error":{"code":"701","message":"Required user login."}", "source": "https://forms.office.com/formapi/DownloadExcelFile.ashx?formid=XXXXXXX", "errors": [] } We attempted to use the Forms synchronized Excel file from SharePoint, but it only updates with the actual form data when accessed through a browser.
