SharePoint List JSON Form Formatting & Validations (3)

[@365g]

Many thanks Reza - great video!. Shows just how much power exists in SharePoint as a standalone platform

[@RezaDorrani]

SharePoint is still alive and powerful

[@TheSourceresss]

Super useful - my brain is already concocting use-case scenarios! Thanks for taking the time to put this together.

[@RezaDorrani]

Glad to hear that. Thanks for watching.

[@londonengland2309]

Thanks Reza you are a star! I need to follow this over the weekend as I need to send an email once the status is complete.

[@RezaDorrani]

Enjoy the videos this weekend

[@umeshgaur6960]

I love all the videos, using json in list formatting helps me lots

[@RezaDorrani]

Happy to hear that

[@sadelina2763]

Thanks for this, I will do it tomorrow, and I will leave everyone with a square eye, I promise to give you the credits🙊

[@RezaDorrani]

Nice 👍 Go for it.

[@DanielADamico]

Reza is the synonym of awesome videos! Thanks for sharing! 👏👏

[@RezaDorrani]

Thank You Sir

[@TheMarkGross]

I didn't understand some of it but I think by trial and error i'll learn it. Appreciate the video

[@RezaDorrani]

Video description has links to sample code.

[@vinamrachandra9611]

Another great video. To get the internal names of columns, I copy the columns from List Settings, paste them in Excel and use an User Defined Function to extract the URL and then extract the name after the last =. Function GetURL(rng As Range) As String On Error Resume Next GetURL = rng.Hyperlinks(1).Address End Function One of my lists has 100+ columns. As a best practice, I always try to create columns without spaces in the name and then insert spaces or underscore etc in the Display name.

[@RezaDorrani]

Great tip! Thanks for sharing.

[@davidwebster2616]

Reza, once again, you are the man. 5:16 - I'm hitting my forehead on the desk wondering why my JSON code isn't picking up the columnname. I wasn't using the internal name of the column.

[@RezaDorrani]

Internal names are a must now

[@marocas68]

Top video Reza! You are a source of knowledge and inspiration.

[@RezaDorrani]

Thank you Mario

[@mails2jetti]

Thanks Reza, I will be learning new things in each of your vidoe. Thanks for sharing these.

[@RezaDorrani]

My pleasure!

[@mainguyen3097]

Your video is really helpful Reza. Thank you very much.

[@RezaDorrani]

You're welcome

[@jaganv8343]

Very very excellent video, by this JSON Customization will reduce a lot effort of developer. Even if we don't have requirement of other connectors, then I think no need to go development of Power Apps for responsiveness only.

[@RezaDorrani]

Agreed.

[@PowerPlatformDiv]

Your voice ,style of topic explanation , and your content Quality you compels us for watch full video 😎😊😊 like a magnate. It’s really amazing

[@RezaDorrani]

Thank you so much 😀

[@carlw]

Thanks again. We either learn this stuff through osmosis, using the force or from your videos.

[@RezaDorrani]

Glad to hear it!

[@imranozcanyay901]

I really like it. Thank you for doing this.

[@RezaDorrani]

My pleasure!

[@darrinkinney2268]

love you stuff. Digital smart forms are such a vital aspect of good project management and I honestly do not feel as they are user nearly enough.

[@RezaDorrani]

Agreed 100%

[@alzaimoor79]

Excellent session and tremendous effort, thanks for sharing 👏🏻

[@RezaDorrani]

Thanks for appreciating the effort.

[@codecat8430]

Amazing! Subscribed!

[@RezaDorrani]

Thanks for the sub!

[@bobknight1427]

Reza thanks for videos. You are really awesome. Thank you.!!!

[@RezaDorrani]

Thanks Bob

[@alexmleite14]

Thks for sharing!

[@RezaDorrani]

Most welcome

[@RPAChampion]

This is a great live 👏 🙌 👌 👍 ❤

[@RezaDorrani]

Thank You

[@spylkc]

Many thanks, Reza - excellent video! May you show more detail for the "Dynamic Multi-Steps Approvals Base on Expense Type"? I need help how to get the Approvers in the Sharepoint list. Thanks a lot.

[@RezaDorrani]

I have done 18 videos on approvals. They are all in my approvals playlist. I recommend checking that.

[@kamaa76]

Hi Reze , Nice one!! thanks to your videos which its help lot of users. any ways to format body column fields labels? Means the important fields I want change the filed label colour to Red. its posible?

[@RezaDorrani]

Body formatting is not an option at the moment. You would want to look at Power Apps for that.

[@prizim]

great video!

[@RezaDorrani]

Thanks

[@Poryotis]

Thank you for the great video. Is there a way to display the read-only fields like the Created, Created By, Modified, etc. Tried including them in the sections but they would not display

[@RezaDorrani]

Currently, those read only columns are not available in the form customization. I wish it was. One subscriber did mention that if you create a calculated column that gets its data from those read only columns, then you could include them in the form. I have not tried it, but worth a shot.

[@zghaboos]

@@RezaDorrani Hello. Just tried the calculated column which reads a single text column and those don't work... oh well, I'm sure they'll figure that one out soon!

[@RezaDorrani]

@@zghaboos I hope they do :)

[@thomasvdb9736]

Hi Reza thanks a lot for the video!!! Is there a way to add clickable button to trigger a power automate flow in the forms view? i seem to only to make it work in the list view :(

[@RezaDorrani]

Currently calling a flow is not supported.

[@stlaurent26]

Great video .. is there a way to wrap column headers on MS list? The default is no-wrap, which doesn't work for long column names

[@RezaDorrani]

I don’t think we have an option for that

[@N4ncnPq]

GREAT!!

[@RezaDorrani]

Thanks

[@dddonohue8172]

Awesome video. I noticed when you added your json formatting to the list, 3 columns were displayed across the canvas. When I did it, only 2 columns across the canvas. Can the width of the canvas be increased to allow more columns across? I noticed as I pulled my browser to widen it, the form remained the same size with only 2 columns. Do you know how this value is set and why it would be different between your build and mine?

[@RezaDorrani]

That width is set automatically depending upon window width. You may have to refresh the web page to see the updates.

[@ramonseila]

Thank you very much Reza Dorrani!! Excellent! A doubt, I have a column of the type hyperlink or image, would there be any way to display this image Url in the header?

[@RezaDorrani]

I believe that is possible. Check the documentation - docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

[@alexmacedo2620]

Great video as always, Reza! Do you whether it is possible or not to have a group of fields not available for editing when someone belongs to a SharePoint group?

[@RezaDorrani]

Possible but in Power Apps not with the JSON formatting. I am working on a video around role based column editing in Power Apps which will cover exactly the scenario you mentioned.

[@coolbeing163]

thanks Reza one more time for this fantastic video. I was just wondering if there is a way to perform validation more than show/hide of column?? Can we display error message based on drop down value selected or similar like in SharePoint online list form??

[@RezaDorrani]

Possible by using the list validation settings and writing expressions there. I think I covered it in one of my videos. Check this playlist kzbin.info/aero/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf

[@shin81able]

Hi, cool video, is it possible to add different contact email address? Is it also possible to add an button to add a new item to this list instead of going to the standard version?

[@RezaDorrani]

is it possible to add different contact email address? - You can create multiple person type columns and user can pick any user from AD Is it also possible to add an button to add a new item to this list instead of going to the standard version? - Add button opens the custom form. Not sure what you mean by standard version.

[@zghaboos]

Great video as always... you helped me avoid building a power app! Have you managed to get object variables in the header to work at all? Eg put a person's name in the header or a lookup column value?

[@RezaDorrani]

It does act up for complex data types. I'm sure these will be fixed soon. Here is my ull playlist which has more scenarios covered: kzbin.info/aero/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf

[@yogeshvipradas]

Hi Reza, Great video, really helpful. Is it possible to show the map based on the location field withing the form formatting?

[@RezaDorrani]

Check kzbin.info/www/bejne/amGxe4Ktrsmtfqc

[@ilana4014]

Thanks Reza for this awesome video. May I ask an additional question? Is there a possibility to check the default language or site language of the users choice and then display the cells/columns according to the language?

[@RezaDorrani]

The schema does not have a formula to check the default language or site language today developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json

[@Liamscott92]

Hi Reza, fandtastic video! Is it possible to add a button to trigger a flow in the header or footer? Similar to a column list view formatting?

[@RezaDorrani]

Unfortunately not. Currently, this is not supported.

[@pradeeppiplawa4013]

Hey Reza Great Video. I was wondering if there is any way to conditionally hide columns based on form type i.e new form or edit form?

[@RezaDorrani]

That option is currently not available.

[@sundrapillay6668]

Thanks Reza

[@RezaDorrani]

Most welcome

[@FamilyPlays22]

Hello friend, excellent video. Is it possible to hide and show entire sections like fields? That way I wouldn't have to hide every field in a section. Thanks for sharing your knowledge.

[@RezaDorrani]

Hide/Show sections is currently not supported.

[@tommyrihu824]

Reaza great work, but can i use lookup columns in the list form i see alla other columns in the list form but not the lookup columns, Thanks!

[@RezaDorrani]

I believe you can. Not sure why it wont show up on forms for you.

[@tommyrihu824]

@@RezaDorrani Thanks. but the Lookup Columns does not show in the list form more then one

[@RezaDorrani]

@@tommyrihu824 I don’t know why that is happening

[@chaddytee726]

as always great stuff Reza!, question: can you make a field like status read-only? so when a user opens the form the status field cannot be edited?

[@RezaDorrani]

This feature only supports formatting. To make field read-only based on status, you would need to use Power Apps

[@chaddytee726]

@@RezaDorrani Thanks Reza!, one more question, when you use json in the body of the form, can you split the form with different layouts? e.g top half is two rows of three, then under that is maybe a section that is just two columns? hope that makes sense - luv your work!

[@RezaDorrani]

@@chaddytee726 One cannot define how the columns will be displayed in sections. It automatically places it in the sections.

[@marieraymond6512]

Hey Reza, Is it possible to format the view names at the top pf the list in classic experience?

[@RezaDorrani]

Classic SharePoint does not support json formatting

[@akshaykathuria06]

Great video. Can we also increase column width in body section? For example - Increase width of Condition Notes column

[@RezaDorrani]

Currently, No option to increase width.

[@akshaykathuria06]

@@RezaDorrani Thank you Reza. Appreciate your response. I'm delivering my first few json forms today in public health sector in Australia. All thanks to you. Your videos have been a great reference.

[@RezaDorrani]

@@akshaykathuria06 Best of luck

[@akshaykathuria06]

@@RezaDorrani Thanks.

[@shin81able]

Do you also have a video how to mange 100+ images in sharepoint? Or are there any tipps should I use assets or list?

[@RezaDorrani]

I do not have a video reference on this scenario. 100+ images would be best to store in doc libraries.

[@Bhagotras]

Which permission will impact editing the JSON by user on the list column and form?

[@RezaDorrani]

I believe its Edit permission.

[@dieterleyendecker5685]

Hi Reza, many thanks for that very helpful video. Unfortunately the link to the PnP Samples doesn't work anymore. can you fix it or send me the correct link?

[@RezaDorrani]

They changed the link :) Here is the updated one - pnp.github.io/List-Formatting/

[@eddyfeys]

Hi, Reza, is working in JSON Form Formatting also possible when your field on which you want to rely is a managed metadata choice field ?

[@RezaDorrani]

I believe MMS columns are not currently supported.

[@eddyfeys]

@@RezaDorrani any chance it will become in the future in your opinion?

[@RezaDorrani]

@@eddyfeys Hopefully it would.

[@davidwebster2616]

Reza, is it possible to disable a column in a OOTB sharepoint list form based on a condition like a column status?

[@RezaDorrani]

Disable columns is currently not an option.

[@suneelrvishwakarma]

Hi, can we highlight the duplicate values in a particular column?

[@RezaDorrani]

That is currently not an option with JSON formatting.

[@sandyspringer55]

Is there anyway to input a search above the assets manager on the SharePoint page for a large number of assessts

[@RezaDorrani]

I am not aware of an option to do that

[@WELUVYOU-REDD]

My first comment. ❤ where can we get the json header template to copy and paste it? Hope to hear from you?

[@RezaDorrani]

Thanks! Did you check the link in video description?

[@daxteoh27]

Hi Reza, is it possible to line break in displayname (ie title)?

[@daxteoh27]

I would like create body title like this: By submitting this form, you must checked (a) XXXX (b) XXXX field

[@daxteoh27]

I tried doesn't work

[@RezaDorrani]

May be possible. Check with twitter.com/techan_k or check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint

[@KOSMOS_Commercial_Management]

I would like something like this for a Quality Assurance process with documents. Is there any recommended consultants that do this type fo set up regularly and could provide a quote? Thanks!

[@RezaDorrani]

I am not aware of consultants who do this.

[@aaaaa601]

👍Thks Resa, where is source of json header please, ?

[@RezaDorrani]

Video description has all the links.

[@aasheekakarkee4800]

Hi Reza, I want give permission to user to read or read and write only based on the stage value . What factors should i consider in formatting json so that based on stage value, user can either just read or sometimes can write value on it too?

[@RezaDorrani]

Json is only for formatting data. You cannot set permissions or make fields read-only with it.

[@mardithpascua8112]

Hi Reza, is it possible to make specific fields in New/Edit Form read-only/disabled using the BODY Json Formatting?

[@RezaDorrani]

I don’t think there is currently an option to make field read only with JSON formatting

[@robinjamesnjarlely]

Waiting

[@RezaDorrani]

Hope it’s worth the wait

[@sonaligaikwad8858]

Can we auto populate field data based on another column data using JSON?

[@RezaDorrani]

I don’t believe that is possible as of now.

[@gkz871]

Hi Reza, why my default list form there is not a edit icon there? only a cross to close and show comments icon....OK, found it, in details mode Thank you share...

[@RezaDorrani]

Looks like you got the answer!

[@emilioroqueta4445]

Hi Reza, is there any way with JSON to show a Field in "read mode" in the Sharepoint List form? Because this Field is completing only in a Power App and I do not want that someone change it in SharePoint. Thanks in advance

[@RezaDorrani]

JSON form formatting only allows formatting. Not possible to change field modes as of today.

[@einjhelle0018]

I'm wondering if can we link a list to another list?

[@RezaDorrani]

Yes, you can add anchor tags - docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#create-clickable-actions

[@Ganeshaithandal]

Can you share the JSON code that you showed in the Video?

[@RezaDorrani]

Video description has link to download the JSON code from my GitHub repo

[@bambaseye]

Thanks Reza for the video! is it possible to use person column on the header ? I try [$ColumnName.title] or [$ColumnName.email] without success.

[@bambaseye]

it works but only in new mode not in view or edit mode

[@RezaDorrani]

Known issue. Works when you click on the control. That was one of the reasons why I avoided it as part of my demo.

[@bambaseye]

@@RezaDorrani Thanks Reza. in my use case, the user could use the form to update their photo

[@RezaDorrani]

@@bambaseye Currently, not possible. Hopefully, more options open up in future.

[@shin81able]

Hi is there a way to remove the list element automatically if the date is over and archive?

[@RezaDorrani]

Not with list formatting. You may want to look at flow for that.

[@shin81able]

@@RezaDorrani thanks for your response. So can you maybe make a video where it shows how to handle such a case?

[@RezaDorrani]

@@shin81able I make videos when I receive multiple requests on a topic. I have video ideas with over 30+ requests in my backlog.

[@shin81able]

@@RezaDorrani OK I see thanks

[@nerdgal]

How would I change the font in the body

[@RezaDorrani]

I don't believe that is an option.

[@nerdgal]

@@RezaDorrani awww that sucks.. my boss is obsessed with Cambria which makes life a bit difficult for me thanks for the response

[@RezaDorrani]

Never heard of "Cambria"

[@suthanchidambaram3880]

Hi Reza I want to remove "New Item" ribbon while creating a new entry to the list and also want to set the current user email id to people field. Please help me....

[@RezaDorrani]

New Item ribbon cannot be changed using JSON. It will show up depending upon user access to SharePoint list.

[@suthanchidambaram3880]

@@RezaDorrani is there any other way to remove that. And I also want to auto populate email id field with the current user's E-mail ID. Please help...

[@RezaDorrani]

@@suthanchidambaram3880 Create a Power App from the SharePoint list. I do not have a video based on your scenario. I will recommend checking on the forums at powerusers.microsoft.com

[@hokki28]

Where can I find a reference for the functions I can use in the JSON code?

[@RezaDorrani]

developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json Not all features are supported for form formatting and I did not see any official documentation on what is supported.

[@manoharmeesala3827]

can we achieve 'fetching data from another list' without Rest-API calls & Lookup?? using JSON formatting mechanism.

[@RezaDorrani]

No. JSON formatting is only to format data.

[@manoharmeesala3827]

@@RezaDorrani Okay, Thank you BTW it's an excellent session.

[@manoharmeesala3827]

@@RezaDorrani and one more doubt, can we make a lookup column as an 'auto-complete' textbox, unlike drop-down.

[@RezaDorrani]

@@manoharmeesala3827 Only formatting is allowed. No changing control types. For those kind of changes, you will need Power Apps.

[@dilipkampa6526]

Hi Reza when using Json formatting, SharePoint list is showing alot of performance degradation. There are hardly 30-40 items but page loading takes more than 15 seconds to load up. Any solution for that ? Thank you

[@RezaDorrani]

Did not experience this. I have a client using a list with around 15-20 formats but works fine. I would recommend you raise a ticket with Microsoft to check on the issue.

[@ylmazozturk06]

hi, how do i convert this code to json code

[@RezaDorrani]

I'm not sure about this. Check on the forums techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint or connect with twitter.com/techan_k

[@yojanamhatre8875]

How can we add tabs in list ?

[@RezaDorrani]

The body JSON only allows creating sections and no other formatting is allowed. You would have to use Power Apps to create tabs - kzbin.info/aero/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR

[@icarooliveira2688]

how i can put img to my list header sharepoint view? someone have any script?

[@RezaDorrani]

SharePoint view or form? Video shows how to add image on form. I have a playlist on SharePoint list formatting. You can check that.

[@icarooliveira2688]

@@RezaDorrani i saw your vídeos i really apreciate but Just need a symple script that i can input image column data on header sharepoint list. Your solution vídeos it' s to much advanced for me

[@RezaDorrani]

@@icarooliveira2688 Most of list formatting videos have samples shared. Links in video description. If you need any additional help, I would recommend checking or posting on SharePoint Forums.

[@MultiChris7777]

I cannot find Validation Settings under "List Setting"

[@RezaDorrani]

social.technet.microsoft.com/Forums/office/en-US/187771bf-b60b-46b4-b871-9d593627b69d/missing-validation-settings-under-general-settings

[@thrilled2bits]

Note: validation doesn't work against metadata fields - those fields are not available / visible. Silly of MS....

[@RezaDorrani]

Certain field types are currently not supported.

[@learnalittleeveryday7848]

The final part (page setup) is dangerous and therefore becomes useless. If a user makes more than one selection the asset reference becomes blank and is automatically saved as blank changing the record. If it is a mandatory field, the properties area just displays the field and a save button. Deselecting the asset reference safely returns you back but it is unclear that that is the action required. Making the whole properties record read only doesn’t really work either . The only solution is if the user is only allowed to make one selection at a time in the asset reference list on the left. Unless there is a clever validation I am missing. Shame as it so close to being useful

[@RezaDorrani]

I believe there is a way to avoid showcasing the selection option. In the formatting itself, a link or icon can be provided to launch the properties.

[@learnalittleeveryday7848]

@@RezaDorrani Thank you for taking the time to reply. A good idea hampered by a flaw in the design, as is the MS way.

[@raffaelecastaldo1143]

Non metti il casco perchè non sei una persona molto intelligente!

[@RezaDorrani]

?