Lists
14 TopicsIntroducing "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.Set values for Managed Metadata (aka Taxonomy) columns in PowerApps and Flow! (First Release)
Hi everyone, As of today, you will be able to set the values of your managed metadata columns (sometimes also called taxonomy columns) in PowerApps (for both multi-value and single value) and in Flow (single value for now, but multi-value coming soon...) Here's a sample multi-value taxonomy column that was tied to a termset for languages. Weare not fully all the way there: the default values are not yetshowing up if they are set, andwe don't yet let you disambiguate between different paths while you are typing, but we think this is a great net new add for our customers who love and use the managed metadata columns. Please give it a try, and let us know your feedback. In your First Release tenant, you can create a new app, or custom forms, or go to an existingapp and refresh the schema to get the new columns. We expect to start rolling out to Production in the last week of November if we don't hit any blocking issues.Configuring approvals for lists and libraries
We are adding a new menu item under the Flow menu that will let customers configurethe type of approvals they would like to use in their lists and libraries (Request sign-off, or Content approval), or turn approvals off altogether. We have added this feature based on the feedback that we received for the rollout of the Request sign-off feature, where some customers preferred to use the Content approval feature which changes thevisibility of the current item based on the approval status, and there are fixed approvers for a given list or library, or other customers had other custom flows configured for their list or library, and did not want to haveRequest sign-off to become a source of confusion for their users. To make changes, as site owner, you will be able click on Flow->Configure flows in the command bar of your list or library: Then in the panel that appears, pick the approval method that you'd like, or turn approvals off altogether: The new configuration panel will become available for our Targeted Release customers in early September, and then go to the rest of our customers. We expect to complete the rollout by September 19. Please continue to keep the feedback for our features coming, and tell us how we can make SharePoint work better for you.Multiple sharepoint lists sharing same columns
Hi, I'm new to Sharepoint and I have an issue where I'm not able to find a way to share list data. What I tried to do is have 3 sets of lists each with their own columns and columns that they share. Each list has a custom level of priviledges: LIST.A: Column1 Column2 Column3 Column4 Access by users set.A LIST.B: Column1 Column4 Column5 Access by users set.B LIST.C: Column1 Column2 Column4 Column6 Access by users set.C Is there a way to do this? Thanks, NikolaSet choice, people, lookup and content type fields in Flow!
Hey everyone, We just finished rolling out the feature to Microsoft Flow that lets you set choice, people and lookup fields, as well as content type for the item. Please read about the details, and a couple of known issues that we are working on, as well as some of the upcoming features in this post on the Flow Blog, and let us know what you think: https://flow.microsoft.com/en-us/blog/setting-sharepoint-s-person-choice-and-lookup-fieldsFlow to automate email to user in a list
I'm trying to do something which I really feel shouldn't be that difficult. I have an MS lists page with two columns. One contains users in my organisation (it's not just their name in basic text - it is checked against their active directory record). The other contains a date which they will be on call. What I want to do is use flows to automate an email to be sent to the user when the date assigned to them is reached. Basically, notify them they are on call. Any help much appreciated! ThanksSolvedFlow Launch Panel now available for everyone!
As we had indicated in a message center post, and in our earlier blog post about how SharePoint can help you transform your business processes, we have been gradually rolling out the Flow Launch Panel feature, and as of Monday, the roll out has been completed. Flow Launch Panel allows you to pass in parameters to flows when startingthem, and also lets you run flows as a user different from the creator of the Flow thanks to the "Manage run-only users" section in the Flow management screen. See this blog post from the Flow team for details.Updates from one list applied to another list (multiple fields)
Hi I have two lists - the first is the master list, the second has 4-5 columns of the same data. Is there a way to make updates to the first list and have them repeat on the second list? I have a matching value for each item across each list. But the updates could be to all the fields and I don't just have one set value - I have around 100. For example - Master List Name Surname Room Pool Notes John Smith A3 Barclay 4 Words, words, words The data above is already on List 2, but if the room, pool or notes were updated in the Master List, is there a way to "copy" that to List 2? Thanks for any help!Pulling URLs from infinite scroll SharePoint page
I'm trying to put together a list of articles and their URL from a corporate intranet that is built on SharePoint. These articles are displayed on pages titled with the name of each department followed by news -- so "Department A News", "Department B News", etc. The pages where they're shown are infinite scroll. Only a few items are shown initially and then more articles are shown as you scroll down until eventually all articles are shown. The URL for the page with the infinite scroll all have the following format: https://<domain>.sharepoint.com/sites/<site>/_layouts/15/news.aspx?newsSource=3&instanceId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&webPartId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&serverRelativeUrl=%2Fsites%2F<site>&pagesListId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Looking through the URL, it appears to have the following IDs built in: instanceId webPartId serverRelativeUrl pagesListId I hoped the articles were just a list and that I could use pagesListId to grab them, but I got a "Enter a valid integer." error when I tried using "Get item" with the pagesListId. I tried using "Send an HTTP request to SharePoint" using the full URL in the uri like: _api/search/query?querytext='path: https://<domain>.sharepoint.com/sites/<site>/_layouts/15/news.aspx?newsSource=3&instanceId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&webPartId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&serverRelativeUrl=%2Fsites%2F<site>&pagesListId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' That gave me an error that read "The query string "querytext" is missing or invalid." Any idea how to pull from these kinds of SharePoint sites?