User Profile
Rob_Elliott
Silver Contributor
Joined Apr 06, 2023
User Widgets
Recent Discussions
Re: Conditional formatting in lists using JSON condition is between numbers
dmann1 you can still have pills using a combination of background-color, border and border-radius as shown below: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if(@currentField <0, 'red', if(@currentField >= 0 && @currentField <= 2,'orange', if(@currentField >2 && @currentField <= 5,'white', if(@currentField > 5 && @currentField <= 10,'blue', 'green'))))", "padding-left": "15px", "font-size": "18px", "border-radius": "25px", "background-color": "=if(@currentField <0, 'white', if(@currentField >= 0 && @currentField <= 2,'#483d3b', if(@currentField >2 && @currentField <= 5,'#119cb7', if(@currentField > 5 && @currentField <= 10,'#f5eec9', 'gray'))))", "border": "1px solid #bbb" } } Rob Los Gallardos Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: Collapsible Headings Changed
This is an unwelcome recent design change by Microsoft that users at my company are complaining about. But there is no setting to force it to display on a single line. I have spent today suggesting to our users that they add an accordion web part using JSON column formatting. It works but is not really a substitute for an unnecessary and stupid change by Microsoft. Rob Los Gallardos Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: Conditional formatting in lists using JSON condition is between numbers
dmann1 you can do this with a shorter json code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if(@currentField <3, 'red', (if(@currentField >= 3 && @currentField <= 5,'orange', 'green'))", "padding-left": "15px", "font-size": "18px", "font-weight": "bold" } } Rob Los Gallardos Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: Afficher une image de bonne qualité quand elle s'affiche en grand
This is a known problem due to the compression Microsoft uses. Make sure you use a png image but you'll have to experiment with different images sizes to get the one where the quality is best. Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: Sharepoint button to run a Power Automate flow.
RicardoBDR to display only a specific file type you could add the following: "display": "=if([$File_x0020_Type] == 'png', 'inline-block', 'none')" To display the button only for files but not folders add the following: "visibility": "=if([$File_x0020_Type] == '', 'hidden', 'visible')" And you could add both! A site I've always found very useful for seeing what's possible and grabbing the JSON is at https://pnp.github.io/List-Formatting/ Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: Automatically email supplier when their certificate expires
srk1407 as there might be empty dates in your SharePoint list then the flow will need to run slightly differently, using conditions as I mentioned before. My example list has empty dates and some dates that are after today. Create a string variable for each of the date columns. I've not shown them all here. Then create an array variable to hold the current item (you need this later): Next, add the Get items action with the filter query to only bring back those items where at least one of the date values is earlier than today: Add an apply to each and select value from the dynamic content box. Then add a Set variable, select the array variable you created and and add in [Current item] where you select Current item from the bottom of the dynamic content box. Next, still inside the apply to each, for each of the columns add a condition where the date is not equal to null and the date is less than today. So the ISO27001 for Anguilla which expires on 19 December won't display in the table. Add 2 compose actions in the If yes green channel. One to get the column data and the second one to format it to your date format (in my case dd/MM/yyyy) and set the variable using formatDateTime(outputs('formatDate'),'dd/MM/yyyy'). In the red if no channel add a compose action and set the variable to null. Next create your HTML table selecting the Title column from the SharePoint list and selecting the relevant variable. The format table compose action hasn't changed and there's only a slight change to the wording in the email. The flow runs successfully and doesn't give an error on empty dates. As you'll see, for Anguilla the columns where the expiry dates are in the future or there is no date just a shown a blank value. Only dates that exist and are before today are displayed. No email was sent at all for Guadeloupe as all the dates are in the future. Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: Mircosoft forms email
If you are using the send an email (v2) action in your flow the email will always come from you as the creator of the flow. If you don't want this you could create a shared mailbox so the email comes from the name of that shared mailbox. That's what we do at my company. Or you could create a service account to build your flows. Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: Custom Validation in Forms
Custom validation is not available in Forms. Regex for example was in the old Forms Pro (now called Customer Voice in Microsoft Dynamics) but for some reason was never implemented in standard Forms. Feature requests can be made on the official Microsoft Feedback Portal. The requests related to validation in Forms are at https://feedbackportal.microsoft.com/feedback/search/0ab9de26-ff1b-ec11-b6e7-0022481f8472?q=Validation However, Microsoft never seem to act on the requests! Rob Los Gallardos Microsoft Power Automate Community Super User Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: How to create a glossary page in Microsoft Lists [SharePoint]
Thanks Giuliano, this is really good and it works out-of-the-box. One thing I will look to add is a hyperlink column to a page or external website for full details or more information. Then I'll push this out to my company. Great stuff! Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Re: SharePoint Online Subsite Feature - Is it going to deprecate
My understanding is that the ability to create subsites will be removed but it won't affect already-existing subsites. Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
