User Profile
RobElliott
Silver Contributor
Joined Aug 10, 2018
User Widgets
Recent Discussions
Re: Change Promoted State value
influentialeliot you don't even need to use the api to change the promoted state from 2 to 0. Just format the Promoted State column with the following JSON: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "flex-wrap": "wrap", "display": "flex", "flex-direction": "row" }, "children": [ { "elmType": "div", "txtContent": "=if(@currentField == 0 ,'0 : Page' , if(@currentField == 1, '1 : News (Unpublished)' , if(@currentField == 2 , '2 : News','') ) )", "style": { "box-sizing": "border-box", "padding": "4px 8px 5px 8px", "display": "flex", "border-radius": "16px", "height": "27px", "align-items": "center", "white-space": "nowrap", "overflow": "hidden", "margin": "4px 4px 4px 4px", "border": "1px solid" }, "attributes": { "class": "=if(@currentField == 0 ,'ms-fontColor-themePrimary ms-borderColor-themePrimary ms-bgColor-white' , if(@currentField == 1, 'ms-fontColor-themePrimary ms-borderColor-themePrimary ms-bgColor-themeLighter' , if(@currentField == 2 , 'ms-fontColor-white ms-borderColor-themePrimary ms-bgColor-themePrimary','') ) )" } }, { "elmType": "div", "style": { "font-size": "18px", "cursor": "pointer", "padding": "10px", "border-radius": "50%", "display": "=if(@currentField == 0 , 'none' ,'')" }, "attributes": { "iconName": "MoreVertical", "class": "ms-fontColor-themePrimary ms-bgColor-themeLighter--hover" }, "customCardProps": { "openOnEvent": "click", "directionalHint": "rightCenter", "isBeakVisible": true, "formatter": { "elmType": "div", "txtContent": "Demote (Change to 0:Page)", "style": { "padding": "10px 20px 10px 20px", "cursor": "pointer" }, "attributes": { "class": "ms-bgColor-themeLighter--hover" }, "customRowAction": { "action": "setValue", "actionInput": { "PromotedState": "0" } } } } } ] } Rob Los Gallardos Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Re: Parsing information into Microsoft Forms
Lorraine_Frost there is no way to pre-populate any information in a form. Requests for this which you can vote for are on the official https://feedbackportal.microsoft.com/feedback/search/0ab9de26-ff1b-ec11-b6e7-0022481f8472?q=pre-populate. Rob Los Gallardos Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Re: Grouped by aggregate value rules in Sharepoint list
sflows Power Automate can't access the grouped by aggregate values but you can still use a flow to send you an email when the stock level reaches whatever level you want to set. So in this example there are 3 Smart Irrigation Systems in stock. We're going to send the email when the stock level goes down to 2. 1. The trigger in the flow is the SharePoint "when an item is deleted". Next initialize a float variable which will hold the count of the items. 2. Add a compose action and select the column with the name of the item, in my case it's the Title column. Next add a SharePoint "get items" action and add a filter query of Title eq '' and inside the single apostrophes select the outputs of the previous compose action. This will limit the items brought back to just the same one as the item you deleted which will improve performance if the list is large. If your get items is likely to bring back more than 100 items you need to go to the items settings, turn on the paging toggle and set the threshold to a higher number. 3. Next add an apply to each and select value from the get items section of the dynamic content box. Add an increment variable action, select your variable and type 1 in the Value field. 4. Outside the apply to each add a condition of varCount is less than or equal to 2. Leave the red if no channel empty. In the green if yes channel add another compose action and select varCount for the inputs field. 5. Finally, still inside the green if yes channel, add the send an email action. In the subject field I've just added the outputs of the original compose with the name of the item. Add in any text and select the outputs of previous compose to display the stock level in the email. And this is the result. Hope that helps. Rob Los Gallardos Microsoft Power Automate Community Super UserRe: Automatically promote a published page with Post as a news on this site
Selina233 you can already schedule individual news posts and normal pages. First, enable scheduling which is in the menu along the top of the Site Pages library. Then when you are creating your news post, click on Page details, turn the scheduling toggle on and select the date and time that the news article should be published. The button at the top changes from Post News to Schedule. Rob Los Gallardos Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Re: Limiting Maximum number of Choices in List
GeorgieBu it can also be sone in Microsoft Forms if you send the customer a survey. Forms has the ability to limit the number of choice options selected. Rob Los Gallardos Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Re: How to change date format in sharepoint
ikarafi go to site contents then site settings. Go to the site administration section of the site settings page and select regional settings and set the time zone and locale. The settings I use below put dates into dd/mm/yyyy format: Rob Los Gallardos Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Re: Printing Responses in MS Forms with uploaded images
Taahir_Maula click the 3 dots in the top right of the view results screen just below the time to complete time. Then select Print Response and select Save as PDF. Rob Los Gallardos Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Re: I think I have a corrupted ID field
ConnM try clearing your browser cache. I often find that a list needs to be refreshed (ctrl+r) a few times before items created in an app appear. They do eventually pop up on their own but refreshing can speed it up. The format of the number is Microsoft's initial internal ID which after a shot while - another refresh or 2 - resolves to the proper ID. Rob Los Gallardos Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)Re: Automatically fill a single text column in Lists by the value of a Person Field column
Femke11 the quickest & easiest way of doing this is to build another flow which is triggered from a JSON-formatted button in the list. So in the example below Pick is a person column, Get email is a single line of text column and so is PickEmail. In the flow the trigger is the SharePoint "for a selected item". Next add a get item action to get the details of the item selected. Next, add an Office 365 users get user profile (v2) and select one of the Pick columns in the dynamic content box. I've selected Pick Email but you could equally select Pick DisplayName or one of the others. Finally, add a SharePoint "update item" action and select Mail from the get user profile from the dynamic content box. Name & save your flow and get the flow ID from the flow's address bar which you'll need in the JSON. Back in the list format the GetEmail column in advanced mode, delete the existing code and paste in the following JSON, changing the ID to your flow's ID { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Get email", "customRowAction": { "action": "executeFlow", "actionParams": "='{\"id\":\"88823897-8dd5-4452-934d-a980defd39a9\", \"headerText\":\" ' + [$Title] + '\",\"runFlowButtonText\":\"Get email\"}'" }, "style": { "background-color": "#cf000f", "color": "white", "border-radius": "10px" } } After you select the person, click the button and after a few seconds the Pick Email column will get populated. Rob Los Gallardos Microsoft Power Automate Community Super User
