Announcing SharePoint page approvals
We are happy to announce that we will be releasing SharePoint page approvals to Targeted Release. We expect to start the rollout of this feature to all Targeted Release tenants by end of July 2018. Rollout status Current rollout status: July 31st, 2018 - Deployed to 10% of Targeted Release tenants August 3rd, 2018 - Deployed to 50% of Targeted Release tenants August 6th, 2018 - Deployed to 100% of Targeted Release tenants January 8th, 2019 - Deployed to all tenants in SharePoint Online Documentation: 1. Configure page approval 2. Page approval flow Known issues If the page is checked-out by another user and you (the author in this case) submit the page for approval, the page will not notify and proceed with the approval. The flow will run and send an email indicating to the author indicating an error occurred in publishing the page. If you have only major versions enabled for the Site Pages library, submit for approval will result in int he following error: Could not complete that action: The type of data at position 0 is different than the one expected. There an issue with the Flow service for the UK region. Any existing UK tenants created before March 2018 will work while it affects only new tenants created after March 2018. We expect to have this resolved by end of September if everything goes according to the plan. See this thread for more information. Good news is that these will be fixed soon are fixed! If you have any feedback, please make sure you discuss here! Configure page approval Site owners can configure page approval to add to the standard publishing process for a site. After adding page approval flow, new and updated pages will be not be published directly. Instead, only the completion of the approval flow will make changes visible to all readers of the site. A site owner can configure page approval flow from the Flow menu of a pages library. Submit page for approval Once the page approval is configured, authors will be able to submit page for approval. The publish button will be replaced by a submit for approval button. The page will be published once the page is approved. Rejecting a page will put that page back to draft status. Approve page Approvers will get an email regarding the page approval request. They can either approve the page directly in the email (in email clients that support actionable messages) or open the page from the email to review and approve the page in SharePoint. Customizing the page approval flow Since page approvals use Microsoft Flow behind the scenes, the page approval flow is available to site owners to modify and add any custom business process items in the flow. After creating the flow, the site owner can click on Flows -> See your flows in the pages library to find the page approval flow. For example, The default approval type is set to ‘anyone can approve’. Site owners can modify the flow and change the approval type to ‘everyone must approve’ if that is the requirement.
Conditional formatting - only show button if attachments are present
Hi, I am trying to only show a button in a column, if there is an attachment present in the same row on the attachment column. Here is what I have so far: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Send Offer", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"f191e7c8-1a36-4553-9d64-607764fc6f83\"}" }, "style": { "background-color": "blue", "color": "white", "visibility": "=if(([$Attachments] == false),'visible','hidden')" } } I have tried changing " [$Attachments] == false) " to equals true, 1 and 0, and there's still no use. If I look into the address bar I can see " FilterField1=Attachments&FilterValue1=1 ", but even when I enter "1" as the value the button still does not display when attachments are present. Any help is highly appreciated. Thank you!
How do I get PowerAutomate Flow to send email to the person who entered the item in SharePoint
I have been able to get the PowerAutomate Flow to send me an email when a new item is entered in a SharePoint list. I need to get the PowerAutomate Flow to send an email to the person who entered the new item. How do we get the Flow to send the email?
Update SharePoint List Column matching on Form Answer Value
Hi All, I am working on a flow that takes form responses and updates a SharePoint List. There are three separate conditions that I am attempting to solve for. Condition 1: If Response to Question 1 = A then Create new Item in List (this one I have working) Condition 2: If Response to Question 1 = B then update the item in the List where Answer to Question 2 = Value of Column in List (not working) Condition 3: If Response to Question 1 = C then update the item in the List where Answer to Question 2 = Value of Column in List (not working) Here's what my flow looks like currently: Condition that is working: Conditions that are not: I am using a Get Items to fetch the current values from the List. Then I am using another condition to match on the value, then update the specific item in the List: I think I am pretty close but the matching condition doesn't seem to be working for me. Appreciate any help! falcon1982Auto-populate a field in a SharePoint list based on values selected in two others
Hi there, I have a SharePoint list with 3 Columns: Urgency, Importance and Priority. I want to auto-populate the Priority column based on the values selected in Urgency and Importance, either using some sort of calculated field or via PowerAutomate. All three are currently set up as Choice columns. Is anyone able to explain (in VERY basic steps) how to achieve this please? I have tried various things both using Power Automate (but am a real novice with this) and in SharePoint but to no success. I have specified below the text that should be displayed in Priority depending on what has been selected in Urgency and Importance: IF Urgency is: And Importance is: Then Priority should be: High Low Medium Medium Low Low Low Low Low High Medium High Medium Medium Medium Low Medium Low High High High Medium High High Low High Medium I'd be very grateful for any advice. Many thanks, DamienInconsistent "document locked" times
I'm working on a Flow that uses a Do until loop to keep trying to update SharePoint properties, if it finds the file is locked. The Do until loop is set to run for 1 day with 290 tries. When the file is closed, the Flow updates properties and completes the run. Testing has been showing inconsistent run times before the Flow completes. My latest test ran for 6 hours 12 minutes. The file in question was open in another tab on my computer. At 6:12, Flow determined the file was closed, updated the properties, and completed the run. I did not close the file. Does Office 365 close files that have been open but inactive a long time? I am using Edge browser which "sleeps" an inactive tab. Would this sleep condition make Office 365/SharePoint think that the file had been closed? Thank you, Anne
Flow or Alert on View/Open of file in SharePoint Online
Situation: have a site that is for top management. They want a completely closed document storage area. Problem is system admin IT will always have the ability to access the documents if they desire. Is there a way to set a flow or an alert that can notify our top management group when someone views or opens a file in their library? I know we can alert/flow on change and download, but don't see that ability on just opening.Column Formatting - now with Flow button support
One scenario that we demoed at Ignite last year was the ability to create Flow buttons using the SharePoint column formatter. The initial public release of the column formatter, however, did not include this functionality. We're proud to announce that all SharePoint Online users can now create their own Flow buttons inside column formats. This is useful when you want to put a business-critical Flow a single click or tap away for users when they're viewing a list or library. To learn how to accomplish this, check the Create a button to launch a Flow sample on our documentation page. Let us know any feedback or concerns you have about this functionality, or about column formatting in general.
