User Profile
Rob_Elliott
Silver Contributor
Joined Apr 06, 2023
User Widgets
Recent Discussions
Re: JSON for list form body
If there is just a single field on a row it will always keep it just in the first column, it can't stretch over all the columns to full width. Rob Los Gallardos Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)7Views0likes0CommentsRe: 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)3Views0likes0CommentsRe: 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)20Views1like0CommentsRe: 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)40Views0likes0CommentsRe: Get email notification of each response to a specific mailbox
CraigPauley you would need to do this with a flow in Power Automate. A simple example is shown in the image below. Rob Los Gallardos Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)11Views0likes0CommentsRe: Partially pre-filled form
You can pre-fill responses and send out the pre-fill link to users. Details are at Pre-fill Responses in Your Microsoft Forms | Microsoft Community Hub Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)93Views1like0CommentsRe: Microsoft Form
I spent an hour today building a quick & dirty Power App based on SharePoint lists and that is shown in the attached video. As I said in my previous post this is not possible with Forms because it cannot connect to data, and it's not possible to do something for Forms with React, Python, SPFx, web developing or Power Automate (other than geting each response but then you need to do something with that). But yes, with Power Apps instead of Forms it's quite easy. Come back with any questions. Students Video Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)68Views0likes0CommentsRe: Microsoft Form
Hari2307 No this is not possible with Microsoft Forms. You can't pop-up or display the earlier details because Forms cannot connect to anything to be able to pre-populate data from a datasource. However, achieving this could be done with SharePoint lists and a Power Apps front end. Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)70Views1like0CommentsRe: 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)25Views0likes0CommentsRe: 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)86Views1like0CommentsRe: 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)0Views0likes0CommentsRe: 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)43Views0likes0CommentsRe: 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)34Views1like0CommentsRe: SharePoint Online Subsite Feature - Is it going to deprecate
Microsoft haven't published a definite date or any documentation about this. Rob Los Gallardos Microsoft Power Automate Community Super User. Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)146Views0likes0CommentsRe: 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)120Views0likes0CommentsRe: 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)157Views1like0Comments
Recent Blog Articles
No content to show