Forum Widgets
Latest Discussions
SharePoint/Power Automate Issue
I am the IT Manager for a small business. I was told that SharePoint can be used as a ticketing system, if set up properly. I have actually gotten it to work, but here is the issue. We have 2 email domains, one is MSI and the other is @asc*. When I send an email to the latter, it works but if I send it from an msi email, it does not work at all. Is there a setting or something someone can point me to or do I somehow have to make 2 different flows in order to get this to work. Any help is appreciated Don Murray
Email to Assignee with SharePoint items created in past week and assigned to the email recipient
Going into this it seemed straightforward, but I've been banging my head against the Power Automate wall. We have a SharePoint list with a number of columns, one of which is basically Assigned to (it's titled Ticket created by). The ask from our user group is that the Ticket created by value/personnel is sent a weekly email and the body of the email includes a table with 4 column values of any new SharePoint items created in the past 7 days that have been assigned to them. There are about 30 individuals who could be in the Ticket created by column and not all of those individuals will have new items each week. So, if there are no new items for the person, there will not be an email. Originally, the flow was triggered upon creation and the Ticket created by personnel would receive an email with a bit of info from their SharePoint list item formatted in a table. This worked fine and still does. However, the new ask is that we move away from an automated flow and use a scheduled flow that runs weekly and displays x, y, and z values from the new items created in the past week and assigned to the recipient of the email. This is where I'm stumped. How do I include in the body of the email values of new SharePoint items (1) created in the past 7 days and (2) assigned to the To: recipient (Ticket created by value) of the email?
Flow keeps running by from Update Item
This flow was done as a Child Flow to compare Excel entries and List items, and update the List item with the updated Excel entry if discrepancies are found. This flow occurs quite fast without the "Type of Grant" field. However, when I include an array of multiple-choice selections under the "Type of Grant" field, the flow takes forever to run. This is my first time using Power Automate, so any help is much appreciated.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
Power Automate archive SharePoint list column changed
I have a power automate flow to archive List A to an identical List B monthly. The flow go through steps of Get items - Apply to each (Create item - Delete item) Some Columns changed their names after Get items step, therefore I can't map columns in the Create item step. While most columns passed through properly, here are problem columns: In the list A I have these columns: StaffName (people) Manager (people) State (Choice) When I try to map columns at the Create item step, they turned into following Columns: StaffName Claims Manager Claims State Value In the troubleshooting step, I deleted column of "StaffName" and "State" from the destination List B. I recreated two new columns "Staff" and "State". When I add the create item step, the previously "StaffName Claims" changed to "Staff Claims". The problem is "Staff Claims" can't be mapped to any Get items outputs on the right (in screenshots). Can someone help. Thanks in advance.Sent back to creator for approval
Hello, I am trying to create a secondary approval. First approval - is is the user sending it to be approved by managers for the spend to go ahead the 2nd approval is sent back by the finance department to the creator for approval that the goods/services have been delivered/carried out. If I build a seperate list based on the responses in the first list - the created by comes through as me as I am running the flow - but if put the 2nd flow on the 1st list it doesn't seem to run correctly. Any tips would be appreciated
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.'.'.]
