Introducing "Request sign-off" - an approval flow that requires no set up
We are happy to announce a new feature in SharePoint called "Request sign-off". The goal is to provide you an easy way to send an item for approval to someone else. This feature enables an open approval process that allows you to easily record whether or not a document or list item was approved or not. There is no setup required. Request sign-off makes use of SharePoint's integration with Microsoft Flow. You can use it by selecting a file or list item (but not a folder), and then pulling down the Flow menu in the modern library or list UI, and selecting "Request sign-off". This flow will appear alongside any other custom flow that you or others may have added to the library. Once it is invoked, Request sign-off will create a new text column in your library called "Sign-off status". This column will record the state of your request. It works just like any other text column, you can sort, filter or group by it to organize your library. On invocation, this will tell you that it will send an approval request on your behalf, and ask your consent. Once this is provided, you can pick one or more approvers, and write a message to them for your approval request. If you add more than one approver, any one of them can approve your request: The person you sent the approval to will receive an approval request. This will be an actionable message on clients that support it (meaning you can approve it directly from within Outlook). The approver can also provide some comments along with their decision. There will also be a link included that lets the approver view the item in question: The sign-off status column is then updated with the decision, and the person who sent the approval request will receive an email with the comments: By saving you the trouble of setting up a flow and creating a new column to track status, we hope that this feature will make it easy to add a lightweight approval process to your libraries and lists. We expect this feature to start rolling out to our customers in targeted release (previously called first release) after April 9. Barring any issues we will continue to roll it out to the rest of our customers in two phases late April and early May.
Update SharePoint list with Excel Items
I've been working on this for some time, it seems like it should be easy but has proven to stump me. I have a SharePoint list I use to track workplace safety incidents. I have an excel sheet (set up as a table) that is downloaded from WCB's website. I want to take certain cells from the excel sheet (4 columns) and update that information on the SharePoint list using a commonality between the two. In this case, the commonality would be the WCB claim number. I would like the flow to be manually triggered. Can anyone offer some help?
Send a Mail When a Field in a SharePoint List has a value of Yes
Hello We have a SharePoint List that people can add to / edit etc... We want to have a Flow that monitors this list and when a field changes to Yes we want a email sent to a person that basically says "ID 123" has changed Any idea how this can be done?
You are not authorized to send mail on behalf of the specified sending
Hi, I have sharepoint list when user submit data into sharepoint list email send through MS Flow. when i use generic email id in sender option getting following error if i remove that account and allow submit user account than its work fine. pls guide what is an issue and how to fix it. what permission should i give to email account.Flow to count items in a SharePoint List
I am trying to create a flow that counts the number of items within a SharePoint List, based on a value within a column. In my list I have a 'Assigned To' column which will always be 1 of 3 names. I would like to create a flow that sends out an email (using the recurrence action) to each of the three people saying how many items they have assigned to them. I have another column, called 'Progress' that has a value called 'Resolved'. I wouldn't want any of the items that have been 'Resolved' to be include in the count. Is this something that Flow can do, and if so, how?
Updating a Hyperlink field (both url and description) using Flow?
I tried using the update item action to set a Hyperlink type column in my custom list. The Flow field for this column only accepts the url so there seems to be no way to add the description part. Anyone got this working? In SharePoint: In Flow:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed:
I am currently trying to modify a Power Automate approval flow in order to allow several approvals and save the name/email of each approver in the column of a Document Library, however I am receiving the following error message in the final part Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Update_file_properties' at line '1 and column '5237' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Update_file_properties' to be referenced by 'repeatItems' or 'items' functions.'.'.
