Forum Widgets
Latest Discussions
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.
Copying lookup column value from one SharePoint list to another
Hello. I am having some difficulty when I try to copy the values in a SharePoint lookup column from one list to another. Both lists have the same lookup column called "Sponsor" and they are both referencing the same list called "Sponsor Values". The Sponsor column is also a multi-selection drop-down in both lists, so I need to copy over all values. The Sponsor Values list that is being referenced only has columns ID and Sponsor Name. I have a Power Automate flow setup that copies information between list A and list B, but the Sponsor field does not copy over. Can anyone help with how I need to go about doing this in Power Automate?
Flow 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.'.'.]Vacation/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??
Trying to change active user based on dates
Hello, I have a SharePoint list with several fields: Person A Person B Active Person Start Date End Date I want to set up a flow so that when a list item is modified, a flow checks if TODAY is between Start Date and End Date. If true, [Active Person] = Person B Else, Active Person = Person A Any idea how I can do this?lagacy formula bar
I can't download attachment file in powerapps.Finally found the reson is that the value of the attachment is not changed to AbsoluteUri,but I can't find "lagacy formula bar"in the setting of powerapps. I don't know whether is version dateup,how to solve this issue? Anyone know the method?
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...Power Automate Assign Task Notification - Change Assigned by Name
I have a Power Automate Flow that reads answers from a Microsoft Form and assigns tasks to team members. They then receive an email that I assigned them a task. I don't want it to say my name but instead, something like Business Task Manager assigned you to a task. Is there a way to change this so it looks like that task assignments are not from me?
