Microsoft Flow
1467 TopicsSharePoint site news notifications in Microsoft Teams channel
Dear Microsoft community, we are desperately trying to solve the issue since Microsoft stopped supporting the SharePoint News connector. We were trying to use the workaround that MS proposed but it's just not working. Can someone help me to setup a workflow that is posting the recent news in our news channel so that colleagues can start conversations about it? Thanks. Best PhilFlow save failed with code 'InvalidTemplate' and message 'The template validation failed:
What I want to do is the trigger should initiate When an item is created, it should automatically send out an email to the approver with options to approve or decline. Scenario A (App Approval): If the manager approves/declines from the app, the status will be updated in the SharePoint list. Power Automate should detect this update and send the respective confirmation email to the requester without waiting for action from the email. Scenario B (Email Approval): If the manager approves/declines from the email options, Power Automate should update the SharePoint item’s status and send the respective confirmation email. Workflow Steps I followed: Trigger: When an item is created in the SharePoint list, initiate the flow. Send Email with Options: Send an approval email to the approver with "Approve" and "Decline" options. Parallel Branch Execution: Branch 1 (Email Approval): Wait for a response from the email. If approved/declined, update the SharePoint item’s status accordingly. Send a confirmation email to the requester. Branch 2 (App Approval): Trigger: When an item is modified in SharePoint. Detect if the status has changed (approved/declined) from the app. Send a confirmation email to the requester. When I applied this I am getting this error [ Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Send_an_email_(V2)_2' at line '1 and column '7007' cannot reference action 'Update_item'. Action 'Update_item' must either be in 'runAfter' path or within a scope action on the 'runAfter' path of action 'Send_an_email_(V2)_2', or be a Trigger.'.'.]Capture Approval Comments from SharePoint Approval
I am using a SharePoint list for items that are being independently worked. Once the work item is complete an approval is sent for review. The approval request is done on the list with the built-in function not using power automate. How can I capture the approval decision, date and comments using the basic built-in function using power automate? I don't need to send an email. I cannot have the flow triggered on an item once it is created as the created item will be worked at a later time. I just want to capture data related to the approval decision.File not found when doing Get File content in Power Automate
Good Day, Been researching this endlessly but no solution. I am doing a flow but when doing a Get file content in Apply to each, I get the error below. I am using Identifier from the Get file (properties) in my Get file content action. What am I missing ? Can someone please help. Many thanks in advance. "File not found clientRequestId: 83ed0d3e-d278-48f3-b3ff-a6662a4d68d7 serviceRequestId: 83ed0d3e-d278-48f3-b3ff-a6662a4d68d7Vacation/Leave tracker
Hi All, I am creating a Leave tracker, Basically what I have done so far is. -Create a form for leave submission. -Link it to approvals so it basically retrieved manager details and sends approval request via Outlook/Teams. -Create a SPO list item to update and save requests. -Once approval is received the SPO list item is updated to have a status approved. -This triggers email notification to the requestor. -A calendar event is updated in a shared calendar. What I would like to add/Improve is: -Check before sending approval request to see if balance has enough days for the leave requested. -Tracking for vacation balance. i.e. deduct approved days from balance. -For Calendar events to cover all days of the leave in case it is more than one days. Current Create event, Creates only one day. I tried multiple methods that did not work, Any Idea how to achieve this??SharePoint, OneNote, and Flow...issues with copying a OneNote Notebook using Flow
We have a OneNote notebook in a Document Library that contains many sections. We use this notebook each time we create a new folder in a document library. In the past we have manually created it. End goal: To be able to open the Notebook in SharePoint Online. Every way I try to write the Flow I am failing. 1) If I create the OneNote as a template (onepkg), I can successfully copy the file from the template site to the new folder. But when I open it, it opens in Native Client, requires me to choose a location to save it to, and if I choose back to SharePoint it creates a folder with individual pages for each section. Fail. 2) If I just try to copy the OneNote (not as a template), Flow doesn't recognize it as a file; it sees it as a folder. Anyone have any suggestions on the best way to solve this?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.Stop trigger when receiving calendar invite for 'When a new email arrives in a shared mailbox'
I have created a flow which starts with the trigger 'When a new email arrives in a shared mailbox'. I would like to prevent this trigger starting the flow if I receive a calendar invite from any sender. I have tried and tested a couple options with co-pilot which did not work: Adding this function to the settings of the trigger '@not(equals(triggerOutputs()?['body/MessageClass'], 'IPM.Schedule.Meeting.Request'))' -> NO emails were triggering the flow any longer Using a condition with the following function: '@contains(triggerOutputs()?['body/Categories'], 'Meeting')' I am ideally going to avoid creating more steps in my flow, and instead working within the settings of the trigger. Please help! Below is the flow if at all helpful...Disagreement with CoPilot on Flow Logic
CoPilot and I disagree about a filter in a flow. Currently, my flow selects items with the following filter: DueDate le 'addDays(utcNow(), 2)' or DueDate eq 'addDays(utcNow(), 2)' It seems to me that the "eq" piece is duplicative, because the "le" piece would include it. In other words, "less than or equal to two days from now" already includes "equal to two days from now." CoPilot, however, states that the "eq" piece is necessary. Its reasoning is not convincing. What light can a human Flow expert shed on this?Solved